bool trans_check_state(THD*): Assertion `thd->transaction.stmt.is_empty()' failed in debug build
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
MySQL patches by Codership |
Confirmed
|
Medium
|
Unassigned | |||
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC | Status tracked in 5.6 | |||||
5.5 |
Invalid
|
Undecided
|
Unassigned | |||
5.6 |
New
|
Undecided
|
Unassigned |
Bug Description
BT:
(gdb) bt
#0 0x00007fcff47f40b1 in pthread_kill () from /usr/lib/
#1 0x0000000000941cbf in my_write_core (sig=6) at /media/
#2 0x00000000006d83ec in handle_fatal_signal (sig=6) at /media/
#3 <signal handler called>
#4 0x00007fcff2b843d9 in raise () from /usr/lib/libc.so.6
#5 0x00007fcff2b857d8 in abort () from /usr/lib/libc.so.6
#6 0x00007fcff2b7d506 in __assert_fail_base () from /usr/lib/libc.so.6
#7 0x00007fcff2b7d5b2 in __assert_fail () from /usr/lib/libc.so.6
#8 0x00000000007e7bc5 in trans_check_state (thd=thd@
#9 0x00000000007e83a3 in trans_rollback (thd=thd@
#10 0x0000000000638f5e in wsrep_rollback (thd=thd@
#11 0x000000000063995b in wsrep_commit_cb (ctx=ctx@
at /media/
#12 0x00007fcff20d6d5d in apply_trx_ws (recv_ctx=
commit_
#13 0x00007fcff20d99b0 in galera:
#14 0x00007fcff20dbefe in galera:
#15 0x00007fcff20baa19 in galera:
#16 0x00007fcff20bb90c in galera:
#17 0x00007fcff20dc11b in galera:
#18 0x00007fcff20ecc68 in galera_recv (gh=<optimized out>, recv_ctx=<optimized out>) at galera/
#19 0x0000000000639d10 in wsrep_replicati
#20 0x0000000000624a3e in start_wsrep_THD (arg=0x639cbc <wsrep_
#21 0x00007fcff47ef0a2 in start_thread () from /usr/lib/
#22 0x00007fcff2c3443d in clone () from /usr/lib/libc.so.6
Snip of error log:
=======
2013-10-03 02:05:34 8278 [Note] [Debug] WSREP: gcs/src/
2013-10-03 02:05:34 8278 [Note] [Debug] WSREP: galera/
2013-10-03 02:05:34 8278 [Note] [Debug] WSREP: galera/
2013-10-03 02:05:34 8278 [Note] [Debug] WSREP: galera/
2013-10-03 02:05:34 8278 [Note] [Debug] WSREP: galera/
2013-10-03 02:05:34 8278 [Note] [Debug] WSREP: galera/
2013-10-03 02:05:34 8278 [Note] [Debug] WSREP: galera/
2013-10-03 02:05:34 8278 [ERROR] Slave SQL: Error 'Table 'test.table1_
2013-10-03 02:05:34 8278 [Warning] WSREP: RBR event 1 Query apply warning: 1, 168
2013-10-03 02:05:34 8278 [Warning] WSREP: galera/
2013-10-03 02:05:34 8278 [Note] [Debug] WSREP: galera/
2013-10-03 02:05:34 8278 [Note] [Debug] WSREP: galera/
2013-10-03 02:05:34 8278 [Note] [Debug] WSREP: galera/
2013-10-03 02:05:34 8278 [Note] [Debug] WSREP: gcs/src/
2013-10-03 02:05:34 8278 [Note] [Debug] WSREP: galera/
2013-10-03 02:05:34 8278 [ERROR] Slave SQL: Error 'Table 'test.table100_
2013-10-03 02:05:34 8278 [Warning] WSREP: RBR event 1 Query apply warning: 1, 174
2013-10-03 02:05:34 8278 [Note] [Debug] WSREP: gcs/src/
2013-10-03 02:05:34 8278 [Warning] WSREP: galera/
2013-10-03 02:05:34 8278 [Note] [Debug] WSREP: gcs/src/
2013-10-03 02:05:34 8278 [Note] [Debug] WSREP: galera/
2013-10-03 02:05:34 8278 [Note] [Debug] WSREP: gcs/src/
2013-10-03 02:05:34 8278 [Note] [Debug] WSREP: galera/
2013-10-03 02:05:34 8278 [ERROR] Slave SQL: Could not execute Update_rows event on table test.table1_
2013-10-03 02:05:34 8278 [Warning] WSREP: RBR event 3 Update_rows apply warning: 120, 176
mysqld: /media/
20:35:34 UTC - mysqld got signal 6 ;
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.
Please help us make Percona Server better by reporting any
bugs at http://
key_buffer_
read_buffer_
max_used_
max_threads=153
thread_count=3
connection_count=3
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_
Hope that's ok; if not, decrease some variables in the equation.
Thread pointer: 0x7fcfcc0009a0
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 = 7fcff4a9daf0 thread_stack 0x40000
/pxc56/
/pxc56/
/usr/lib/
/usr/lib/
/usr/lib/
/usr/lib/
/usr/lib/
/pxc56/
/pxc56/
/pxc56/
/pxc56/
/pxc56/
/pxc56/
/pxc56/
/pxc56/
/pxc56/
/pxc56/
/pxc56/
/pxc56/
/pxc56/
/usr/lib/
/usr/lib/
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort.
Query (0): Connection ID (thread ID): 2
Status: NOT_KILLED
You may download the Percona Server operations manual by visiting
http://
in the manual which will help you identify the cause of the crash.
Writing a core file
=======
Attaching error logs and thread apply all bt full.
Got it with:
perl runall-new.pl --basedir=/pxc56 --galera=ms --mysqld=
It is the node2 which crashed.
summary: |
bool trans_check_state(THD*): Assertion - `thd->transaction.stmt.is_empty()' failed. + `thd->transaction.stmt.is_empty()' failed in debug build |
Changed in codership-mysql: | |
assignee: | nobody → Seppo Jaakola (seppo-jaakola) |
Changed in codership-mysql: | |
assignee: | Seppo Jaakola (seppo-jaakola) → Teemu Ollakka (teemu-ollakka) |
status: | New → In Progress |
importance: | Undecided → High |
milestone: | none → 5.6.14-24.1 |
Changed in codership-mysql: | |
assignee: | Teemu Ollakka (teemu-ollakka) → nobody |
status: | In Progress → Confirmed |
importance: | High → Medium |
milestone: | 5.6.14-25.1 → 5.6.14-25.2 |
Changed in codership-mysql: | |
milestone: | 5.6.15-25.2 → 5.6.16-25.3 |
Changed in codership-mysql: | |
milestone: | 5.6.16-25.5 → 5.6.17-25.6 |
The error log to be checked is node1.err (node0.err is very big - 136M, check it only if required).