Bug #57388 MySQL is crashing repeatedly
Submitted: 11 Oct 2010 21:46 Modified: 12 Nov 2010 6:44
Reporter: Jon Henry Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: InnoDB Plugin storage engine Severity:S1 (Critical)
Version:5.1.51 OS:Linux (CentOS 5.5 64-bit)
Assigned to: CPU Architecture:Any

[11 Oct 2010 21:46] Jon Henry
Description:
Our MySQL install, which has been stable for months, suddenly started crashing repeatedly (as in, dozens of times per minute). The stack always ends somewhere in the InnoDB plugin.

* There is only one database on this server
* Its data files total 31GB and it is configured for file-per-table
* I tried to do a mysqldump in order to get a backup to rebuild the DB from, but mysql crashes before it can be completed
* I have HugeTLB configured in Linux and large-pages enabled in my.cnf
* I am running the AMD64 Red Hat RPM's and the 64-bit version of CentOS

I will attach the stack and my.cnf to the bug report.

How to repeat:
Nearly any query will result in the crash, but running CHECK TABLE in particular has been 100% reproducible for me.
[11 Oct 2010 21:46] Jon Henry
mysqld.log with stack trace

Attachment: crash.txt (text/plain), 9.45 KiB.

[11 Oct 2010 21:48] Jon Henry
my.cnf

Attachment: my.cnf (application/octet-stream, text), 1.33 KiB.

[12 Oct 2010 4:37] Shane Bester
Can you send us the output of
SHOW CREATE TABLE `zabbix`.`hosts`;

Also the complete error log, from the beginning of time?
[13 Nov 2010 0: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".