Multimaster sqlgen load causes
mysqld: /home/teemu/codership/galera/bzr/codership-mysql/5.5/sql/sql_parse.cc:4895: int mysql_execute_command(THD*): Assertion `!thd->in_active_multi_stmt_transaction() || thd->in_multi_stmt_transaction_mode()' failed.
if wsrep_retry_autocommit=1.
Full backtrace:
(gdb) bt #0 __pthread_kill (threadid=<optimized out>, signo=<optimized out>) at ../nptl/sysdeps/unix/sysv/linux/pthread_kill.c:63 #1 0x0000000000808028 in my_write_core (sig=6) at /home/teemu/codership/galera/bzr/codership-mysql/5.5/mysys/stacktrace.c:433 #2 0x00000000006cbb35 in handle_fatal_signal (sig=6) at /home/teemu/codership/galera/bzr/codership-mysql/5.5/sql/signal_handler.cc:247 #3 <signal handler called> #4 0x00007fb5c52c8425 in __GI_raise (sig=<optimized out>) at ../nptl/sysdeps/unix/sysv/linux/raise.c:64 #5 0x00007fb5c52cbb8b in __GI_abort () at abort.c:91 #6 0x00007fb5c52c10ee in __assert_fail_base (fmt=<optimized out>, assertion=0xa90a58 "!thd->in_active_multi_stmt_transaction() || thd->in_multi_stmt_transaction_mode()", file=0xa90378 "/home/teemu/codership/galera/bzr/codership-mysql/5.5/sql/sql_parse.cc", line=<optimized out>, function=<optimized out>) at assert.c:94 #7 0x00007fb5c52c1192 in __GI___assert_fail ( assertion=0xa90a58 "!thd->in_active_multi_stmt_transaction() || thd->in_multi_stmt_transaction_mode()", file=0xa90378 "/home/teemu/codership/galera/bzr/codership-mysql/5.5/sql/sql_parse.cc", line=4895, function=0xa91400 "int mysql_execute_command(THD*)") at assert.c:103 #8 0x00000000005a6956 in mysql_execute_command (thd=0x33a3c00) at /home/teemu/codership/galera/bzr/codership-mysql/5.5/sql/sql_parse.cc:4894 #9 0x00000000005a903b in mysql_parse (thd=0x33a3c00, rawbuf=0x7fb56401ab70 "UPDATE comm00 SET x = (x + 1) % 65537, y = ((y*x % 65537) + (9301*y % 65537) + (y*z % 65537)) % 65537, z = ((z*x % 65537) + (z*y % 65537) + (9301*z % 65537)) % 65537, r = RAND() WHERE r > 0.412359 AND"..., length=<optimized out>, parser_state=0x7fb596a99130) at /home/teemu/codership/galera/bzr/codership-mysql/5.5/sql/sql_parse.cc:6180 #10 0x00000000005a9291 in wsrep_mysql_parse (thd=0x33a3c00, rawbuf=0x7fb56401ab70 "UPDATE comm00 SET x = (x + 1) % 65537, y = ((y*x % 65537) + (9301*y % 65537) + (y*z % 65537)) % 65537, z = ((z*x % 65537) + (z*y % 65537) + (9301*z % 65537)) % 65537, r = RAND() WHERE r > 0.412359 AND"..., length=213, parser_state=0x7fb596a99130) at /home/teemu/codership/galera/bzr/codership-mysql/5.5/sql/sql_parse.cc:6012 #11 0x00000000005aa8f9 in dispatch_command (command=COM_QUERY, thd=0x33a3c00, packet=0x337b371 "UPDATE comm00 SET x = (x + 1) % 65537, y = ((y*x % 65537) + (9301*y % 65537) + (y*z % 65537)) % 65537, z = ((z*x % 65537) + (z*y % 65537) + (9301*z % 65537)) % 65537, r = RAND() WHERE r > 0.412359 AND"..., packet_length=<optimized out>) at /home/teemu/codership/galera/bzr/codership-mysql/5.5/sql/sql_parse.cc:1203 #12 0x00000000005acb71 in do_command (thd=0x33a3c00) at /home/teemu/codership/galera/bzr/codership-mysql/5.5/sql/sql_parse.cc:858 #13 0x0000000000655581 in do_handle_one_connection (thd_arg=<optimized out>) at /home/teemu/codership/galera/bzr/codership-mysql/5.5/sql/sql_connect.cc:887 #14 0x000000000065573d in handle_one_connection (arg=0x33a3c00) at /home/teemu/codership/galera/bzr/codership-mysql/5.5/sql/sql_connect.cc:799 #15 0x00007fb5c628de9a in start_thread (arg=0x7fb596a9a700) at pthread_create.c:308 #16 0x00007fb5c5385ccd in clone () at ../sysdeps/unix/sysv/linux/x86_64/clone.S:112 #17 0x0000000000000000 in ?? ()
Multimaster sqlgen load causes
mysqld: /home/teemu/ codership/ galera/ bzr/codership- mysql/5. 5/sql/sql_ parse.cc: 4895: int mysql_execute_ command( THD*): Assertion `!thd-> in_active_ multi_stmt_ transaction( ) || thd->in_ multi_stmt_ transaction_ mode()' failed.
if wsrep_retry_ autocommit= 1.
Full backtrace:
(gdb) bt <optimized out>, signo=<optimized out>) at ../nptl/ sysdeps/ unix/sysv/ linux/pthread_ kill.c: 63 codership/ galera/ bzr/codership- mysql/5. 5/mysys/ stacktrace. c:433 codership/ galera/ bzr/codership- mysql/5. 5/sql/signal_ handler. cc:247 sysdeps/ unix/sysv/ linux/raise. c:64 0xa90a58 "!thd-> in_active_ multi_stmt_ transaction( ) || thd->in_ multi_stmt_ transaction_ mode()" , teemu/codership /galera/ bzr/codership- mysql/5. 5/sql/sql_ parse.cc" , line=<optimized out>, <optimized out>) at assert.c:94 0xa90a58 "!thd-> in_active_ multi_stmt_ transaction( ) || thd->in_ multi_stmt_ transaction_ mode()" , teemu/codership /galera/ bzr/codership- mysql/5. 5/sql/sql_ parse.cc" , line=4895, 0xa91400 "int mysql_execute_ command( THD*)") at assert.c:103 command (thd=0x33a3c00) codership/ galera/ bzr/codership- mysql/5. 5/sql/sql_ parse.cc: 4894 0x7fb56401ab70 "UPDATE comm00 SET x = (x + 1) % 65537, y = ((y*x % 65537) + (9301*y % 65537) + (y*z % 65537)) % 65537, z = ((z*x % 65537) + (z*y % 65537) + (9301*z % 65537)) % 65537, r = RAND() WHERE r > 0.412359 AND"..., <optimized out>, parser_ state=0x7fb596a 99130) codership/ galera/ bzr/codership- mysql/5. 5/sql/sql_ parse.cc: 6180 0x7fb56401ab70 "UPDATE comm00 SET x = (x + 1) % 65537, y = ((y*x % 65537) + (9301*y % 65537) + (y*z % 65537)) % 65537, z = ((z*x % 65537) + (z*y % 65537) + (9301*z % 65537)) % 65537, r = RAND() WHERE r > 0.412359 AND"..., length=213, state=0x7fb596a 99130) at /home/teemu/ codership/ galera/ bzr/codership- mysql/5. 5/sql/sql_ parse.cc: 6012 0x337b371 "UPDATE comm00 SET x = (x + 1) % 65537, y = ((y*x % 65537) + (9301*y % 65537) + (y*z % 65537)) % 65537, z = ((z*x % 65537) + (z*y % 65537) + (9301*z % 65537)) % 65537, r = RAND() WHERE r > 0.412359 AND"..., length= <optimized out>) at /home/teemu/ codership/ galera/ bzr/codership- mysql/5. 5/sql/sql_ parse.cc: 1203 codership/ galera/ bzr/codership- mysql/5. 5/sql/sql_ parse.cc: 858 one_connection (thd_arg=<optimized out>) codership/ galera/ bzr/codership- mysql/5. 5/sql/sql_ connect. cc:887 one_connection (arg=0x33a3c00) codership/ galera/ bzr/codership- mysql/5. 5/sql/sql_ connect. cc:799 a700) at pthread_ create. c:308 unix/sysv/ linux/x86_ 64/clone. S:112
#0 __pthread_kill (threadid=
#1 0x0000000000808028 in my_write_core (sig=6) at /home/teemu/
#2 0x00000000006cbb35 in handle_fatal_signal (sig=6)
at /home/teemu/
#3 <signal handler called>
#4 0x00007fb5c52c8425 in __GI_raise (sig=<optimized out>) at ../nptl/
#5 0x00007fb5c52cbb8b in __GI_abort () at abort.c:91
#6 0x00007fb5c52c10ee in __assert_fail_base (fmt=<optimized out>,
assertion=
file=0xa90378 "/home/
function=
#7 0x00007fb5c52c1192 in __GI___assert_fail (
assertion=
file=0xa90378 "/home/
function=
#8 0x00000000005a6956 in mysql_execute_
at /home/teemu/
#9 0x00000000005a903b in mysql_parse (thd=0x33a3c00,
rawbuf=
length=
at /home/teemu/
#10 0x00000000005a9291 in wsrep_mysql_parse (thd=0x33a3c00,
rawbuf=
parser_
#11 0x00000000005aa8f9 in dispatch_command (command=COM_QUERY, thd=0x33a3c00,
packet=
packet_
#12 0x00000000005acb71 in do_command (thd=0x33a3c00)
at /home/teemu/
#13 0x0000000000655581 in do_handle_
at /home/teemu/
#14 0x000000000065573d in handle_
at /home/teemu/
#15 0x00007fb5c628de9a in start_thread (arg=0x7fb596a9
#16 0x00007fb5c5385ccd in clone () at ../sysdeps/
#17 0x0000000000000000 in ?? ()