The Usual Tech Ramblings

MySQL: Error 127 when reading table

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)

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…

  1. If not, I have backups