Exclusive row locks not release

From: Mark van Leeuwen <markvl(at)internode(dot)on(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Exclusive row locks not release
Date: 2012-01-20 05:05:04
Message-ID: 4F18F600.4040606@internode.on.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2012-01-20 05:40:39 Re: Exclusive row locks not release
Previous Message Andrew Sullivan 2012-01-20 02:40:19 Re: planner, newly added records and most common values