mysql repair 1030 Got error 134 from storage engine
Nov032015
[摘要] mysql执行查询语句报错，Innodb引擎，错误提示：(1030) Got error 134 from storage engine. （Has
fixed）修复过程很简单。
mysql执行简单的查询语句提示信息： (1030) Got error 134 from storage engine. 开始以为是硬盘问题，后来检查发现是mysql的表坏了，修复一下即可。
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 |
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) |
本文固定链接: https://www.sudops.com/mysql-repair-1030-got-error-134-from-storage-engine.html | 运维·速度
mysql repair 1030 Got error 134 from storage engine：等您坐沙发呢！
发表评论
欢迎关注 运维·速度 微信公众号
