Got error 134,28 from storage engine

编程技术  /  houtizong 发布于 3年前   119

 

Got error 134 from storage engine

 Got error 28 from storage engine

 ===============================================

MySql 执行以以下SQL时报错:

mysql> select * from service_invoker where id=336518;

错误:

ERROR 1030 : Got error 134 from storage engine

  storage engine错误,一般就是表出错了吧

 


检查表:check table tablename;
mysql> check table service_invoker;
+----------------------------+-------+----------+-----------------------------------------------------------------------+
| Table                      | Op    | Msg_type | Msg_text                                                              |
+----------------------------+-------+----------+-----------------------------------------------------------------------+
| registerdb.service_invoker | check | warning  | Table is marked as crashed                                            |
| registerdb.service_invoker | check | warning  | 9 clients are using or haven't closed the table properly              |
| registerdb.service_invoker | check | warning  | Found 12026004 deleted space in delete link chain. Should be 12025988 |
| registerdb.service_invoker | check | error    | Found more than the expected 93657 deleted rows in delete link chain  |
| registerdb.service_invoker | check | error    | record delete-link-chain corrupted                                    |
| registerdb.service_invoker | check | error    | Corrupt                                                               |
+----------------------------+-------+----------+-----------------------------------------------------------------------+
6 rows in set

 

修复表:repair table tablename;
mysql> repair table service_invoker;

+----------------------------+--------+----------+--------------------------------------------+
| Table                      | Op     | Msg_type | Msg_text                                   |
+----------------------------+--------+----------+--------------------------------------------+
| registerdb.service_invoker | repair | warning  | Number of rows changed from 70677 to 64352 |
| registerdb.service_invoker | repair | status   | OK                                         |
+----------------------------+--------+----------+--------------------------------------------+
2 rows in set

mysql>

 

 

==========================================================

Got error 28 from storage engine

 

mysql数据库就出现了“Got error 28 from storage engine”错误,去google搜索了一下,发现问题这样解决;
    磁盘临时空间不够导致。 
    解决办法: 
    清空/tmp目录,或者修改my.cnf中的tmpdir参数,指向具有足够空间目录 

 

 

 

 

请勿发布不友善或者负能量的内容。与人为善,比聪明更重要!

留言需要登陆哦

技术博客集 - 网站简介:
前后端技术:
后端基于Hyperf2.1框架开发,前端使用Bootstrap可视化布局系统生成

网站主要作用:
1.编程技术分享及讨论交流,内置聊天系统;
2.测试交流框架问题,比如:Hyperf、Laravel、TP、beego;
3.本站数据是基于大数据采集等爬虫技术为基础助力分享知识,如有侵权请发邮件到站长邮箱,站长会尽快处理;
4.站长邮箱:[email protected];

      订阅博客周刊 去订阅

文章归档

文章标签

友情链接

Auther ·HouTiZong
侯体宗的博客
© 2020 zongscan.com
版权所有ICP证 : 粤ICP备20027696号
PHP交流群 也可以扫右边的二维码
侯体宗的博客