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  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Andrew Sullivan
Дата:
Сообщение: Re: planner, newly added records and most common values
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Exclusive row locks not release