Bug #20457 mysql unkown error
Submitted: 14 Jun 2006 11:35 Modified: 15 Jul 2006 16:38
Reporter: Martin Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version: OS:Linux (debian 3.1 mysql Distrib 5.0.20a)
Assigned to: CPU Architecture:Any

[14 Jun 2006 11:35] Martin
Description:
MySql has crash (and in next 1 hour have [maybe by mysql] server upload 100GB+)

Distrib 5.0.20a

logs:
Jun 14 06:25:40 localhost mysqld[10883]: mysqld got signal 11;
Jun 14 06:25:40 localhost mysqld[10883]: This could be because you hit a bug. It is also possible that this binary
Jun 14 06:25:40 localhost mysqld[10883]: or one of the libraries it was linked against is corrupt, improperly built,
Jun 14 06:25:40 localhost mysqld[10883]: or misconfigured. This error can also be caused by malfunctioning hardware.
Jun 14 06:25:40 localhost mysqld[10883]: We will try our best to scrape up some info that will hopefully help diagnose
Jun 14 06:25:40 localhost mysqld[10883]: the problem, but since we have already crashed, something is definitely wrong
Jun 14 06:25:40 localhost mysqld[10883]: and this may fail.
Jun 14 06:25:40 localhost mysqld[10883]: 
Jun 14 06:25:40 localhost mysqld[10883]: key_buffer_size=16777216
Jun 14 06:25:40 localhost mysqld[10883]: read_buffer_size=131072
Jun 14 06:25:40 localhost mysqld[10883]: max_used_connections=72
Jun 14 06:25:40 localhost mysqld[10883]: max_connections=100
Jun 14 06:25:40 localhost mysqld[10883]: threads_connected=33
Jun 14 06:25:40 localhost mysqld[10883]: It is possible that mysqld could use up to 
Jun 14 06:25:40 localhost mysqld[10883]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 233983 K
Jun 14 06:25:40 localhost mysqld[10883]: bytes of memory
Jun 14 06:25:40 localhost mysqld[10883]: Hope that's ok; if not, decrease some variables in the equation.
Jun 14 06:25:40 localhost mysqld[10883]: 
Jun 14 06:25:40 localhost mysqld[10883]: thd=0x44fcec70
Jun 14 06:25:40 localhost mysqld[10883]: Attempting backtrace. You can use the following information to find out
Jun 14 06:25:40 localhost mysqld[10883]: where mysqld died. If you see no messages after this, something went
Jun 14 06:25:40 localhost mysqld[10883]: terribly wrong...
Jun 14 06:25:40 localhost mysqld[10883]: Cannot determine thread, fp=0x44549158, backtrace may not be correct.
Jun 14 06:25:40 localhost mysqld[10883]: Stack range sanity check OK, backtrace follows:
Jun 14 06:25:40 localhost mysqld[10883]: 0x81916fc
Jun 14 06:25:40 localhost mysqld[10883]: 0x4005ad26
Jun 14 06:25:40 localhost mysqld[10883]: 0x844ecf9
Jun 14 06:25:40 localhost mysqld[10883]: 0x8201c6b
Jun 14 06:25:40 localhost mysqld[10883]: 0x820483c
Jun 14 06:25:40 localhost mysqld[10883]: 0x82059d7
Jun 14 06:25:40 localhost mysqld[10883]: 0x81a074a
Jun 14 06:25:40 localhost mysqld[10883]: 0x81aba97
Jun 14 06:25:40 localhost mysqld[10883]: 0x81ac6a8
Jun 14 06:25:40 localhost mysqld[10883]: 0x81acff4
Jun 14 06:25:40 localhost mysqld[10883]: 0x40054c37
Jun 14 06:25:40 localhost mysqld[10883]: 0x402b82ba
Jun 14 06:25:40 localhost mysqld[10883]: New value of fp=(nil) failed sanity check, terminating stack trace!
Jun 14 06:25:40 localhost mysqld[10883]: Please read http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved
Jun 14 06:25:40 localhost mysqld[10883]: stack trace is much more helpful in diagnosing the problem, so please do 
Jun 14 06:25:40 localhost mysqld[10883]: resolve it
Jun 14 06:25:40 localhost mysqld[10883]: Trying to get some variables.
Jun 14 06:25:40 localhost mysqld[10883]: Some pointers may be invalid and cause the dump to abort...
Jun 14 06:25:40 localhost mysqld[10883]: thd->query at (nil)  is invalid pointer
Jun 14 06:25:40 localhost mysqld[10883]: thd->thread_id=285326
Jun 14 06:25:40 localhost mysqld[10883]: The manual page at http://www.mysql.com/doc/en/Crashing.html contains
Jun 14 06:25:40 localhost mysqld[10883]: information that should help you find out what is causing the crash.
Jun 14 06:25:42 localhost mysqld_safe[16677]: Number of processes running now: 0
Jun 14 06:25:42 localhost mysqld_safe[16679]: restarted 

and some problem with mysql logs...

How to repeat:
unkown bug
[14 Jun 2006 11:46] Valeriy Kravchuk
Thank you for a problem report. Please, create, as described at http://dev.mysql.com/doc/refman/5.0/en/using-stack-trace.html, and send resolved stack trace. Do you know what was executed while this crash happened?
[14 Jun 2006 12:07] Martin
Sorry i have no debug version mysql

server:~# nm -n /usr/sbin/mysqld > /tmp/mysqld.sym
nm: /usr/sbin/mysqld: no symbols

I dont know what was happend...  In this crash time i dont see any anomalys.
I can send you only full system log.

I install in server in next time mysql 4 stable...

(sorry for english :)
[15 Jun 2006 16:38] Valeriy Kravchuk
Please, try to repeat with a newer version of MySQL server, 5.0.22. MySQL's binaries, better - static ones.
[15 Jul 2006 23:00] Bugs System
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".