pgsql: Fix data inconsistency between publisher and subscriber.

From: Amit Kapila <akapila(at)postgresql(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix data inconsistency between publisher and subscriber.
Date: 2022-06-16 03:29:41
Message-ID: E1o1gCT-000Gku-7k@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix data inconsistency between publisher and subscriber.

We were not updating the partition map cache in the subscriber even when
the corresponding remote rel is changed. Due to this data was getting
incorrectly replicated for partition tables after the publisher has
changed the table schema.

Fix it by resetting the required entries in the partition map cache after
receiving a new relation mapping from the publisher.

Reported-by: Shi Yu
Author: Shi Yu, Hou Zhijie
Reviewed-by: Amit Langote, Amit Kapila
Backpatch-through: 13, where it was introduced
Discussion: https://postgr.es/m/OSZPR01MB6310F46CD425A967E4AEF736FDA49@OSZPR01MB6310.jpnprd01.prod.outlook.com

Branch
------
REL_13_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/1f9a7738eb84f341a9b39689f33c887d1ef39487

Modified Files
--------------
src/backend/replication/logical/relation.c | 34 ++++++++++++++++++++++++++++++
src/backend/replication/logical/worker.c | 3 +++
src/include/replication/logicalrelation.h | 1 +
src/test/subscription/t/013_partition.pl | 17 ++++++++++++++-
4 files changed, 54 insertions(+), 1 deletion(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Michael Paquier 2022-06-16 08:28:57 pgsql: Fix comment in regression tests for large objects
Previous Message Tom Lane 2022-06-15 15:55:38 Re: pgsql: Re-add locally-generated files in pg_upgrade's .gitignore and Ma