首页 诗词 字典 板报 句子 名言 友答 励志 学校 网站地图
当前位置: 首页 > 教程频道 > 数据库 > Mysql >

mysql 异常 急求帮助

2012-05-22 
mysql 错误 急求帮助!Warning: Enabling keys got errno 137 on klonline.top100level, retrying我把原来

mysql 错误 急求帮助!
Warning: Enabling keys got errno 137 on klonline.top100level, retrying

我把原来的数据库里面的top100level这个表删除了 然后重新建了一个,之后程序就写不进去了报上面这个错误

[解决办法]
[15 Mar 2007 13:14] Kristian Koehntopp 
Description:
In the error log of a customers server I get

070315 13:43:01 mysqld started
070315 13:43:01 InnoDB: Started; log sequence number 0 24665690
070315 13:43:01 [Note] /usr/sbin/mysqld: ready for connections.
Version: '5.0.36-enterprise-log' socket: '/var/lib/mysql/mysql.sock' port: 3306 MySQL
Enterprise Server (Commercial)
070315 14:03:32 [Warning] Warning: Enabling keys got errno 137, retrying

and perror 137 reports

nvag-blade0106:/var/lib/mysql # perror 137
MySQL error code 137: No more records (read after end of file)

So a table has a problem, but the message does not indicate which table and database
schema are affected.

How to repeat:
I have no idea how to provoke that message artificially.

Suggested fix:
Check that this (and all other table related messages) include schema name and table
name, when index related also the index name and number.

热点排行