Got error 134,28 from storage engine

 

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参数，指向具有足够空间目录