[support] tools to monitor database errors

[Mahvash Taqi]

Hi-

I would like to know when tables in the db stop responding, such as
(table "watchdog"/ "cache"/ "sessions"); does any one know of tools that
monitor error_logs and would notify you via email? 

 

All suggestions would be greatly appreciated.

 

Thanks!

 

See examples below: 

Example 1- Message in the error_log when the table "watchdog" stop
responding:

 

root at DNDI-8399 logs]# tail -f error_log

[client 220.181.19.168] PHP Fatal error:  Can't open file:
'watchdog.MYI' (errno                                             :
145)\nquery: INSERT INTO watchdog (uid, type, message, severity, link,
locatio                                             n, hostname,
timestamp) VALUES (0, 'php', 'mysql_fetch_array(): supplied argumen
t is not a valid MySQL result resource in
/var/www/vhosts/ndipartidos.org/httpdo
cs/includes/common.inc(2011) : eval()\\'d code on line 11.', 2, '',
'/en/blog/43                                             719',
'220.181.19.168', 1177511462) in
/var/www/vhosts/ndipartidos.org/httpdocs/
includes/database.mysql.inc on line 66

[client 220.181.19.168] PHP Fatal error:  Can't open file:
'watchdog.MYI' (errno                                             :
145)\nquery: INSERT INTO watchdog (uid, type, message, severity, link,
locatio                                             n, hostname,
timestamp) VALUES (0, 'php', 'mysql_fetch_array(): supplied argumen
t is not a valid MySQL result resource in
/var/www/vhosts/ndipartidos.org/httpdo
cs/includes/common.inc(2011) : eval()\\'d code on line 11.', 2, '',
'/en/blog/38                                             7',
'220.181.19.168', 1177511502) in
/var/www/vhosts/ndipartidos.org/httpdocs/in
cludes/database.mysql.inc on line 66

 

 

 

 

Example 2- in this case the site does not load; just a blank page
appears. 

root at DNDI-8399 ~]# cd /var/www/vhosts/aswat.com/statistics/logs

[root at DNDI-8399 logs]# tail -f error_log

[client 216.65.65.26] PHP Fatal error:  Maximum execution time of 30
seconds exc                                             eeded in
/var/www/vhosts/aswat.com/httpdocs/includes/menu.inc on line 996

 

[client 217.160.230.163] PHP Notice:  unserialize(): Error at offset
34980 of 35                                             750 bytes in
/var/www/vhosts/aswat.com/httpdocs/includes/bootstrap.inc on line 2
39

 

[client 74.6.75.12] PHP Notice:  unserialize(): Error at offset 34980 of
35750 b                                             ytes in
/var/www/vhosts/aswat.com/httpdocs/includes/bootstrap.inc on line 239

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.drupal.org/pipermail/support/attachments/20070425/9f662dcc/attachment.htm