Mysql::Error: Incorrect key file for table

Posted on January 17, 2008 
Filed Under Ruby on Rails, Reviews

Few days ago my current Ruby on Rails project was been moved to a staging server with similar configuration of the live web site. Suddenly yesterday in one of the administration modules I started getting the following error:

Mysql::Error: Incorrect key file for table ‘/tmp/#sql_61a9_0.MYI’;
try to repair it

After searching about it on Google I landed to a Mysql bug page. I tried several things to fix this issue like:

But nothing worked, so today I wrote to Rimu hosting’s tech support explaining about the problem.

I received a response within half hour and I really do appreciate their promptness. This pointed me into the right direction that the issue was not with MySQL but due to the fact that there was no disk space available on server. 

[root@xxxxxxx ~]# df -H
Filesystem             Size   Used  Avail Use% Mounted on
/dev/xvda1             4.3G   4.3G   512k 100% /

Tada the problem was gone after freeing up some space on the server :)

Comments

2 Responses to “Mysql::Error: Incorrect key file for table”

  1. Pages tagged "incorrect" on January 25th, 2008 10:48 am

    […] bookmarks tagged incorrect Mysql::Error: Incorrect key file for table saved by 16 others     Gardie13 bookmarked on 01/25/08 | […]

  2. Tyroga on April 29th, 2008 8:52 pm

    Thank you sooo much for this, I Googled the error and your site came up and fixed my problem pronto.

Leave a Reply