|
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 |
