[check_postgres] [Bug 51] Use of uninitialized value in length

[Greg Sabino Mullane]

> i try the lastest version 2.16.0
> Follow output from command line:
> 
> [10:49:45] nagios at nagios:~>  ../libexec/check_postgres_query_time -H servername -port 5432 -db postgres
> Could not parse psql output!

Can you try the latest version from git and see if that has fixed it?
Sorry to keep pushing you to more recent versions. :)

If not, we'll need to see what the output of the query you gave is 
when run manually on your system. Probably just needs some minor regex 
adjustment.


> Please report these details to check_postgres at bucardo.org:
> Version:      2.16.0
> Action:       query_time
> Calling line: 4506
> Output:       SELECT
> Command:      /usr/bin/psql -q -t -d postgres -U postgres -p 5432 -h servername -o /tmp/yDw5fouitz/check_postgres_psql.J3CAzMl.tmp -x -c BEGIN;SET statement_timeout=30000;COMMIT;
> SELECT
>  xact_start,
>  SUBSTR(current_query,0,100) AS current_query,
>  client_addr,
>  client_port,
>  procpid,
>  COALESCE(ROUND(EXTRACT(epoch FROM now()-query_start)),0) AS qtime,
>  datname,
>  usename
> FROM pg_stat_activity
> WHERE current_query <> '<IDLE>'
> ORDER BY xact_start, procpid DESC
>  

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 0x14964AC8
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
Url : https://mail.endcrypt.com/pipermail/check_postgres/attachments/20110325/0c0ede85/attachment.bin