Mantis Bugtracker
Main | My View | View Issues | Change Log | Roadmap | Docs
  

Viewing Issue Simple Details [ Jump to Notes ] [ View Advanced ] [ Issue History ] [ Print ]
ID Category Severity Reproducibility Date Submitted Last Update
0000529 [Sphinx] sphinxse crash always 2010-06-14 18:28 2010-07-04 14:19
Reporter m00dawg View Status public  
Assigned To
Priority normal Resolution open  
Status new   Product Version 0.9.9-rc2
Summary 0000529: SphinxSE crashes when using MariaDB 5.1.47
Description I have attempted to build both 0.9.9 and SVN (r2327). The built works though I am only building the plugin (instead of compiled in by using ./configure --with-plugins=sphinx). I basically copy the files in .libs (under storage/sphinx in the MySQL source tree) and copy them to my plugin directory. I then install using the INSTALL PLUGIN syntax.

All that works, but as soon as I try to run a "SHOW CREATE TABLE" against my Sphinx table, or otherwise use it, I get:

Jun 10 15:51:56 mcp mysqld: 100610 15:51:56 [Warning] Storage engine 'SPHINX' has conflicting typecode. Assigning value 43.
Jun 10 15:51:58 mcp mysqld: 100610 15:51:58 [ERROR] mysqld got signal 11 ;
Jun 10 15:51:58 mcp mysqld: This could be because you hit a bug. It is also possible that this binary
Jun 10 15:51:58 mcp mysqld: or one of the libraries it was linked against is corrupt, improperly built,
Jun 10 15:51:58 mcp mysqld: or misconfigured. This error can also be caused by malfunctioning hardware.
Jun 10 15:51:58 mcp mysqld: We will try our best to scrape up some info that will hopefully help diagnose
Jun 10 15:51:58 mcp mysqld: the problem, but since we have already crashed, something is definitely wrong
Jun 10 15:51:58 mcp mysqld: and this may fail.
Jun 10 15:51:58 mcp mysqld:
Jun 10 15:51:58 mcp mysqld: key_buffer_size=4194304
Jun 10 15:51:58 mcp mysqld: read_buffer_size=131072
Jun 10 15:51:58 mcp mysqld: max_used_connections=4
Jun 10 15:51:58 mcp mysqld: max_threads=153
Jun 10 15:51:58 mcp mysqld: threads_connected=2
Jun 10 15:51:58 mcp mysqld: It is possible that mysqld could use up to
Jun 10 15:51:58 mcp mysqld: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_threads = 338617 K
Jun 10 15:51:58 mcp mysqld: bytes of memory
Jun 10 15:51:58 mcp mysqld: Hope that's ok; if not, decrease some variables in the equation.
Jun 10 15:51:58 mcp mysqld:
Jun 10 15:51:58 mcp mysqld: thd: 0x7fba8b68b8d0
Jun 10 15:51:58 mcp mysqld: Attempting backtrace. You can use the following information to find out
Jun 10 15:51:58 mcp mysqld: where mysqld died. If you see no messages after this, something went
Jun 10 15:51:58 mcp mysqld: terribly wrong...
Jun 10 15:51:58 mcp mysqld: stack_bottom = 0x7fba8c444e98 thread_stack 0x48000
Jun 10 15:51:58 mcp mysqld: /usr/sbin/mysqld(my_print_stacktrace+0x39)[0x7fba92df8829]
Jun 10 15:51:58 mcp mysqld: /usr/sbin/mysqld(handle_segfault+0x3bd)[0x7fba92a571bd]
Jun 10 15:51:58 mcp mysqld: /lib/libpthread.so.0(+0xf8f0)[0x7fba920918f0]
Jun 10 15:51:58 mcp mysqld: /lib/libc.so.6(+0x83022)[0x7fba91097022]
Jun 10 15:51:58 mcp mysqld: /usr/lib/mysql/plugin/ha_sphinx.so(+0x94d5)[0x7fba8f96d4d5]
Jun 10 15:51:58 mcp mysqld: /usr/lib/mysql/plugin/ha_sphinx.so(_ZN9ha_sphinx4openEPKcij+0x194)[0x7fba8f96da54]
Jun 10 15:51:58 mcp mysqld: /usr/sbin/mysqld(_ZN7handler7ha_openEP8st_tablePKcii+0x3e)[0x7fba92b3d02e]
Jun 10 15:51:58 mcp mysqld: /usr/sbin/mysqld(_Z21open_table_from_shareP3THDP14st_table_sharePKcjjjP8st_tableb+0x5a4)[0x7fba92aa9b74]
Jun 10 15:51:58 mcp mysqld: /usr/sbin/mysqld(+0x3c4dee)[0x7fba92aa0dee]
Jun 10 15:51:58 mcp mysqld: /usr/sbin/mysqld(_Z10open_tableP3THDP10TABLE_LISTP11st_mem_rootPbj+0x894)[0x7fba92aa4914]
Jun 10 15:51:58 mcp mysqld: /usr/sbin/mysqld(_Z11open_tablesP3THDPP10TABLE_LISTPjj+0x5f4)[0x7fba92aa5424]
Jun 10 15:51:58 mcp mysqld: /usr/sbin/mysqld(_Z30open_normal_and_derived_tablesP3THDP10TABLE_LISTj+0x1f)[0x7fba92aa560f]
Jun 10 15:51:58 mcp mysqld: /usr/sbin/mysqld(_Z18mysqld_list_fieldsP3THDP10TABLE_LISTPKc+0x22)[0x7fba92b6f732]
Jun 10 15:51:58 mcp mysqld: /usr/sbin/mysqld(_Z16dispatch_command19enum_server_commandP3THDPcj+0x16eb)[0x7fba92a6ba4b]
Jun 10 15:51:58 mcp mysqld: /usr/sbin/mysqld(_Z10do_commandP3THD+0xe6)[0x7fba92a6bc46]
Jun 10 15:51:58 mcp mysqld: /usr/sbin/mysqld(handle_one_connection+0x129)[0x7fba92a5e049]
Jun 10 15:51:58 mcp mysqld: /lib/libpthread.so.0(+0x69ca)[0x7fba920889ca]
Jun 10 15:51:58 mcp mysqld: /lib/libc.so.6(clone+0x6d)[0x7fba910fa6cd]
Jun 10 15:51:58 mcp mysqld: Trying to get some variables.
Jun 10 15:51:58 mcp mysqld: Some pointers may be invalid and cause the dump to abort...
Jun 10 15:51:58 mcp mysqld: thd->query at 0x7fba947185f0 =
Jun 10 15:51:58 mcp mysqld: thd->thread_id=8319
Jun 10 15:51:58 mcp mysqld: thd->killed=NOT_KILLED
Additional Information I suspect the storage API was changed which may be causing this. This was from an upgrade of MariaDB (5.1.37 I believe) where SphinxSE worked like a champ using the instructions given above.
Tags No tags attached.
Attached Files

