Help : Mysql got signal 11....... & stop to work!
I admin a site with a lot of connection (many users visit the site per second); in the critical hour i've got about 500 child of apache and more of 500 child of mysqld....
My Webserver is a Debian Linux STABLE with mysql-server 4.1.10a
After a few time i get this error in daemon.log file & the site stop to work (static page work but dynamic page NO) :
mysqld[25408]: mysqld got signal 11;
mysqld[25408]: This could be because you hit a bug. It is also possible that this binary
mysqld[25408]: or one of the libraries it was linked against is corrupt, improperly built,
mysqld[25408]: or misconfigured. This error can also be caused by malfunctioning hardware.
mysqld[25408]: We will try our best to scrape up some info that will hopefully help diagnose
mysqld[25408]: the problem, but since we have already crashed, something is definitely wrong
mysqld[25408]: and this may fail.
mysqld[25408]:
mysqld[25408]: key_buffer_size=367001600
mysqld[25408]: read_buffer_size=520192
mysqld[25408]: max_used_connections=172
mysqld[25408]: max_connections=600
mysqld[25408]: threads_connected=169
mysqld[25408]: It is possible that mysqld could use up to
mysqld[25408]: key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 970395 K
mysqld[25408]: bytes of memory
mysqld[25408]: Hope that's ok; if not, decrease some variables in the equation.
mysqld[25408]:
mysqld[25408]: thd=0x8c97fe0
mysqld[25408]: Attempting backtrace. You can use the following information to find out
mysqld[25408]: where mysqld died. If you see no messages after this, something went
mysqld[25408]: terribly wrong...
mysqld[25408]: Cannot determine thread, fp=0xb19ff3d8, backtrace may not be correct.
mysqld[25408]: Stack range sanity check OK, backtrace follows:
mysqld[25408]: 0x8152d91
mysqld[25408]: 0x4004cf54
mysqld[25408]: 0x40128b00
mysqld[25408]: 0x40128aa3
mysqld[25408]: 0x84717a2
mysqld[25408]: 0x8471ed9
mysqld[25408]: 0x8164b5f
mysqld[25408]: 0x816bfb3
mysqld[25408]: 0x81630ed
mysqld[25408]: 0x4004a0ba
mysqld[25408]: 0x40189d6a
mysqld[25408]: New value of fp=(nil) failed sanity check, terminating stack trace!
mysqld[25408]: Please read
http://dev.mysql.com/doc/mysql/en/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved
mysqld[25408]: stack trace is much more helpful in diagnosing the problem, so please do
mysqld[25408]: resolve it
mysqld[25408]: Trying to get some variables.
mysqld[25408]: Some pointers may be invalid and cause the dump to abort...
mysqld[25408]: thd->query at (nil) is invalid pointer
mysqld[25408]: thd->thread_id=190
mysqld[25408]: The manual page at
http://www.mysql.com/doc/en/Crashing.html contains
mysqld[25408]: information that should help you find out what is causing the crash
I don't know what i've to do...
Anyone could help me ?
Please
Thanks