| 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: | Whole Thread | Raw Message | 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 |