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
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/219334a2252729054db98288df64e61b2968f2b7

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