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
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 |