[摘要] mysql执行查询语句报错,Innodb引擎,错误提示:(1030) Got error 134 from storage engine. (Has
fixed)修复过程很简单。
mysql执行简单的查询语句提示信息: (1030) Got error 134 from storage engine. 开始以为是硬盘问题,后来检查发现是mysql的表坏了,修复一下即可。
mysql> check table oss_tb_app; +--------------------------+-------+----------+----------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +--------------------------+-------+----------+----------------------------------------------------------+ | sudops.oss_tb_app | check | warning | 3 clients are using or haven't closed the table properly | | sudops.oss_tb_app | check | error | Unexpected byte: 3 at link: 26828124 | | sudops.oss_tb_app | check | error | Corrupt | +--------------------------+-------+----------+----------------------------------------------------------+ 3 rows in set (0.29 sec) mysql> repair table oss_tb_app; +--------------------------+--------+----------+----------------------------------------------+ | Table | Op | Msg_type | Msg_text | +--------------------------+--------+----------+----------------------------------------------+ | sudops.oss_tb_app | repair | warning | Number of rows changed from 285347 to 285346 | | sudops.oss_tb_app | repair | status | OK | +--------------------------+--------+----------+----------------------------------------------+ 2 rows in set (0.71 sec)