dbcheck.pl goes purple for all monitored databases? 🔗 link

Before I look at spending a lot of time looking at the dbcheck.pl script, I thought I might ask if anyone else has seen the script hang when one of its queries does not return?  Typically, dbcheck.pl -fast will hang on a query sent to a database that is having issues and so all the other monitored databases will eventually go purple as the dbcheck.pl is hung.  Anybody else see the same issue and implement any solutions?  I am going to look at the perl script and see if I can insert some timeout for any and all queries sent to the databases.


~David

It helps to reread the documentation:

timeoutdbconn=20s
timeoudbtselect=1h
timeoutcmdexec=2m

Perhaps setting these to lower values will help.

~David

From: Gore, David W (David)
Sent: Tuesday, September 04, 2012 12:01
To: Xymon at xymon.com
Subject: [Xymon] dbcheck.pl goes purple for all monitored databases?

Before I look at spending a lot of time looking at the dbcheck.pl script, I thought I might ask if anyone else has seen the script hang when one of its queries does not return?  Typically, dbcheck.pl -fast will hang on a query sent to a database that is having issues and so all the other monitored databases will eventually go purple as the dbcheck.pl is hung.  Anybody else see the same issue and implement any solutions?  I am going to look at the perl script and see if I can insert some timeout for any and all queries sent to the databases.


~David

On 04-09-2012 19:00, Gore, David W (David) wrote:

It helps to reread the documentation:

timeoutdbconn=20s

timeoudbtselect=1h

If you cut-and-pasted that into the mail, note the typo in that second line.

I seem to recall that typo is actually in the comments/sample config 
provided in dbcheck.ini.


Regards,
Henrik