Re: Exclusive row locks not release

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Exclusive row locks not release
Дата
Msg-id 26344.1327038039@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Exclusive row locks not release  (Mark van Leeuwen <markvl@internode.on.net>)
Ответы Re: Exclusive row locks not release  (Mark van Leeuwen <markvl@internode.on.net>)
Numerous prepared transactions?  (Lincoln Yeoh <lyeoh@pop.jaring.my>)
Список pgsql-general
Mark van Leeuwen <markvl@internode.on.net> writes:
> 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.

Uncommitted prepared transaction, perhaps?  Look into pg_prepared_xacts.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: Mark van Leeuwen
Дата:
Сообщение: Exclusive row locks not release
Следующее
От: Mark van Leeuwen
Дата:
Сообщение: Re: Exclusive row locks not release