[hobbit] If dbcheck slow mode activated, XYmon becomes purple

[Francesco Duranti]

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



-----Original Message-----
From: L.M.J [mailto:linuxmasterjedi at free.fr] 
Sent: Friday, March 13, 2009 8:49 AM
To: hobbit at hswn.dk
Subject: Re: [hobbit] If dbcheck slow mode activated, XYmon becomes purple


On Thu, 12 Mar 2009 18:03:49 -0400, "s_aiello at comcast.net"
<devurrr at gmail.com> wrote:
> if you read the dbcheck documentation, there are values you can specify
in the
> dbcheck.ini to specify the status lifetime.
> 
> i.e.
> fastcheck               = 45m
> mediumcheck             = 3h
> slowcheck               = 18h

Hi,

  Well, I already checked it. Thanks anyway ;)

 
> On Thursday 12 March 2009 17:46:12 nico wrote:
>> Hi,
>> By default, the status lifetime is 20 or 30 minutes.
>>
>> TO change it, you have to edit the dbcheck.pl script and seek the status
line and add a new time: 
>> "status+XXXXX" (XXXX is in seconds). In your case 2h = 7200 seconds. You
can add a little more to 
>> be sure it won't be purple ... 7400 for instance (status+7400).
>> Hope it will help you.


Thanks for your answers!

So far, I have this at the moment :

From my etc/hobbitlaunch.cfg
      [dbchecknormal]
              ENVFILE /foo/bar/server/etc/hobbitserver.cfg
              NEEDS hobbitd
              CMD $BBHOME/ext/dbcheck.pl
              LOGFILE $BBSERVERLOGS/bb-dbcheck.log
              INTERVAL 30m
      [dbcheckslow]
              ENVFILE /foo/bar/server/etc/hobbitserver.cfg
              NEEDS hobbitd
              CMD $BBHOME/ext/dbcheck.pl slow
              LOGFILE $BBSERVERLOGS/bb-dbslow.log
              INTERVAL 4h
              
My etc/dbcheck.ini
      [default]
          fastcheck           = 10m
          mediumcheck         = 30m
          slowcheck           = 4h
                    
And finally from my etc/bb-hosts
      0.0.0.0  dbfoo1    # noconn dbchecknormal 
      0.0.0.0  dbfoo2    # noconn dbchecknormal 
      0.0.0.0  dbfoo3    # noconn dbcheckslow 
      0.0.0.0  dbfoo4    # noconn dbcheckslow
      
 
What's wrong with my configuration? All databases checked with dbcheckslow
become purple after a while. From what you said, I have to edit dbcheck.pl
and modify status+XXXXX" ?	
      

To unsubscribe from the hobbit list, send an e-mail to
hobbit-unsubscribe at hswn.dk