ERROR 144 (HY000): Table is marked as crashed and last (automatic?) repair failed

1 문제상황[ | ]

mysql> SELECT COUNT(*) FROM time_traveller;
ERROR 144 (HY000): Table './zetawiki/time_traveller' is marked as crashed and last (automatic?) repair failed

다른 테이블은 괜찮은데 이 테이블만 이상 있음

2 조치 1[ | ]

analyze table

mysql> analyze table time_traveller;
+-------------------------+---------+----------+--------------------------------------------------------------------------------------------+
| Table                   | Op      | Msg_type | Msg_text                                                                                   |
+-------------------------+---------+----------+--------------------------------------------------------------------------------------------+
| zetawiki.time_traveller | analyze | Error    | Table './zetawiki/time_traveller' is marked as crashed and last (automatic?) repair failed |
| zetawiki.time_traveller | analyze | Error    | Table 'time_traveller' is marked as crashed and last (automatic?) repair failed            |
| zetawiki.time_traveller | analyze | error    | Corrupt                                                                                    |
+-------------------------+---------+----------+--------------------------------------------------------------------------------------------+
3 rows in set (0.09 sec)

repair table

mysql> repair table time_traveller;
+-------------------------+--------+----------+----------+
| Table                   | Op     | Msg_type | Msg_text |
+-------------------------+--------+----------+----------+
| zetawiki.time_traveller | repair | status   | OK       |
+-------------------------+--------+----------+----------+
1 row in set (24.50 sec)

analyze table

mysql> analyze table time_traveller;
+-------------------------+---------+----------+-----------------------------+
| Table                   | Op      | Msg_type | Msg_text                    |
+-------------------------+---------+----------+-----------------------------+
| zetawiki.time_traveller | analyze | status   | Table is already up to date |
+-------------------------+---------+----------+-----------------------------+
1 row in set (0.11 sec)

3 (optional) 조치 2[ | ]

MySQL 정지

[root@zetawiki ~]# service mysqld stop
Stopping mysqld:                                           [  OK  ]

myisamchk

[root@zetawiki ~]# myisamchk -r /var/lib/mysql/zetawiki/time_traveller
- recovering (with sort) MyISAM-table '/var/lib/mysql/zetawiki/time_traveller'
Data records: 2576149
- Fixing index 1
- Fixing index 2

4 (optional) 사본 생성[ | ]

복구되었다면 사본을 만들어두자...

mysql> CREATE TABLE `zetawiki`.`time_traveller2` LIKE `zetawiki`.`time_traveller` 
Query OK, 0 rows affected (0.10 sec)

mysql> INSERT INTO `zetawiki`.`time_traveller2` SELECT * FROM `zetawiki`.`time_traveller`;
Query OK, 2368839 rows affected (53.93 sec)
Records: 2368839  Duplicates: 0  Warnings: 0

5 같이 보기[ | ]

6 참고[ | ]

http://stackoverflow.com/questions/8843776/mysql-table-is-marked-as-crashed-and-last-automatic-repair-failed