Re: Is it possible that session lock is not released

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Is it possible that session lock is not released
Дата
Msg-id 22983.1386821553@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Is it possible that session lock is not released  (T <kurt023@hotmail.com>)
Список pgsql-general
T <kurt023@hotmail.com> writes:
> Now transaction goes to default state, then this backend is killed or some FATAL error happens,
> AbortOutOfAnyTransaction() in ShutdownPostgres() will do nothing since transaction is in default
> state, and session lock on heaprelid is still held after  ShutdownPostgres(), so subsequent operations
> could be blocked by this session lock.

This would only be an issue if we were to accept interrupts between the
CommitTransactionCommand() and StartTransactionCommand() steps ... which
we don't.  I'll admit it's a tad on the fragile side but I don't see a
bug.

            regards, tom lane


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

Предыдущее
От: Chris Travers
Дата:
Сообщение: Re: postgresql.org inconsistent (Re: PG replication across DataCenters)
Следующее
От: Dev Kumkar
Дата:
Сообщение: Re: Case sensitivity