Exclusive row locks not release - Mailing list pgsql-general

From Mark van Leeuwen
Subject Exclusive row locks not release
Date
Msg-id 4F18F600.4040606@internode.on.net
Whole thread Raw
Responses Re: Exclusive row locks not release  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

I have a case where exclusive row locks have been placed on a table and
I don't what process has the locks or how they might be released.

The locks are still there even after I have restarted the database.
Rebooting the server also made no difference.

I am running the latest pg version 9.1.2-1.

Here is the query I used to show the locks:
select t.relname,l.locktype,page,virtualtransaction,pid,mode,granted
from pg_locks l, pg_stat_all_tables t where l.relation=t.relid order by
relation asc;

Here are the locks (excuse formatting), table name is EJB__TIMER__TBL:
relname    locktype    page    virtualtransaction    pid    mode    granted
pg_class    relation <null>    2/63    3961    AccessShareLock    true
pg_index    relation <null>    2/63    3961    AccessShareLock    true
pg_namespace    relation <null>    2/63    3961    AccessShareLock    true
EJB__TIMER__TBL    relation <null>    -1/1761142 <null>
RowExclusiveLock    true
EJB__TIMER__TBL    relation <null>    -1/1758118 <null>
RowExclusiveLock    true

According to pg_catalog.pg_stat_activity, there are no other connections
to the database.

Suggestions?

Thanks
Mark


pgsql-general by date:

Previous
From: Andrew Sullivan
Date:
Subject: Re: planner, newly added records and most common values
Next
From: Tom Lane
Date:
Subject: Re: Exclusive row locks not release