MySQL: Error 127 when reading table
January 12, 2010
After today’s little hiccup, I noticed the random image in the top right of my page throwing an error message, something about ERROR_STORAGE_FAILURE. A little digging about, I stumbled across an error in the daemon.log file…
mysqld[4478]: 100112 20:31:04 [ERROR] Got error 127 when reading table g2_ItemAttributesMap
Fortunately, most of the times, this is relatively easy to resolve1.
mysql> USE mydbname;
mysql> REPAIR TABLE g2_ItemAttributesMap;
+----------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+----------------------+--------+----------+----------+
| g2_ItemAttributesMap | repair | status | OK |
+----------------------+--------+----------+----------+
1 row in set (0.01 sec)
mysql> REPAIR TABLE g2_ItemAttributesMap;
+----------------------+--------+----------+----------+
| Table | Op | Msg_type | Msg_text |
+----------------------+--------+----------+----------+
| g2_ItemAttributesMap | repair | status | OK |
+----------------------+--------+----------+----------+
1 row in set (0.01 sec)
As you can see from the Msg_text column, the command completed OK. A quick refresh of the blog page, and the error is now gone, and the random picture is back…
- if not, I have backups [♦]
Posted in Linux, Open Source, Technology
content rss
