Chinaunix首页 | 论坛 | 博客
  • 博客访问: 4212265
  • 博文数量: 291
  • 博客积分: 8003
  • 博客等级: 大校
  • 技术积分: 4275
  • 用 户 组: 普通用户
  • 注册时间: 2010-10-30 18:28
文章分类

全部博文(291)

文章存档

2017年(1)

2013年(47)

2012年(115)

2011年(121)

2010年(7)

分类: Mysql/postgreSQL

2012-07-11 17:25:12

由于innodb文件损坏,这时虽然mysql能够启动,mysql会每隔几分钟尝试修复innodb文件,修复失败就会写错误到文件中,而且写得非常快,我们服务器不到12小时,就产生了220GB的错误日志,把硬盘写满了。
因此这种危害比mysql没有启动更严重

点击(此处)折叠或打开

  1. 120711 13:52:11InnoDB: Assertion failure in thread 1 in file fil0fil.c line 3959
  2. InnoDB: We intentionally generate a memory trap.
  3. InnoDB: Submit a detailed bug report to
  4. InnoDB: If you get repeated assertion failures or crashes, even
  5. InnoDB: immediately after the mysqld startup, there may be
  6. InnoDB: corruption in the InnoDB tablespace. Please refer to
  7. InnoDB: http://dev.mysql.com/doc/refman/5.0/en/forcing-recovery.html
  8. InnoDB: about forcing recovery.
  9. InnoDB: Error: trying to access page number 1667323833 in space 0,
  10. InnoDB: space name ./ibdata1,
  11. InnoDB: which is outside the tablespace bounds.
  12. InnoDB: Byte offset 0, len 16384, i/o type 10.
  13. InnoDB: If you get this error at mysqld startup, please check that
  14. InnoDB: your my.cnf matches the ibdata files that you have in the
  15. InnoDB: MySQL server.

阅读(4351) | 评论(0) | 转发(0) |
给主人留下些什么吧!~~