pgsql: Add error context for sequence synchronization.

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

pgsql: Add error context for sequence synchronization.

От:
Amit Kapila <akapila@postgresql.org>
Дата:
Add error context for sequence synchronization.

An unhandled ERROR while synchronizing a sequence (for example, when
SwitchToUntrustedUser() fails because the subscription owner cannot SET
ROLE to the sequence owner) makes the sequencesync worker exit and be
restarted, repeatedly, until the user resolves the problem, as with the
apply worker. The error message does not identify the sequence or
subscription responsible.

Add an error context callback around per-sequence validation and
synchronization in copy_sequences() so that such errors report the
schema-qualified sequence name and subscription name in CONTEXT.

Reported-by: Zsolt Parragi 
Author: Zhijie Hou 
Reviewed-by: Ajin Cherian 
Reviewed-by: Hayato Kuroda 
Reviewed-by: vignesh C 
Reviewed-by: Zsolt Parragi 
Discussion: https://postgr.es/m/CAN4CZFMGiyksxVD1M7cc7_5E+evfi51xmDxw4uqdmvoeH53Ugw@mail.gmail.com
Backpatch-through: 19

Branch
------
REL_19_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/215af457aef9b9d0095d2333d126ab817406e9be

Modified Files
--------------
src/backend/replication/logical/sequencesync.c | 32 ++++++++++++++++-
src/test/subscription/t/036_sequences.pl       | 50 ++++++++++++++++++++++++++
2 files changed, 81 insertions(+), 1 deletion(-)

FAQ