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-000Gko-6K@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
------
master
Details
-------
https://git.postgresql.org/pg/commitdiff/b7658c24c7c1ffad131a7fdf67ce7fc008be1177
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 | 15 +++++++++++++
4 files changed, 53 insertions(+)
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 |