mysql repair 1030 Got error 134 from storage engine

注册

登录

Windows| Linux/Shell| Nginx| UNIX| MySQL| Ms SQL Server| MS Access| MS DOS命令| Oracle| SQLite| MongoDB| Redis| SSDB| Memcached| Cassandra| Hibernate| MariaDB| MyBatis| Slick| Spark| Kubernetes| neo4j| TiDB| PostgreSQL| InfluxDB| Istio| IoTDB|

用户注册

点击换图

投稿取消

文章分类:

还能输入300字

上传中....

热门文章更多>>

标签更多>>

word左右居中纵向分布 word左右居中对齐 word左右居中对齐怎么设置 word标题回车后为正文 word标题回车后直接分页 word标题回车后中间空了好大一段 word里面行距怎么调整无法缩小 word里面行距一直很大 word里面行距怎么设置在哪里 word试卷格式文档怎么打印 word试卷格式排版 word中隐藏文字打印 word中隐藏文字快捷键 word中隐藏文字在哪里

专题更多>>

最新文章更多>>

OBM的那个啥

mysql repair 1030 Got error 134 from storage engine

[摘要] 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)

0
0
0
0
0