[check_postgres] check_postgres_txn_time -H POSTCIBBDB -db pcibb --warning=60s --critical=120s -dbuser postgres -dbpass postgres --port=5434 --include=pcibb

[Yehudah Edelstein]

Hello,
        Could you help with this error?

+ /ORACLE_HOME/oracle/product/postgresql/postgresql-9.3.2/check_postgres-2.21.0/check_postgres_txn_time -H POSTCIBBDB -db pcibb --warning=60s --critical=120s -dbuser postgres -dbpass postgres --port=5434 --include=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:           ')::varchar(2000)), ((NULL)::bytea), (('')::varchar(4000)), (('0')::char(3)), ((635408413778477177)::int8), (('׳”׳¢׳ª׳§׳ª ׳§׳•׳‘׳¥ ׳œ׳ž׳—׳¡׳Ÿ')::varchar(100)), (('V-DOCPRD1')::varchar(64)), (('EAI_DocumentManagement.Archive')::varchar(50)), (('EAI_DocumentManagement.Archive.ArchiveFile')::varchar(100)), (('EAI_DocumentManagement.Archive.ArchiveFile.ExecuteTask')::varchar(50)), (('0')::varchar(50)), (('')::varchar(50)), (('')::varchar(25)), (('')::varchar(20)), (('')::varchar(50)), (('')::varchar(100)), (('{eaeeb409-9d7f-46db-9922-e5d068bd7b60}')::varchar(50)), (('')::varchar(50)), ((NULL)::bytea), ((21)::int2))
Command:          /usr/bin/psql -q -t -d pcibb -U postgres -p 5434 -h POSTCIBBDB -o /tmp/VU46VDVgbE/check_postgres_psql.3q5YjPe.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

Regards
Yehudah

Yehudah Edelstein
DBA  production
•Office 972 52 9989019
•Mobile 972 52 2499101
•Fax     972 52 9989990
•Home  972   9 7715549
• yehudaed at cellcom.co.il<mailto:yehudaed at cellcom.co.il>




---------------------------------------------------------------------------------------------------------------
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 HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/check_postgres/attachments/20140713/a798aa0c/attachment.html>