[check_postgres] FW: *** error in status () check_postgres_txn_time.ksh for POSTCIBBDB pcibb.

[Yehudah Edelstein]

Hi,
	This is the error I get in return when I check a DB for:
check_postgres_txn_time -H ${HST} -db ${INSTANCE} --warning="${WARN}"  --critical="${CRIT}" -dbuser postgres -dbpass ${pswd} --port=${port}  --include=${INSTANCE}

The values for WARN=60s
	       For CRIT=120s
The host=POSTCIBBDB
       db=pcibb

This normally works for the 3 DB's that I monitor hourly, this error (or similar error messages) appears instead of the normal 1 row response once or twice a day and not always on the same DB.
What causes this non-standard response and how can it be corrected?
Thanks
Yehudah



-----Original Message-----
From: Oracle_GCDB [mailto:oracle at gcdb.corp.cellcom.co.il] 
Sent: Tuesday, July 29, 2014 3:56 PM
To: DBA-MONITOR
Subject: *** error in status () check_postgres_txn_time.ksh for POSTCIBBDB pcibb.

Could not parse psql output!
Please report these details to check_postgres at bucardo.org:
Version:          2.21.0
Action:           txn_time
Calling line:     7579
Output:           SET ssl_renegotiation_limit=0;
Command:          /usr/bin/psql -q -t -d pcibb -U postgres -p 5434 -h POSTCIBBDB -o /tmp/4VMToclBYE/check_postgres_psql.RJGr6Nj.tmp -x-c "SELECT datname, datid, pid AS pid, usename, client_addr, xact_start, query AS query, state AS state, CASE WHEN client_port < 0 THEN 0 ELSE client_port END AS client_port, COALESCE(ROUND(EXTRACT(epoch FROM now()-xact_start)),0) AS seconds FROM pg_stat_activity WHERE (xact_start IS NOT NULL) ORDER BY xact_start, query_start, pid DESC"
Postgres version: PostgreSQL 9.3.4

---------------------------------------------------------------------------------------------------------------
This e-mail message may contain confidential, commercial and privileged information or data that
constitute proprietary information of Cellcom Israel Ltd. Any review or distribution by others is
strictly prohibited. If you are not the intended recipient you are hereby notified that any use
of this information or data by any other person is absolutely prohibited.
If you are not the intended recipient, please delete all copies.

Thank You.
http://www.cellcom.co.il
-------------- next part --------------
An embedded message was scrubbed...
From: "Oracle_GCDB" <oracle at gcdb.corp.cellcom.co.il>
Subject: POSTCIBBDB_pcibb-CRITICAL-txn_open_more_than_seconds-check_postgres_txn_time
 warning=60s,critical=120s
Date: Tue, 29 Jul 2014 09:56:14 +0000
Size: 1790
URL: <https://mail.endcrypt.com/pipermail/check_postgres/attachments/20140729/9275671e/attachment.mht>
-------------- next part --------------
An embedded message was scrubbed...
From: "Oracle_GCDB" <oracle at gcdb.corp.cellcom.co.il>
Subject: *** error in status () check_postgres_txn_time.ksh for POSTCIBBDB pcibb.
Date: Tue, 29 Jul 2014 10:56:12 +0000
Size: 2264
URL: <https://mail.endcrypt.com/pipermail/check_postgres/attachments/20140729/9275671e/attachment-0001.mht>
-------------- next part --------------
An embedded message was scrubbed...
From: "Oracle_GCDB" <oracle at gcdb.corp.cellcom.co.il>
Subject: POSTCIBBDB_pcibb-CRITICAL-txn_open_more_than_seconds-check_postgres_txn_time
 warning=60s,critical=120s
Date: Tue, 29 Jul 2014 11:56:14 +0000
Size: 1781
URL: <https://mail.endcrypt.com/pipermail/check_postgres/attachments/20140729/9275671e/attachment-0002.mht>
-------------- next part --------------
An embedded message was scrubbed...
From: "Oracle_GCDB" <oracle at gcdb.corp.cellcom.co.il>
Subject: *** error in status () check_postgres_txn_time.ksh for POSTCIBBDB pcibb.
Date: Tue, 29 Jul 2014 12:56:12 +0000
Size: 2264
URL: <https://mail.endcrypt.com/pipermail/check_postgres/attachments/20140729/9275671e/attachment-0003.mht>
-------------- next part --------------
An embedded message was scrubbed...
From: "Oracle_GCDB" <oracle at gcdb.corp.cellcom.co.il>
Subject: *** error in status (no) check_postgres_txn_time.ksh for postsmsdb CellcomCourier.
Date: Mon, 28 Jul 2014 18:56:25 +0000
Size: 2249
URL: <https://mail.endcrypt.com/pipermail/check_postgres/attachments/20140729/9275671e/attachment-0004.mht>