Description:
060803 21:31:42 InnoDB: Started; log sequence number 0 61138
/usr/sbin/mysqld: ready for connections.
Version: '4.1.12-log' socket: '/tmp/mysql.sock' port: 3306 Source distribution
mysqld got signal 11;
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_size=268435456
read_buffer_size=1044480
max_used_connections=5
max_connections=512
threads_connected=5
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 1308668 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
thd=0x89a8e48
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...
Cannot determine thread, fp=0xa0c7db3c, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x81406c0
0xb75aed28
0x81acd7e
0x8174491
0x812289b
0x811fdc0
0x81204d7
0x81039de
0x8104299
0x8107aed
0x8192e81
0x8153801
0x8157bf2
0x81517f9
0x815143e
0x8150c35
0xb75a8dec
0xb7426e8a
New value of fp=(nil) failed sanity check, terminating stack trace!
Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved
stack trace is much more helpful in diagnosing the problem, so please do
resolve it
Trying to get some variables.
Some pointers may be invalid and cause the dump to abort...
thd->query at 0x89c7328 = DELETE FROM persistent_room WHERE clan_id > -1 AND (SELECT COUNT(*) FROM clan_member WHERE clan_member.clan_id = persistent_room.clan_id) = 0
thd->thread_id=5
The manual page at http://www.mysql.com/doc/en/Crashing.html contains
information that should help you find out what is causing the crash.
[root@LDB01 mysql]# resolve_stack_dump -s /tmp/mysqld.sym var/call_stack
0x81406c0 handle_segfault + 356
0xb75aed28 _end + -1357704972
0x81acd7e _Z11make_selectP8st_tableyyP4ItemPi + 62
0x8174491 _ZN4JOIN8optimizeEv + 857
0x812289b _ZN30subselect_single_select_engine4execEv + 351
0x811fdc0 _ZN14Item_subselect4execEv + 32
0x81204d7 _ZN24Item_singlerow_subselect7val_intEv + 19
0x81039de _ZN14Arg_comparator18compare_int_signedEv + 22
0x8104299 _ZN12Item_func_eq7val_intEv + 45
0x8107aed _ZN13Item_cond_and7val_intEv + 65
0x8192e81 _Z12mysql_deleteP3THDP13st_table_listP4ItemP11st_sql_listmm + 1673
0x8153801 _Z21mysql_execute_commandP3THD + 3997
0x8157bf2 _Z11mysql_parseP3THDPcj + 166
0x81517f9 _Z16dispatch_command19enum_server_commandP3THDPcj + 893
0x815143e _Z10do_commandP3THD + 122
0x8150c35 handle_one_connection + 829
0xb75a8dec _end + -1357729352
0xb7426e8a _end + -1359310250
How to repeat:
DELETE FROM persistent_room WHERE clan_id > -1 AND (SELECT COUNT(*) FROM clan_member WHERE clan_member.clan_id = persistent_room.clan_id) = 0
