开发者

Recipe for creating a corrupt mysql table

开发者 https://www.devze.com 2023-01-02 23:44 出处:网络
We had a process that crashed while trying to manipulate an expected mysql record set, running the offending query from the mysql cli showed the following.

We had a process that crashed while trying to manipulate an expected mysql record set, running the offending query from the mysql cli showed the following.

mysql> SELECT ...;
ERROR 1030: Got error 127 from tabl开发者_如何学编程e handler

Is there a way to easily recreate this condition so we can validate our fix ? (production DB was already repaired).


$ perror 127
OS error code 127:  Key has expired
MySQL error code 127: Record file is crashed

The cause is most probably a corrupted MyISAM table ... I don't think it's possible to reproduce, unless you actually know how to provoke that corruption :/

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号