Is it possible that session lock is not released

Поиск
Список
Период
Сортировка
От T
Тема Is it possible that session lock is not released
Дата
Msg-id BAY173-W3774652D9D86835F8CBEBFE6DC0@phx.gbl
обсуждение исходный текст
Ответы Re: Is it possible that session lock is not released
Список pgsql-general
Hi,
    I just found that ShutdownPostgres() only releases USER_LOCKMETHOD locks, so why not
release DEFAULT_LOCKMETHOD locks? Check if this is possible:
    We are doing a CREATE INDEX CONCURRENTLY, and codes runs to

    LockRelationIdForSession(&heaprelid, ShareUpdateExclusiveLock);

    PopActiveSnapshot();
    CommitTransactionCommand();
   
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.

Thanks.

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

Предыдущее
От: Mike Christensen
Дата:
Сообщение: Npgsql - Where can I find Npgsql.NpgsqlServices
Следующее
От: Jayadevan
Дата:
Сообщение: Re: vacuuming - doubt