MySQL DBA - Tips and Techniques Magazine

13 Nov 2014

Error 134

090326 12:30:54 [ERROR] Got error 134 when reading table './ANYPROV/ORDERS'

 

Reference from Mysql Bug Database

 

http://lists.mysql.org/mysql/51228

 

 

perror 134
 
and get this result:
Unknown error 134
Record was already deleted (or record file crashed)

 

 

 

mysql> check table ORDERS;

+----------------+-------+----------+-------------------------------+

| Table          | Op    | Msg_type | Msg_text                      |

+----------------+-------+----------+-------------------------------+

| ANYPROV.ORDERS | check | error    | Found 1443503 keys of 1443502 |

| ANYPROV.ORDERS | check | error    | Corrupt                       |

+----------------+-------+----------+-------------------------------+

2 rows in set (2.88 sec)

 

Mysql > repair table ORDERS;

No comments:

Post a Comment