void Diagnostics_area::set_ok_status(ulonglong, ulonglong, const char*): Assertion `! is_set()' failed.
Affects | Status | Importance | Assigned to | Milestone | ||
---|---|---|---|---|---|---|
| MySQL patches by Codership |
Medium
|
Teemu Ollakka | |||
| 5.5 |
Undecided
|
Unassigned | |||
Percona XtraDB Cluster moved to https://jira.percona.com/projects/PXC | Status tracked in 5.6 | |||||
| 5.5 |
Won't Fix
|
Medium
|
Unassigned | ||
| 5.6 |
Fix Released
|
Medium
|
Unassigned |
Bug Description
=======
mysqld: /media/
21:37:02 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=19
connection_count=19
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: 0x1d9cd90
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 = 7f06b86f3ed8 thread_stack 0x40000
/pxc56/
/pxc56/
/usr/lib/
/usr/lib/
/usr/lib/
/usr/lib/
/usr/lib/
/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): 15
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
# 2013-10-03T03:07:25 [26414] Test completed with failure status STATUS_
# 2013-10-03T03:07:25 [26414] GenTest exited with exit status STATUS_
# 2013-10-03T03:07:25 [26414] Stopping server on port 19300
# 2013-10-03T03:07:25 [26414] Stale connection. Reconnecting
# 2013-10-03T03:07:25 [26414] Reconnect failed due to 2003:Can't connect to MySQL server on '127.0.0.1' (111)
# 2013-10-03T03:07:25 [26414] Server would not shut down properly. Terminate it
# 2013-10-03T03:07:25 [26414] Terminated process 26829
# 2013-10-03T03:07:25 [26414] Stopping server on port 19301
# 2013-10-03T03:07:25 [26414] Stale connection. Reconnecting
# 2013-10-03T03:07:25 [26414] Reconnect failed due to 2003:Can't connect to MySQL server on '127.0.0.1' (111)
# 2013-10-03T03:07:25 [26414] Server would not shut down properly. Terminate it
# 2013-10-03T03:07:25 [26414] Terminated process 26867
# 2013-10-03T03:07:25 [26414] [26414] runall-new.pl will exit with exit status STATUS_
perl runall-new.pl --basedir=/pxc56 --galera=ms --threads=16 --seed=tim 9.45s user 0.82s system 20% cpu 50.862 total
=======
Actually when node1 crashed with lp:1234395, node0 crashed with this error.
(gdb) bt
#0 0x00007f86f86780b1 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 0x00007f86f6a083d9 in raise () from /usr/lib/libc.so.6
#5 0x00007f86f6a097d8 in abort () from /usr/lib/libc.so.6
#6 0x00007f86f6a01506 in __assert_fail_base () from /usr/lib/libc.so.6
#7 0x00007f86f6a015b2 in __assert_fail () from /usr/lib/libc.so.6
#8 0x000000000072fbcc in Diagnostics_
at /media/
#9 0x000000000063b188 in my_ok (thd=thd@
at /media/
#10 0x000000000063aa30 in wsrep_replay_
#11 0x000000000075af8b in wsrep_mysql_parse (thd=thd@
at /media/
#12 0x000000000075be6d in dispatch_command (command=
at /media/
#13 0x000000000075d3c3 in do_command (thd=0x2821800) at /media/
#14 0x0000000000729a7d in do_handle_
#15 0x0000000000729ba5 in handle_
#16 0x00007f86f86730a2 in start_thread () from /usr/lib/
#17 0x00007f86f6ab843d in clone () from /usr/lib/libc.so.6
(
Attached gdb.txt
Tested with:
perl runall-new.pl --basedir=/pxc56 --galera=ms --mysqld=
Grammar files attached.
The " --mysqld=
Few more things:
main_da = {
m_is_sent = false,
m_can_
m_message = "\000uery execution was interrupted\
m_sql_errno = 1317,
m_sqlstate = "70100",
m_affected_rows = 0,
m_last_
m_statement
m_status = Diagnostics_
m_main_wi = {
m_warn_root = {
free = 0x7f04d4051d70,
used = 0x0,
pre_alloc = 0x0,
min_malloc = 32,
block_size = 2016,
block_num = 5,
},
m_warn_list = {
m_counter = 1
},
m_last = 0x7f04d4051ef0
},
members of I_P_List<
m_first = 0x7f04d4051d80
},
m_warn_count = {0, 0, 1},
m_
m_
m_warn_id = 130821,
m_
m_
m_read_only = false,
m_next_in_da = 0x0,
m_prev_in_da = 0x1d83ab8,
m_
<base_list> = {
members of base_list:
first = 0x149d720 <end_of_list>,
last = 0x1d83a90,
elements = 0
}, <No data fields>}
},
m_wi_stack = {
<
m_counter = 1
},
<
m_last = 0x1d83a80
},
members of I_P_List<
m_first = 0x1d83a00
}
},
Another thing, error checking is missing for wsrep->post_commit in wsrep_replay_
print *thd
Also, note that since this usually happens after other node crashes, you will need to run node0 with pc.ignore_sb=true (otherwise it won't proceed), the pxc randgen has this set by default.
Ran with --mysqld=
From following:
2013-10-09 00:54:58 43148 [Note] WSREP: TO BEGIN: 638, 2
2013-10-09 00:54:58 43148 [Note] WSREP: MDL conflict
request: (15 seqno 638 wsrep (2, 1, 0) cmd 3 9 DROP TABLE `table100_
granted: (12 seqno 639 wsrep (0, 2, 0) cmd 3 54 COMMIT)
2013-10-09 00:54:58 43148 [Note] WSREP: MDL ticket: type: shared read space: TABLE db: test name: table100_
2013-10-09 00:54:58 43148 [Note] WSREP: DROP caused BF abort
2013-10-09 00:54:58 43148 [Note] WSREP: MDL ticket: type: shared read space: TABLE db: test name: table100_
2013-10-09 00:54:58 43148 [Note] WSREP: wsrep_abort_thd, by: 139940104804096, victim: 139940105602816
2013-10-09 00:54:58 43148 [Note] WSREP: abort transaction: BF: DROP TABLE `table100_
2013-10-09 00:54:58 43148 [Note] WSREP: cluster conflict due to high priority abort for threads:
2013-10-09 00:54:58 43148 [Note] WSREP: Winning thread:
THD: 15, mode: total order, state: executing, conflict: no conflict, seqno: 638
SQL: DROP TABLE `table100_
2013-10-09 00:54:58 43148 [Note] WSREP: Victim thread:
THD: 12, mode: local, state: committing, conflict: no conflict, seqno: 639
SQL: COMMIT
2013-10-09 00:54:58 43148 [Note] WSREP: BF kill (1, seqno: 638), victim: (12) trx: 7691
2013-10-09 00:54:58 43148 [Note] WSREP: Aborting query: COMMIT
2013-10-09 00:54:58 43148 [Note] WSREP: kill trx QUERY_COMMITTING for 7691
2013-10-09 00:54:58 43148 [Note] [Debug] WSREP: galera/
2013-10-09 00:54:58 43148 [Note] WSREP: MDL conflict
request: (15 seqno 638 wsrep (2, 1, 0) cmd 3 9 DROP TABLE `table100_
granted: (12 seqno 639 wsrep (0, 2, 1) cmd 3 54 COMMIT)
2013-10-09 00:54:58 43148 [Note] WSREP: MDL ticket: type: shared read space: TABLE db: test name: table100_
2013-10-09 00:54:58 43148 [Note] WSREP: DROP caused BF abort
2013-10-09 00:54:58 43148 [Note] WSREP: MDL ticket: type: shared read space: TABLE db: test name: table100_
2013-10-09 00:54:58 43148 [Note] WSREP: wsrep_abort_thd, by: 139940104804096, victim: 139940105602816
2013-10-09 00:54:59 43148 [Note] WSREP: abort transaction: BF: DROP TABLE `table100_
2013-10-09 00:54:59 43148 [Note] WSREP: cluster conflict due to high priority abort for threads:
2013-10-09 00:54:59 43148 [Note] WSREP: Winning thread:
THD: 15, mode: total order, state: executing, conflict: no conflict, seqno: 638
SQL: DROP TABLE `table100_
2013-10-09 00:54:59 43148 [Note] WSREP: Victim thread:
THD: 12, mode: local, state: committing, conflict: must abort, seqno: 639
SQL: COMMIT
2013-10-09 00:54:5...
vardir (but only node0/mysql.err should be of interest in this bug). This is with wsrep/galera debug enabled.
Changed in codership-mysql: | |
status: | New → In Progress |
importance: | Undecided → Medium |
assignee: | nobody → Teemu Ollakka (teemu-ollakka) |
milestone: | none → 5.6.14-24.1 |
Teemu Ollakka (teemu-ollakka) wrote : | #10 |
Workaround pushed in: http://
Changed in codership-mysql: | |
status: | In Progress → Fix Committed |
Added 5.5 components, since port to 5.5/5.5-23 is required.
Changed in codership-mysql: | |
status: | Fix Committed → Fix Released |
Percona now uses JIRA for bug reports so this bug report is migrated to: https:/
The crash in https:/ /bugs.launchpad .net/percona- xtradb- cluster/ +bug/1234395 is masking this one since I am not getting many crashes with this since most of the times it is crashing with former.