mysql dies after crash: Error: trying to access page number 4294961535 in space 0
Hello,
my server has recently crashed and after I try to start it, the mysqld immediately hangs. The error message is following:
081212 10:21:31 mysqld started
InnoDB: The user has set SRV_FORCE_NO_LOG_REDO on
InnoDB: Skipping log redo
InnoDB: Error: trying to access page number 4294961535 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.
081212 10:21:31InnoDB: Assertion failure in thread 34382815616 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.
081212 10:21:31 - 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=2097152
max_used_connections=0
max_connections=100
threads_connected=0
It is possible that mysqld could use up to
key_buffer_size + (read_buffer_size + sort_buffer_size)*max_connections = 409600 K
bytes of memory
Hope that's ok; if not, decrease some variables in the equation.
081212 10:21:31 mysqld ended
This is already with innodb_force_recovery = 6 setting in my.cnf (according to
http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html).
I would really like to recover this database, does anyone know what I could done?
Thank you in advance.
Edited 1 time(s). Last edit at 12/12/2008 03:46AM by Daniel Gerzo.