I have successfully installed sphinx 1.10-beta. I have also installed sphinxse for same
under MySQL Percona (5.1.53). I am able to create index and query against searchd daemon
successfully using PHP.
When I tried to use sphinxse, I was able to create following sample table successfully.
CREATE TABLE t1
id INTEGER UNSIGNED NOT NULL,
weight INTEGER NOT NULL,
query VARCHAR(3072) NOT NULL,
) ENGINE=SPHINX CONNECTION=“sphinx://localhost:9312/devidx”;
I get an error when running a select from this table.
mysql> SELECT * FROM t1 WHERE query=‘Part 100’;
ERROR 2013 (HY000): Lost connection to MySQL server during query
Following is from mysql log file.
110124 21:38:31 - mysqld got signal 11 ;
This could be because you hit a bug. It is also possible that this binary
or one of the libraries it was linked against is corrupt, improperly built,
or misconfigured. This error can also be caused by malfunctioning hardware.
We will try our best to scrape up some info that will hopefully help diagnose
the problem, but since we have already crashed, something is definitely wrong
and this may fail.
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 133990 K
bytes of memory
Hope that’s ok; if not, decrease some variables in the equation.
Attempting backtrace. You can use the following information to find out
where mysqld died. If you see no messages after this, something went
stack_bottom = 0x418880e0 thread_stack 0x40000
/usr/local/mysql/libexec/mysqld(mysql_lock_tables(THD*, st_table**, unsigned int,
unsigned int, bool*)+0x24c) [0x575f1c]
/usr/local/mysql/libexec/mysqld(lock_tables(THD*, TABLE_LIST*, unsigned int,
/usr/local/mysql/libexec/mysqld(open_and_lock_tables_derived (THD*, TABLE_LIST*,
/usr/local/mysql/libexec/mysqld(mysql_execute_command(THD*)+ 0x3fd) [0x58964d]
/usr/local/mysql/libexec/mysqld(mysql_parse(THD*, char*, unsigned int, char
/usr/local/mysql/libexec/mysqld(dispatch_command(enum_server _command, THD*, char*,
unsigned int)+0xa31) [0x590231]
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort…
thd->query at 0xadc0750 = SELECT * FROM t1 WHERE query=‘Part 100’
The manual page at http://dev.mysql.com/doc/mysql/en/crashing.html contains
information that should help you find out what is causing the crash.
110124 21:38:31 mysqld_safe Number of processes running now: 0
110124 21:38:31 mysqld_safe mysqld restarted
110124 21:38:31 [Warning] ‘–skip-locking’ is deprecated and will be removed in a future
release. Please use ‘–skip-external-locking’ instead.
110124 21:38:31 [Note] Flashcache bypass: disabled
110124 21:38:31 [Note] Flashcache setup error is : ioctl failed
InnoDB: The InnoDB memory heap is disabled
InnoDB: Mutexes and rw_locks use GCC atomic builtins
InnoDB: Compressed tables use zlib 1.2.3
110124 21:38:31 InnoDB: highest supported file format is Barracuda.
110124 21:38:31 Percona XtraDB ( http://www.percona.com ) 1.0.13-12.4 started; log
sequence number 66777398
110124 21:38:31 [Note] Recovering after a crash using mysql-bin
110124 21:38:31 [Note] Starting crash recovery…
110124 21:38:31 [Note] Crash recovery finished.
110124 21:38:32 [Note] Event Scheduler: Loaded 0 events
110124 21:38:32 [Note] /usr/local/mysql/libexec/mysqld: ready for connections.
Version: ‘5.1.53-log’ socket: ‘/tmp/mysql.sock’ port: 3306 Source distribution
I’ll appreciate any help with this.
I have tried rebuilding everything multiple times without any success.