一次非正常关机,mysql无法启动。查看err日志,显示:
- InnoDB: Starting crash recovery.
- InnoDB: Reading tablespace information from the .ibd files...
- InnoDB: Restoring possible half-written data pages from the doublewrite
- InnoDB: 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 that
- InnoDB: your my.cnf matches the ibdata files that you have in the
- InnoDB: MySQL server.
- 120331 1:03:41 InnoDB: Assertion failure in thread 3078932288 in file fil0fil.c line 4409
- InnoDB: We intentionally generate a memory trap.
- InnoDB: Submit a detailed bug report to
- 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.5/en/forcing-innodb-recovery.html
- InnoDB: 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,但是数据无法导入。
最后还是删除了数据库重建。
这是第二次遇到这种错误,标记一下。
阅读(7516) | 评论(0) | 转发(0) |