(经测可用)mysql 出现 Got error 134 from storage engine

今天系统突然有个表无法查询，查询时会报

 

mysql> select * from client_info where CLIENT_NO=261889;
ERROR 1030 (HY000): Got error 134 from storage engine

 

一般这种情况，只要将出故障的表 执行以下操作即可:

 

mysql> REPAIR TABLE client_info;
+-----------------------+--------+----------+----------+
| Table                 | Op     | Msg_type | Msg_text |
+-----------------------+--------+----------+----------+
| freeiris2.client_info | repair | status   | OK       |
+-----------------------+--------+----------+----------+
1 row in set (5.77 sec)

mysql> select * from client_info where CLIENT_NO=261889;
Empty set (0.00 sec)

 

就可以了，经过测试，放心使用..