Home » Forum » Support » Post installation

Watchdog DB Error

·
biznickman - March 7, 2007 - 21:53

I'm receiving the following error on occasion:

[06-Mar-2007 22:33:44] PHP Warning: Can't find file: './precurso_newprecursorblog/watchdog.frm' (errno: 13)

query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (0, 'php', 'Can't find file: './precurso_newprecursorblog/blocks.frm' (errno: 13)\nquery: SELECT * FROM blocks WHERE theme = 'precursor' AND status = 1 ORDER BY region, weight, module in /home/precurso/public_html/includes/database.mysql.inc on line 120.', 2, '', 'http://www.precursorblog.com/taxonomy/term/23?page=3', '', '74.6.70.55', 1173242024) in /home/precurso/public_html/includes/database.mysql.inc on line 120

This error is being place in my error log, and it always occurs between 10 & 11 PM. I have looked around and am at a loss about what on earth is causing the problem. Any help would be greatly appreciated! The fact that it always occurs at a fairly recurring time leads me to believe that it's related to the cron job. Any ideas?

» Login or register to post comments

Hmm, I am getting a similar

sol77 - March 12, 2007 - 01:48

Hmm, I am getting a similar error right now. Should check back in same time tomorrow if I'm up.
My site got suspended right now which leads me to suspect that a cronjob was infact running, because
I ran to phpmyadmin to backup the database incase something horrible was happening. That usually
exceeds the cpu limit if the cronjob is running at the same time.

Ah there we go, now I can get to the site and here's the error:

* user warning: Can't open file: 'watchdog.MYI' (errno: 145) query: SELECT DISTINCT(type) FROM watchdog ORDER BY type in /home/siegethe/public_html/includes/database.mysql.inc on line 120.
* user warning: Can't open file: 'watchdog.MYI' (errno: 145) query: SELECT COUNT(*) FROM watchdog w INNER JOIN users u ON w.uid = u.uid in /home/siegethe/public_html/includes/database.mysql.inc on line 120.
* user warning: Can't open file: 'watchdog.MYI' (errno: 145) query: SELECT w.*, u.name, u.uid FROM watchdog w INNER JOIN users u ON w.uid = u.uid ORDER BY w.wid DESC LIMIT 0, 50 in /home/siegethe/public_html/includes/database.mysql.inc on line 120.

Also, I was unable to copy the database in phpmyadmin because watchdog.MYI was unable to be read or something like that.
In the structure view it says that the watchdog table is in use..

I am using Drupal 4.7.x.

Edit:

I get this when I post to my site.

Warning: Can't open file: 'watchdog.MYI' (errno: 145) query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'Can't open file: 'watchdog.MYI' (errno: 145)\nquery: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'content', 'Comment: duplicate <em>I thought that DS2 takes</em>.', 1, '', 'http://www.siegetheday.org/?q=comment/edit/7388', 'http://www.siegetheday.org/?q=comment/edit/7388', '81.172.163.170', 1173663991) in /home/siegethe/public_html/includes/database.mysql.inc on line 120.', 2, '', 'http://www.siegetheday.org/?q=comment/edit/7388', 'http://www.siegetheday.org/?q=comment/edit/7388', '81.172.163.170', 1173663991) in /home/siegethe/public_html/includes/database.mysql.inc on line 120

Warning: Can't open file: 'watchdog.MYI' (errno: 145) query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'Can't open file: 'watchdog.MYI' (errno: 145)\nquery: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'content', 'Comment: updated <em>I thought that DS2 takes</em>.', 0, '<a href=\\"/?q=node/644#comment-7388\\">view</a>', 'http://www.siegetheday.org/?q=comment/edit/7388', 'http://www.siegetheday.org/?q=comment/edit/7388', '81.172.163.170', 1173663991) in /home/siegethe/public_html/includes/database.mysql.inc on line 120.', 2, '', 'http://www.siegetheday.org/?q=comment/edit/7388', 'http://www.siegetheday.org/?q=comment/e in /home/siegethe/public_html/includes/database.mysql.inc on line 120

Warning: Can't open file: 'watchdog.MYI' (errno: 145) query: INSERT INTO watchdog (uid, type, message, severity, link, location, referer, hostname, timestamp) VALUES (2, 'php', 'Cannot modify header information - headers already sent by (output started at /home/siegethe/public_html/includes/database.mysql.inc:120) in /home/siegethe/public_html/includes/common.inc on line 266.', 2, '', 'http://www.siegetheday.org/?q=comment/edit/7388', 'http://www.siegetheday.org/?q=comment/edit/7388', '81.172.163.170', 1173663991) in /home/siegethe/public_html/includes/database.mysql.inc on line 120

It is pretty bad if my users see this when they post. Any advice on how to fix it, anyone?

-----------------------------------------------------------------------------------------------
Siegetheday.Org

Login or register to post comments
 
 

Drupal is a registered trademark of Dries Buytaert.