bitscn.com
非正常关机时，innodb故障导致mysql无法启动的解决方法 一次非正常关机，mysql无法启动。查看err日志，显示： innodb: starting crash recovery.innodb: reading tablespace information from the .ibd files...innodb: restoring possible half-written data pages from the doublewriteinnodb: buffer...innodb: error: trying to access page number 4294899072 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 thatinnodb: your my.cnf matches the ibdata files that you have in theinnodb: mysql server.    120331 1:03:41 innodb: assertion failure in thread 3078932288 in file fil0fil.c line 4409innodb: 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, eveninnodb: immediately after the mysqld startup, there may beinnodb: corruption in the innodb tablespace. please refer toinnodb: http://dev.mysql.com/doc/refman/5.5/en/forcing-innodb-recovery.htmlinnodb: about forcing recovery.    21:03:41 utc - mysqld got signal 6 ; 没办法，只好在/etc/my.cnf中写入[mysqld] innodb_force_recovery = 4 但是仍然无法启动。改为：innodb_force_recovery = 6数据库可以读出来，在6的情况下，是无法修改数据库的，也无法插入，只能导出。 用mysqldump导出，再把innodb_force_recovery改为0，但是数据无法导入。 最后还是删除了数据库重建。 这是第二次遇到这种错误，标记一下。  
  作者 lsstarboy  bitscn.com