[GENERAL] Who is locking me?

[Abraham, Danny]

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_abra...@bmc.com<mailto:danny_abra...@bmc.com>