- Relationships

-  Notes
(0000795)
mpgjunky (reporter)
2010-07-04 14:13

 Same thing. Attempting to compile mysql 5.1.48, with 0.9.9. Compiles ok. make test fails:


rpl.rpl_slave_load_remove_tmpfile [ skipped ] Test needs debug binaries
rpl_ndb.rpl_ndb_2ndb [ disabled ] Bug#45974: rpl_ndb_2ndb fails sporadically
main.plugin_load [ fail ] Found warnings/errors in server log file!
        Test ended at 2010-07-04 17:58:56
line
100704 17:58:55 [Warning] Storage engine 'SPHINX' has conflicting typecode. Assigning value 42.
^ Found warnings in /sdb/mysql-5.1.48/mysql-test/var/log/mysqld.1.err
ok

 - saving '/sdb/mysql-5.1.48/mysql-test/var/log/main.plugin_load/' to '/sdb/mysql-5.1.48/mysql-test/var/log/main.plugin_load/'

Only 275 of 945 completed.
mysql-test-run: *** ERROR: Not all tests completed
make: *** [test-ns] Error 1

Using Gentoo: Linux gentoo2010 2.6.31-gentoo-r10 0000001 SMP Mon Apr 26 18:19:59 EEST 2010 i686 AMD Phenom(tm) 9850 Quad-Core Processor AuthenticAMD GNU/Linux
 in VirtuaBox.

gentoo2010 mysql-5.1.48 # gcc -v
Using built-in specs.
Target: i686-pc-linux-gnu
Configured with: /var/tmp/portage/sys-devel/gcc-4.3.4/work/gcc-4.3.4/configure --prefix=/usr --bindir=/usr/i686-pc-linux-gnu/gcc-bin/4.3.4 --includedir=/usr/lib/gcc/i686-pc-linux-gnu/4.3.4/include --datadir=/usr/share/gcc-data/i686-pc-linux-gnu/4.3.4 --mandir=/usr/share/gcc-data/i686-pc-linux-gnu/4.3.4/man --infodir=/usr/share/gcc-data/i686-pc-linux-gnu/4.3.4/info --with-gxx-include-dir=/usr/lib/gcc/i686-pc-linux-gnu/4.3.4/include/g++-v4 --host=i686-pc-linux-gnu --build=i686-pc-linux-gnu --disable-altivec --disable-fixed-point --enable-nls --without-included-gettext --with-system-zlib --disable-checking --disable-werror --enable-secureplt --disable-multilib --enable-libmudflap --disable-libssp --enable-libgomp --disable-libgcj --with-arch=i686 --enable-languages=c,c++,treelang,fortran --enable-shared --enable-threads=posix --enable-__cxa_atexit --enable-clocale=gnu --with-bugurl=http://bugs.gentoo.org/ [^] --with-pkgversion='Gentoo 4.3.4 p1.0, pie-10.1.5'
Thread model: posix
gcc version 4.3.4 (Gentoo 4.3.4 p1.0, pie-10.1.5)


Regards,
Michael.
(0000796)
mpgjunky (reporter)
2010-07-04 14:19

 for got to attach the configure script:


#!/bin/sh

make clean

./configure \
    --prefix=/usr/local/mysql \
    --with-readline \
    --with-ssl \
    --without-debug \
    --enable-shared \
    --with-embedded-server \
    --localstatedir=/var/lib/mysql \
    --with-unix-socket-path=/var/lib/mysql/mysql.sock \
    --with-mysqld-user="mysql" \
    --with-extra-charsets=all \
    --with-big-tables \
    --with-pic \
    --with-plugins=archive,federated,heap,innobase,innodb_plugin,myisam,myisammrg,sphinx \
    --enable-local-infile \
    --enable-largefile \
    --enable-thread-safe-client \
    --disable-dependency-tracking

- Issue History
Date Modified Username Field Change
2010-06-14 18:28 m00dawg New Issue
2010-07-04 14:13 mpgjunky Note Added: 0000795
2010-07-04 14:19 mpgjunky Note Added: 0000796

Copyright © 2000 - 2008 Mantis Group
Powered by Mantis Bugtracker