Who is locking me? - Mailing list pgsql-general

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