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:
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
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

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".