Exclusive row locks not release
От | Mark van Leeuwen |
---|---|
Тема | Exclusive row locks not release |
Дата | |
Msg-id | 4F18F600.4040606@internode.on.net обсуждение исходный текст |
Ответы |
Re: Exclusive row locks not release
|
Список | 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 по дате отправления: