Who is locking me?

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(at)bmc(dot)com<mailto:danny_abraham(at)bmc(dot)com>