mysqld crashes when shuts down under load
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
MySQL patches by Codership |
Fix Released
|
High
|
Seppo Jaakola | ||
Stable |
Invalid
|
Undecided
|
Unassigned | ||
Trunk |
Fix Released
|
High
|
Seppo Jaakola |
Bug Description
3-node cluster, sqlgen load:
./sqlgen --user=test --pswd=testpass --host=127.0.0.1 --port=3307 --tables=10 --rows=1000 --create=1 --duration=1200
When trying to shut down a node, I get the following:
090724 22:57:12 [Note] gcs_group.
090724 22:59:28 [Note] gcs_group.
090724 23:01:22 [Note] Got signal 15 to shutdown mysqld
090724 23:01:22 [Note] /home/alex/
090724 23:01:22 [Note] Event Scheduler: Purging the queue. 0 events
090724 23:01:22 [Note] WSREP: rollbacker thread exiting
mysqld: sql_class.h:1178: uint Diagnostics_
090724 23:01:22 - 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.
key_buffer_
read_buffer_
max_used_
max_threads=151
threads_connected=3
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd: 0x9e2a9c0
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 = 0x960923ac thread_stack 0x30000
/home/alex/
/home/alex/
[0xb7f3f400]
/lib/tls/
/lib/tls/
/home/alex/
/home/alex/
/home/alex/
/home/alex/
/home/alex/
/home/alex/
/home/alex/
/home/alex/
/home/alex/
/home/alex/
/home/alex/
/home/alex/
/lib/tls/
/lib/tls/
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=1
thd->killed=
Here is stack trace of the crash:
Program received signal SIGABRT, Aborted. nosegneg/ libc.so. 6 nosegneg/ libc.so. 6 nosegneg/ libc.so. 6 area::sql_ errno (this=0xab97d58) event:: do_apply_ event (this=0xa6224310, :apply_ event (this=0xa6224310, rli=0xaba7518) buf=0xa6231330 "^\226xJ\023", buf_len=130) at sql_parse.cc:8114 mysql-5. 1.36-2855/ galera/ lib/libmmgalera .so
[Switching to Thread 0xa6d2cb90 (LWP 4033)]
0x0056a402 in __kernel_vsyscall ()
(gdb) bt
#0 0x0056a402 in __kernel_vsyscall ()
#1 0x00976fd0 in raise () from /lib/i686/
#2 0x009789b1 in abort () from /lib/i686/
#3 0x0097039b in __assert_fail () from /lib/i686/
#4 0x0823b35a in Diagnostics_
at sql_class.h:1178
#5 0x0835551e in Rows_log_
rli=0xaba7518) at log_event.cc:7220
#6 0x082705d3 in Log_event:
at log_event.h:1058
#7 0x0825f110 in wsrep_bf_apply_rbr (ctx=0xab96fa0,
rbr_
#8 0x0826f7a7 in wsrep_bf_apply_cb (ctx=0xab96fa0, data=0xa6d2bf44)
at sql_parse.cc:8177
#9 0x006d695f in ?? ()
from /home/galera/