dbcheck 1.21 vs xymon 4.2.3 (tablespace graphs)

[Francesco Duranti]

Hi Buchan, 
In the latest hobbit_perl_client scripts I've changed the way some of the data for the disk stats are sent to hobbit (mostly for the netapp.pl script) so instead of continuing to change the default rrd disk collector of xymon I preferred to rollback the change in the disk collector and call a new function only for netapp/dbcheck script so that in future it will be less "intrusive" on other collector. 
For this reason you need to patch the 4.2.3 with the new shipped patch.

Regarding your problem, can you check and eventually delete rrd files in the $HOME/data/rrd/$INSTANCE ? 
After some minutes there should be new rrd files in that directory. Can you check if the TblSpace*.rrd files are created?

The only collector that changed from the 1.15 to the 1.21 version is the tblspace so that other collector should not have any problem.
Can you check that the patch to xymon 4.2.3 was applied correctly ? 

I'll do some check in the afternoon or tomorrow morning with the 4.2.3 version and the hobbit_perl_client 1.21 (I've currently working on a new version on my test environment and part of it is also on my production so I need to recompile/reinstall with the old version to do some checks).

> -Does the RRD collector that ships with Xymon 4.2.3 support dbcheck 1.15 ?

Xymon 4.2.3 should include all the change needed for version 1.15.

> -If not, does the RRD collector patch for 4.2.3 shipped in 1.21 support 
x86_64?

The patch support x86_64, I'm developing on a RHEL 5 x86_64.

I'm currently working on a new 1.22 version that will have some more change to the xymon source code to implement a better rrd collection mostly for netapp storage and will also implement dbcheck custom query graphs. After that I'm trying also to reorganize a bit the structure of the hobbit_perl_client (I think I should also rename it to xymon_perl_client) and to create also an "installer" and some man pages with a better documentation (that now is mostly in the example ini file). 
I'm a bit slow in the development because I've some more things to do at work but I hope in a near future that those new patches will be integrated into the xymon source code directly.

Let me know if you have some more information regarding your problem.

Regards,
Francesco

	
-----Original Message-----
From: Buchan Milne [mailto:bgmilne at staff.telkomsa.net] 
Sent: lunedì 14 dicembre 2009 19.41
To: hobbit at hswn.dk
Cc: Francesco Duranti
Subject: dbcheck 1.21 vs xymon 4.2.3 (tablespace graphs)

I have previously used dbcheck version 1.15, but with local hacks in dbcheck 
to get it to report tablespace data in a format for which the Hobbit 4.2.0 
built-in disk check could collect RRD data (as at the time I didn't have time 
to get a change approved on the production monitoring environment).

I recently had a requirement to monitor database servers in a new environment, 
and used dbcheck 1.21 (as support for different thresholds for tablespaces with 
autoextend enabled or not will be useful). However, as far as I can tell, the 
RRD collector shipped with Xymon 4.2.3 is only going to work with dbcheck 
1.15.

So, I patched Xymon 4.2.3 with the patch-4.2.3 shipped with hobbit-perl-cl 
1.21.

For these tests, I have RRD files and graphs, but they are all NaN:
Session
TblSpace

For these tests, I have RRD files, and graphs with values:
InvObj
MemReq

For these tests, I have a broken graph (no image):
HitCache


Now, I would prefer to have graphs for all the tests, but immediately, graphs 
for TblSpace would be most useful.

Unfortunately I don't have a test/dev environment with a full Oracle 
installation (I will try and get an OracleXE into my usual Xymon dev 
environment, but I don't know if that is sufficient), so I can't debug this 
sufficiently.

The Xymon host in question is running CentOS 5.3 x86_64 at present.

So, some questions:
-Does the RRD collector that ships with Xymon 4.2.3 support dbcheck 1.15 ?
-If not, does the RRD collector patch for 4.2.3 shipped in 1.21 support 
x86_64?

Will these changes be merged into Xymon SVN any time soon? I prefer not to 
apply patches which aren't going to find their way upstream.

Otherwise, I will try and test this with some dumps from hobbitdlog on the 
production environment on my test environment ....


Regards,
Buchan