Hi,
A process hangs forever.
When using this query...
SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,
pg_stat_get_backend_activity(s.backendid) AS current_query
FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s
where pg_stat_get_backend_activity(s.backendid) not like '<insuff%'
and pg_stat_get_backend_activity(s.backendid) not like '<IDLE>';
I get...
procpid | current_query
---------+---------------------------------------------------------------------
26702 | SELECT pg_stat_get_backend_pid(s.backendid) AS procpid,
: pg_stat_get_backend_activity(s.backendid) AS current_query
: FROM (SELECT pg_stat_get_backend_idset() AS backendid) AS s
: where pg_stat_get_backend_activity(s.backendid) not like '<insuff%'
: and pg_stat_get_backend_activity(s.backendid) not like '<IDLE>';
21282 | update cmr_lastno set lastisn=lastisn+1 where tablename='DANNY';
25936 | <IDLE> in transaction <== This is the locker
And the question:
- What exactly is the locker doing?
- Can I retrieve the Client PID somewhere (then by process name I will dive into the code).
Thanks a lot
Danny Abraham
BMC Software
CTM&D Business Unit
972-52-4286-513
danny_abraham@bmc.com