Mysql crashes after loading plugin

[biozshock]

Hi,

I've built handlersocket plugin with mysql source from ubuntu repo (need to patch handlersocket configure.in where it's getting mysql version info from mysql source).

When trying to load plugin from mysql cli mysql server crashes.

error.log says: thd: 0x21abf708 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... stack_bottom = (nil) thread_stack 0x30000 /usr/sbin/mysqld(my_print_stacktrace+0x2d) [0xd395ad] /usr/sbin/mysqld(handle_segfault+0x494) [0xa053d4] [0x12d400] /usr/lib/mysql/plugin/handlersocket.so(dena::dbcontext::init_thread(void const_, int volatile&)+0x23e) [0x75234e] /usr/lib/mysql/plugin/handlersocket.so(dena::hstcpsvr_worker::run()+0x38) [0x75a2d8] /usr/lib/mysql/plugin/handlersocket.so(dena::threaddena::worker_throbj::thread_main(void_)+0x13) [0x75e1e3] /lib/tls/i686/cmov/libpthread.so.0(+0x596e) [0x13396e] /lib/tls/i686/cmov/libc.so.6(clone+0x5e) [0x268a4e] Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at (nil) is an invalid pointer thd->thread_id=0 thd->killed=NOT_KILLED 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.

$ uname -a Linux ubuntu-server 2.6.32-25-generic #45-Ubuntu SMP Sat Oct 16 19:48:22 UTC 2010 i686 GNU/Linux $ cat /etc/lsb-release DISTRIB_ID=Ubuntu DISTRIB_RELEASE=10.04 DISTRIB_CODENAME=lucid DISTRIB_DESCRIPTION="Ubuntu 10.04.1 LTS"

[ahiguti]

Please try the newest version. The last commit fixes that HandlerSocket does not recognize mysql configuration options, which may cause a crash.

[biozshock]

same - mysql won't start. here's mysql error.log http://ubuntuone.com/p/OJh/

[ahiguti]

I installed ubuntu and reproduced the crash. I'll examine what's wrong.

[ahiguti]

You need to execute 'dpatch apply-all' inside mysql-dfsg-5.1-5.1.41 before building handlersocket. I found that 57_CVE-2010-1849.dpatch appends a field to struct st_net, which breaks binary compatibility.

[biozshock]

yep, thanks! that worked!

[kaiserbeto]

I'm getting the same error with mysql-advanced-gpl-5.1.52-linux-x86_64-glibc23. It'll load if I LOAD PLUGIN from within mysql, but once I add the conf options to my.cnf I get a crash similar to biozshock's.

This is CentOS 5.2 64bit

Thanks.