MySQL Bugs: #34404: mysqld randomly got signal 11

Bug #34404	mysqld randomly got signal 11
Submitted:	8 Feb 2008 7:59	Modified:	8 Feb 2008 8:29
Reporter:	Dmitry Labutin	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server: General	Severity:	S1 (Critical)
Version:	5.0.51a	OS:	Linux (Fedora 8)
Assigned to:		CPU Architecture:	Any
Tags:	crash, Signal 11

Description:
Look my log and config files. For example:

080208 7:59:30 - 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=10485760
read_buffer_size=131072
max_used_connections=4
max_connections=40
threads_connected=2
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 97279 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=0xba66750
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=0x56787658, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x818c030
0x8295591
0x829571d
0x82144e0
0x81a679f
0x81ac5fc
0x81acbeb
0x81ae297
0x81aedda
0x5c850b
0x4b8b2e
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 0x56600478 is invalid pointer
thd->thread_id=2716
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.
pure virtual method called

Number of processes running now: 0
080208 07:59:31 mysqld restarted

How to repeat:
I don't know. It is randomly crash.

mysql config

Attachment: my.cnf (application/octet-stream, text), 647 bytes.

symbol file for the mysqld server

Attachment: mysqld.zip (application/x-zip-compressed, text), 116.95 KiB.

Mysql log

Attachment: mysqld1.log (text/plain), 9.19 KiB.

0x818c030 handle_segfault + 768
0x8295591 _ZN11Query_cache16invalidate_tableEP10TABLE_LIST + 97
0x829571d _ZN11Query_cache10invalidateEP3THDP10TABLE_LISTc + 157
0x82144e0 _Z12mysql_deleteP3THDP10TABLE_LISTP4ItemP11st_sql_listmyb + 2976
0x81a679f _Z21mysql_execute_commandP3THD + 13167
0x81ac5fc _Z11mysql_parseP3THDPKcjPS2_ + 604
0x81acbeb _Z16dispatch_command19enum_server_commandP3THDPcj + 1243
0x81ae297 _Z10do_commandP3THD + 167
0x81aedda handle_one_connection + 2554
0x5c850b (?)
0x4b8b2e (?)

0x818c030 handle_segfault + 768
0x841cc5b my_hash_insert + 683
0x8294d57 _ZN11Query_cache11store_queryEP3THDP10TABLE_LIST + 1239
0x81a6219 _Z21mysql_execute_commandP3THD + 11753
0x81ac5fc _Z11mysql_parseP3THDPKcjPS2_ + 604
0x81acbeb _Z16dispatch_command19enum_server_commandP3THDPcj + 1243
0x81ae297 _Z10do_commandP3THD + 167
0x81aedda handle_one_connection + 2554
0x5c850b (?)
0x4b8b2e (?)

Please do not submit the same bug more than once. An existing bug report already describes this very problem. Even if you feel that your issue is somewhat different, the resolution is likely
to be the same. Because of this, we hope you add your comments to the original bug instead.

Thank you for your interest in MySQL.

Duplicate of bug #34323

I am sorry. I couldn't find my original report and added new :( Then I have found my first report.
What I have to do? Copy comments to oroginal report?

Not a problem.

I added link to this report in original report. So everyone who will work on bug #34323 could easily find additional information.