mysql repair 1030 Got error 134 from storage engine
时间:2016-03-08 00:30 来源:linux.it.net.cn 作者:IT
[摘要] 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)
(责任编辑：IT)
[摘要] mysql执行查询语句报错，Innodb引擎，错误提示：(1030) Got error 134 from storage engine. （Has mysql执行简单的查询语句提示信息： (1030) Got error 134 from storage engine. 开始以为是硬盘问题，后来检查发现是mysql的表坏了，修复一下即可。
(责任编辑：IT) |