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
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
