[PATCH] Fix alter subscription concurrency errors

Поиск
Список
Период
Сортировка
От Jelte Fennema
Тема [PATCH] Fix alter subscription concurrency errors
Дата
Msg-id HE1PR8303MB0075BF78AF1BE904050DA16BF7729@HE1PR8303MB0075.EURPRD83.prod.outlook.com
обсуждение исходный текст
Ответы Re: [PATCH] Fix alter subscription concurrency errors
Список pgsql-hackers
Without this patch concurrent ALTER/DROP SUBSCRIPTION statements for
the same subscription could result in one of these statements returning the
following error:

ERROR:  XX000: tuple concurrently updated

This patch fixes that by re-fetching the tuple after acquiring the lock on the
subscription. The included isolation test fails most of its permutations
without this patch, with the error shown above.

The loop to re-fetch the tuple is heavily based on the code from dbcommands.c
Вложения

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

Предыдущее
От: Robert Haas
Дата:
Сообщение: Re: pg_basebackup: add test about zstd compress option
Следующее
От: Tom Lane
Дата:
Сообщение: Re: pg_regress: lookup shellprog in $PATH