MySQL Table 복구 - Got error 127 from storage engine

 

1. 에러 메세지

ERROR 1030 (HY000): Got error 127 from storage engine

2. 복구 절차

1. Analyze Table `Table Name`
2. Repair Table `Table Name`

3. 예제보기

mysql> SELECT COUNT(A.IDX) AS 'CNT' FROM PRO_QNA_T A WHERE A.TYPE > 0;
ERROR 1030 (HY000): Got error 127 from storage engine
mysql>
mysql>
mysql> Analyze PRO_QNA_T;
ERROR 1064 (42000): You have an error in your SQL syntax;
check the manual that corresponds to your MySQL server version
for the right syntax to use near 'PRO_QNA_T' at line 1
mysql> Analyze Table PRO_QNA_T;
+---------------------+---------+----------+----------+
|           Table             |     Op    | Msg_type | Msg_text |
+---------------------+---------+----------+----------+
| ihelpers.PRO_QNA_T | analyze  |   status   |      OK     |
+---------------------+---------+----------+----------+
1 row in set (0.01 sec)

mysql> Repair Table PRO_QNA_T; 
+--------------------+--------+----------+--------------------------------------------+ 
|         Table      |   Op   | Msg_type |                  Msg_text                  | 
+--------------------+--------+----------+--------------------------------------------+ 
| ihelpers.PRO_QNA_T | repair |   info   | Key 1 - Found wrong stored record at 24884 | 
| ihelpers.PRO_QNA_T | repair |  warning | Number of rows changed from 2187 to 2186   | 
| ihelpers.PRO_QNA_T | repair |  status  | OK                                         | 
+--------------------+--------+----------+--------------------------------------------+
3 rows in set (0.17 sec) 

mysql> Analyze Table PRO_QNA_T; 
+--------------------+---------+----------+-----------------------------+ 
|        Table       |   Op    | Msg_type |         Msg_text            | 
+--------------------+---------+----------+-----------------------------+ 
| ihelpers.PRO_QNA_T | analyze |  status  | Table is already up to date | 
+--------------------+---------+----------+-----------------------------+ 
1 row in set (0.00 sec) 

mysql> SELECT COUNT(A.IDX) AS 'CNT' FROM PRO_QNA_T A WHERE A.TYPE > 0; 
+------+ 
| CNT  | 
+------+ 
| 2186 | 
+------+ 
1 row in set (0.01 sec) 

mysql>