mysqldump: Error 1030: Got error 127 from storage engine when dumping

MySQL Linux

mysqldumpでバックアップを取ろうとしたら、特定テーブルでエラーが発生してそれ以上進まなくなった。


[コマンド]

mysqldump -F -x -q --all-databases -u some_user -p | gzip > dumpall.gz 2>&1


[エラー内容]

mysqldump: Error 1030: Got error 127 from storage engine when dumping table `some_table` at row: 250683


[対応方法]

CHECK TABLE some_table;
REPAIR TABLE some_table
CHECK TABLE some_table

or

mysqlcheck -c -u some_user -p some_db
mysqlcheck -r -u some_user -p some_db
mysqlcheck -c -u some_user -p some_db


[詳細]

$ mysql -u some_user -p some_db
mysql> CHECK TABLE some_table;
+------------------------------+-------+----------+---------------------------------------------+
| Table                        | Op    | Msg_type | Msg_text                                    |
+------------------------------+-------+----------+---------------------------------------------+
| some_db.some_table | check | error    | Wrong bytesec: 0-0-0 at linkstart: 12554244 |
| some_db.some_table | check | error    | Corrupt                                     |
+------------------------------+-------+----------+---------------------------------------------+
2 rows in set (3.10 sec)

mysql> REPAIR TABLE some_table;
+------------------------------+--------+----------+-------------------------------------------------+
| Table                        | Op     | Msg_type | Msg_text                                        |
+------------------------------+--------+----------+-------------------------------------------------+
| some_db.some_table | repair | info     | Wrong bytesec:   0-  0-  0 at 12554244; Skipped |
| some_db.some_table | repair | warning  | Number of rows changed from 1207448 to 1182854  |
| some_db.some_table | repair | status   | OK                                              |
+------------------------------+--------+----------+-------------------------------------------------+
3 rows in set (26.67 sec)

mysql> check table some_table;
+------------------------------+-------+----------+----------+
| Table                        | Op    | Msg_type | Msg_text |
+------------------------------+-------+----------+----------+
| some_db.some_table | check | status   | OK       |
+------------------------------+-------+----------+----------+
1 row in set (7.49 sec)


[参考]
http://www.forum4designers.com/archive85-2005-4-218442.html
http://www.syncworld.net/blog/nob/archives/003707.html