If dbcheck slow mode activated, XYmon becomes purple

Le Fri, 13 Mar 2009 19:40:45 +0100,
Francesco Duranti <user-7104dcecbfef@xymon.invalid> a écrit :

Hi, the fast/medium/slow check are related to what check you will do (and not the time you do them).

This is my configuration on checks on the dbcheck.ini
bbconncolumn            = ChkConn::fast
bbauditcolumn           = Audit::fast
bbtablespacecolumn      = TblSpace::fast
bbextentcolumn          = Extent::slow
bbhitcachecolumn        = HitCache::fast
bbmemreqcolumn          = MemReq::fast
bbrollbackcolumn        = RollBack::slow
bbinvobjcolumn          = InvObj::fast
bblockscolumn           = Locks::fast
bbsessioncolumn         = Session::fast

For example I use them to differentiate the checks on the same databases
In hobbitlaunch I have:
[dbfast]
        ENVFILE /home/bb/server/etc/hobbitserver.cfg
        NEEDS hobbitd
        CMD $BBHOME/ext/dbcheck.pl fast
        LOGFILE $BBSERVERLOGS/bb-dbfast.log
        INTERVAL 5m
[dbslow]
        ENVFILE /home/bb/server/etc/hobbitserver.cfg
        NEEDS hobbitd
        CMD $BBHOME/ext/dbcheck.pl slow
        LOGFILE $BBSERVERLOGS/bb-dbslow.log
        INTERVAL 120m

So [dbfast] will run only checks defined as "fast" in the dbcheck.ini files every 5 minutes while [dbslow]
will run every 2 hours to check Extent and Rollback (those kind of checks are more impegnative on the
Database and take a long times on some of the database I check).

On the bb-hosts file I've:
group-compress Dev DB
0.0.0.0 db1 #   noconn dbcheck
0.0.0.0 db2 #   noconn dbcheck
0.0.0.0 db3 #   noconn dbcheck
0.0.0.0 db4 #   noconn dbcheck

The configuration related to how much a check is "valid" for xymon is already in the dbcheck.ini file and
must be at least greater than the interval you run the checks + the duration of the test or xymon will put
the check in purple.

In your case what is happening depends on how you configured the checks by default (fast/medium/slow) but
it can happen that you're simply running the same checks at different interval and with different "valid"
time.

The value of 
fastcheck               = 30m
mediumcheck             = 2h
slowcheck               = 6h
is put already on the status+xx (so there's no need to manually edit it) of the 3 different kind of checks
(so if you're doing the slow checks you're getting status+6h for example with this value).

To check what value you're getting go to the page of the checks (for example in the tablespace check page)
and go to the bottom of the page you will find something like this:

dbcheck.pl version 1.07 - column TblSpace lifetime 30m, tested in ~ 00:00:00 (max 01:00:00)

for a check defined as slow like the Rollback for me you see something like this:
dbcheck.pl version 1.07 - column RollBack lifetime 6h, tested in ~ 00:02:10 (max 01:00:00)

Hoping this helped.

Francesco

Hi Francesco,

  Thanks you for this great answer, I will custom my dbcheck.ini like you did. Thanks a bunch !