Bug #43204 mySQL crashing on startup - mysqld got signal 11
Submitted: 25 Feb 2009 18:01 Modified: 25 Mar 2009 19:27
Reporter: david mcintosh Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL Server: Errors Severity:S1 (Critical)
Version:5.? OS:Linux (CentOS 5)
Assigned to: CPU Architecture:Any

[25 Feb 2009 18:01] david mcintosh
Description:

090225 12:53:21  mysqld started
090225 12:53:21  InnoDB: Database was not shut down normally!
InnoDB: Starting crash recovery.
InnoDB: Reading tablespace information from the .ibd files...
InnoDB: Restoring possible half-written data pages from the doublewrite
InnoDB: buffer...
090225 12:53:44  InnoDB: Starting log scan based on checkpoint at
InnoDB: log sequence number 148 739961579.
InnoDB: Doing recovery: scanned up to log sequence number 148 745204224
InnoDB: Doing recovery: scanned up to log sequence number 148 746512578
090225 12:53:44  InnoDB: Starting an apply batch of log records to the database...
InnoDB: Progress in percents: 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 InnoDB: Error: trying to access page number 4291170623 in space 0,
InnoDB: space name ./ibdata1,
InnoDB: which is outside the tablespace bounds.
InnoDB: Byte offset 0, len 16384, i/o type 10.
InnoDB: If you get this error at mysqld startup, please check that
InnoDB: your my.cnf matches the ibdata files that you have in the
InnoDB: MySQL server.
090225 12:53:46InnoDB: Assertion failure in thread 2754067344 in file fil0fil.c line 3959
InnoDB: We intentionally generate a memory trap.
InnoDB: Submit a detailed bug report to http://bugs.mysql.com.
InnoDB: If you get repeated assertion failures or crashes, even
InnoDB: immediately after the mysqld startup, there may be
InnoDB: corruption in the InnoDB tablespace. Please refer to
InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
InnoDB: about forcing recovery.
090225 12:53:46 - 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=0
read_buffer_size=2093056
max_used_connections=0
max_connections=512
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 2095100 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.

thd=(nil)
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=0xa427a4c8, backtrace may not be correct.
Stack range sanity check OK, backtrace follows:
0x8187393
0x83f96bc
0x83d76a5
0x83d7cdd
0x83cba1f
0x83f331e
0x83905a0
0x8395e06
0x839e684
0x83a068d
0x835eeab
0x8361b36
0x83ce3db
0x83f936b
0x833fa88
0x58b46b
0x4e2dbe
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
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.
090225 12:53:46  mysqld ended

How to repeat:
On every service restart and reboot the same behavior occurs.
[25 Feb 2009 19:27] Sveta Smirnova
Thank you for the report.

Please indicate accurate minor version of MySQL you are using. Also, please, provide your configuration file and indicate how much physical RAM do you have.
[26 Mar 2009 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".