MySQL Error - Warning: Can't open file: 'watchdog.MYI' (errno: 145)

By v1nce on 14 Jun 2006 at 18:12 UTC

I'm getting a sql error when I try to login or run cron.php.

Warning: Can't open file: 'watchdog.MYI' (errno: 145) query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Can't open file: 'watchdog.MYI' (errno: 145)\nquery: DELETE FROM watchdog WHERE timestamp < 1149702748 in /includes/database.mysql.inc on line 120.', 2, '', '/cron.php', '', 1150307548) in /includes/database.mysql.inc on line 120

Is this a MySQL server error? Has anybody else run into this problem?

Site is live and has been running fine using 4.7.2. I've also sent a request to my host to have them look into it.

Comments

I'm experiencing this too, and researching

robertdouglass commented 16 June 2006 at 12:56

using 4.0.24_Debian-10sarge2-log

-Robert Douglass

-----
My Drupal book: Building Online Communities with Drupal, phpBB and WordPress

this was due to the server i

v1nce commented 20 June 2006 at 03:48

this was due to the server i was hosting on and had the mysql server restarted which corrected the problem.

Yes, that and repair table

robertdouglass commented 20 June 2006 at 08:47

There are several ways to fix it; I'd sure like to find out why it keeps happening on one particular installation. Usually, running "REPAIR TABLE" from the mysql command line will work, but in one case I had to remove the .MYI file manually and rebuild the table from the backup. Grr.

- Robert Douglass

-----
My Drupal book: Building Online Communities with Drupal, phpBB and WordPress