sql_parse.cc:4895: int mysql_execute_command(THD*): Assertion `!thd->in_active_multi_stmt_transaction() || thd->in_multi_stmt_transaction_mode()' failed.
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL patches by Codership | Status tracked in 5.6 | |||||
5.5 |
Fix Released
|
Medium
|
Teemu Ollakka | |||
5.6 |
Fix Released
|
Medium
|
Teemu Ollakka | |||
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC | Status tracked in 5.6 | |||||
5.5 |
Fix Released
|
Undecided
|
Unassigned | |||
5.6 |
Fix Released
|
Undecided
|
Unassigned |
Bug Description
Multimaster sqlgen load causes
131025 16:35:37 [Note] WSREP: thd 2962 seqno 80940 BF aborted by provider, will replay
131025 16:35:37 [Note] WSREP: replaying increased: 1, thd: 2962
131025 16:35:37 [Note] WSREP: commit failed for reason: 4
131025 16:35:37 [Note] WSREP: conflict state: 4
131025 16:35:37 [Note] WSREP: COMMIT failed, MDL released: 2962
131025 16:35:37 [Note] WSREP: replay trx: COMMIT 80940
131025 16:35:37 [Note] WSREP: replay failed, rolling back
131025 16:35:37 [Note] WSREP: replaying decreased: 0, thd: 2962
131025 16:35:37 [Note] WSREP: BF Aborted, thd: 2962 is_AC: 0, retry: 0 - 1 SQL: COMMIT
131025 16:35:37 [Note] WSREP: wsrep retrying AC query: UPDATE comm03 SET x = (x + 1) % 65537, y = ((y*x % 65537) + (58749*y % 65537) + (y*z % 65537)) % 65537, z = ((z*x % 65537) + (z*y % 65537) + (58749*z % 65537)) % 65537, r = RAND() WHERE p = 2
mysqld: /home/teemu/
if wsrep_retry_
Full backtrace:
(gdb) bt
#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 ?? ()
description: | updated |
Possible reason for this is that thd->server_status is not saved to shadow before replay.