[check_postgres] check_postgres_txn_idle returns UNKNOWN sometimes

[Greg Sabino Mullane]

On Tue, Jun 10, 2014 at 03:34:21PM -0600, James Skaggs wrote:
> It doesn't happen often, but occasionally we would see UNKNOWN coming from
> the TXN_IDLE check

I bet it is happening because of this code:

    'psa-disabled'       => q{No queries - is stats_command_string or track_activities off?},
...

if ($cq =~ /disabled/o or $cq =~ /<command string not enabled>/) {
    add_unknown msg('psa-disabled');
    return;
}

That first regex is way too loose, and should probably be removed. Anyone know 
what older versions were putting in the query field of pg_stat_activity 
that might warrant that regex?

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: Digital signature
URL: <https://mail.endcrypt.com/pipermail/check_postgres/attachments/20140611/3032c289/attachment.sig>