Strange error: Can't open file: 'cache.MYI'.

Posted by jibbajabba on July 15, 2004 at 8:42pm

Getting the strange error below on my host. Does this mean anything to anyone?

Fatal error: Can't open file: 'cache.MYI'. (errno: 144) query: SELECT data, created, headers FROM cache WHERE cid = '/' in /home/.yar/asilomar/iaslash.org/includes/database.mysql.inc on line 97

Comments

corrupted table

Posted by marky on July 16, 2004 at 12:25am

repair it.

phpMyAdmin can do this too if you have it available. ;)

/marky

--
/marky

Thanks, Marky

Posted by jibbajabba on July 16, 2004 at 2:11pm

Thanks, Marky. Repairing the table via phpMyAdmin didn't fix, however. Strange. Luckily it was just the cache table. I was able to drop and re-create the table, which worked out nicely.

TRUNCATE worked for me, but

Posted by pkreemer on November 8, 2005 at 3:41am

TRUNCATE worked for me, but REPAIR didn't do anything. I did run repair after the truncate though.

Just happened to me.

Posted by noid on October 17, 2005 at 9:40pm

Just happened to me. Was able to repair the cache table using phpmyadmin -- I can access the site again. Does anyone have any idea what causes this error? Thanks. :)

i had the same problem

Posted by nsyll on May 26, 2006 at 1:55pm

but the repair form phpmyadmin fix it
thks

Hellenic Drupal community mydrupal.gr

Had same problem. 'Repair'

Posted by Zach Harkey on May 1, 2008 at 2:44pm

Had same problem. 'Repair' seemed to work, then the problem returned so truncated the table and that seemed to do the trick.

-zach
--
harkey design

This just happened to me

Posted by joshmiller on October 6, 2008 at 4:40pm

This just happened to me while transitioning our Drupal database on Media Temple from their standard database to their MySQL GridContainer. Logging into PhpMyAdmin showed the table as "in use." I wonder if the table was so big it didn't get "copied" over correctly? Anyway, selecting the table and using PhpMyAdmin to tell MySQL to repair it fixed the problem. I'm not sure if you can truncate a table that is "in use," but I bet that would have worked as well.

Josh

this thread

Posted by nrixham on October 6, 2008 at 4:48pm

is older than my son, and he's 4