在晚上,我们的mysql服务器偶尔会重启(innodb引擎),在日志中我看到了以下内容:
150921 1:58:44 InnoDB: Page checksum 2064838754 (32bit_calc: 866699801), prior-to-4.0.14-form checksum 400856538
InnoDB:stored checksum 1847129036, prior-to-4.0.14-form stored checksum 42278670
InnoDB: Page lsn 0 3564194321, low 4 bytes of lsn at page end 2315587073
InnoDB: Page number (if stored to page already) 80945,
InnoDB: space id (if created with >= MySQL-4.1.1 and stored already) 0
InnoDB: Page may be an index page where index id is 116
InnoDB: (index "idx_cru_type" of table "fisheyedb"."cru_login_cookie")
150921 1:58:44 InnoDB: Assertion failure in thread 139799134877440 in file rem0rec.c line 569
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在http://bugs.percona.com/ key_buffer_size=33554432
有没有可能透露发生了什么,以及我们应该做些什么来进一步避免这种行为?
发布于 2015-09-21 22:12:34
我想那张桌子坏了。你可以使用备份修复命令: First MySQL!https://dev.mysql.com/doc/refman/5.0/en/rebuilding-tables.html
https://stackoverflow.com/questions/32695957
复制相似问题