Mysql Got error 127 when reading table

Mysql 数据库errlog中有错误日志,提示:Got error 127 when reading table xxx!Mysql 版本:『mysql Ver 14.14 Distrib 5.6.35, for Linux (x86_64) using EditLine wrapper』,下面是具体的解决办法:

错误日志:
2017-02-03 14:48:39 27759 [ERROR] Got error 127 when reading table ‘./sudops_com/sudops_options’
2017-02-03 14:48:41 27759 [ERROR] Got error 127 when reading table ‘./sudops_com/sudops_options’
2017-02-03 14:49:33 27759 [ERROR] Got error 127 when reading table ‘./sudops_com/sudops_options’

修复办法:

mysql> use sudops_com      
mysql> check table sudops_options;
+--------------------------------+-------+----------+----------------------------------------------------------+
| Table                          | Op    | Msg_type | Msg_text                                                 |
+--------------------------------+-------+----------+----------------------------------------------------------+
| sudops_com.sudops_options      | check | warning  | Table is marked as crashed                               |
| sudops_com.sudops_options      | check | warning  | 2 clients are using or haven't closed the table properly |
| sudops_com.sudops_options      | check | warning  | Size of datafile is: 2488268       Should be: 2488132    |
| sudops_com.sudops_options      | check | error    | Wrong record length 1374362 of 1374495 at 9956           |
| sudops_com.sudops_options      | check | error    | Corrupt                                                  |
+--------------------------------+-------+----------+----------------------------------------------------------+
5 rows in set (0.32 sec)


mysql> repair table sudops_options;
+--------------------------------+--------+----------+------------------------------------------------------+
| Table                          | Op     | Msg_type | Msg_text                                             |
+--------------------------------+--------+----------+------------------------------------------------------+
| sudops_com.sudops_options      | repair | info     | Wrong block with wrong total length starting at 9956 |
| sudops_com.sudops_options      | repair | warning  | Number of rows changed from 351 to 350               |
| sudops_com.sudops_options      | repair | status   | OK                                                   |
+--------------------------------+--------+----------+------------------------------------------------------+
3 rows in set (0.19 sec)

repair之后再次check下表状态:

mysql> check table sudops_options;
+--------------------------------+-------+----------+----------+
| Table                          | Op    | Msg_type | Msg_text |
+--------------------------------+-------+----------+----------+
| sudops_com.sudops_options      | check | status   | OK       |
+--------------------------------+-------+----------+----------+
1 row in set (0.03 sec)

可以看到已经OK了 :)

再次看下mysql的 errlog:
2017-02-03 14:51:05 27759 [ERROR] /usr/sbin/mysqld: Table ‘./sudops_com/sudops_options’ is marked as crashed and should be repaired
2017-02-03 14:51:05 27759 [ERROR] /usr/sbin/mysqld: Table ‘./sudops_com/sudops_options’ is marked as crashed and should be repaired
2017-02-03 14:51:05 27759 [ERROR] /usr/sbin/mysqld: Table ‘./sudops_com/sudops_options’ is marked as crashed and should be repaired
2017-02-03 14:51:15 27759 [Note] Found 350 of 351 rows when repairing ‘./sudops_com/sudops_options

mysql表已经修复成功!

u2

Related Posts

mysql连接失败:The driver has not received any packets from the server

解决java spring连接mysql报错问题,增加连接串参数

Read more

python cx-Oracle 驱动安装

安装oracle驱动 cx-Oracle驱动二进制版本下载地…

Read more

You Missed

OpenAI Astra十题拆解:2000美元,十个数学难题,一次破壁

  • u2
  • 8月 3, 2026
  • 109 views

便宜电视盒子背后的广告欺诈帝 国

  • u2
  • 7月 31, 2026
  • 96 views

Snowflake Cortex AI Gateway:企业 AI Agent 的「信任控制平面」

  • u2
  • 7月 29, 2026
  • 142 views

国产算力训出万亿大模型:美团LongCat-2.0的技术突围

  • u2
  • 7月 28, 2026
  • 136 views

AI逃逸事件全解析:OpenAI模型自主攻破Hugging Face,安全范式正在重构

  • u2
  • 7月 24, 2026
  • 173 views

Kimi K3 冲击波:2.8 万亿参数的野心,和它背后的三场技术硬仗

  • u2
  • 7月 20, 2026
  • 279 views