[check_postgres] bug in txn_wraparound perfdata output

Cédric Villemain cedric.villemain at dalibo.com
Fri Mar 27 14:03:42 UTC 2009


Hi,

Actually, the db->{perf} is duplicated and expanded by each new row fetch. So
you have something like that in the perfdata :
  time=0.01 postgres=102059484 * time=0.01 postgres=102059484
template1=102059484 * time=0.01 postgres=102059484 template1=102059484


The attached patch (against 2.7.3) adjust the sub check_txn_wraparound and add
the same behavior as for check_backends with --include (Change the ORDER BY and
add skip_item)

Note that I didn't use a SLURP but it can be better ... ?

Note also that I have duplicated code with MRTG in that sub ... I am not aware
if both can be merged.

-- 
Cédric Villemain
Administrateur de Base de Données
Cel: +33 (0)6 74 15 56 53
http://dalibo.com - http://dalibo.org
-------------- next part --------------
A non-text attachment was scrubbed...
Name: txn_wraparound.patch
Type: text/x-patch
Size: 1605 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/check_postgres/attachments/20090327/b6830b51/attachment.bin 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 197 bytes
Desc: OpenPGP digital signature
Url : https://mail.endcrypt.com/pipermail/check_postgres/attachments/20090327/b6830b51/attachment-0001.bin 


More information about the Check_postgres mailing list