pgsql: Avoid backend hang during temp table cleanup in deferrable trans

Поиск
Список
Период
Сортировка
Искать

pgsql: Avoid backend hang during temp table cleanup in deferrable trans

От:
Fujii Masao <fujii@postgresql.org>
Дата:
Avoid backend hang during temp table cleanup in deferrable transactions

Previously, a session that had created temporary objects could hang during
exit if its default transaction mode was SERIALIZABLE READ ONLY DEFERRABLE
and a concurrent serializable transaction was prepared. During backend
exit, temporary-relation cleanup pushed a regular transaction snapshot,
which honored the session's default settings and could wait for a safe
serializable snapshot. So, if the conflicting transaction was prepared,
this wait could last indefinitely.

The wait occurred while the backend was already exiting and interrupts
were held off, so even pg_terminate_backend() could not cancel it. The
backend therefore remained until the prepared transaction was resolved.

Temporary-relation cleanup only needs an active MVCC snapshot for fetching
TOAST data from catalog tuples while dropping temporary objects. It does
not need a transaction snapshot affected by the user's default isolation
settings. So, use a catalog snapshot instead, which provides the needed
protection without entering the deferrable safe-snapshot wait.

Backpatch to all supported versions.

Bug: #19441
Reported-by: Alexander Lakhin 
Author: Andrey Rachitskiy 
Reviewed-by: Andrey Borodin 
Reviewed-by: Fujii Masao 
Discussion: https://postgr.es/m/19441-ec29f3b1363b4a68@postgresql.org
Backpatch-through: 14

Branch
------
REL_14_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/57c1072380536656df87ebc59270f966b7a0f695

Modified Files
--------------
src/backend/catalog/namespace.c                    | 10 +++-
.../test_misc/t/015_temp_schema_exit_deferrable.pl | 58 ++++++++++++++++++++++
2 files changed, 67 insertions(+), 1 deletion(-)

FAQ