pg.ddx.io pgsql-committers@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgsql: Fix data inconsistency between publisher and subscriber. 3+ messages / 1 participants [nested] [flat]
* pgsql: Fix data inconsistency between publisher and subscriber. @ 2022-06-16 03:29 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 3+ messages in thread From: Amit Kapila @ 2022-06-16 03:29 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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(+) ^ permalink raw reply [nested|flat] 3+ messages in thread
* pgsql: Fix data inconsistency between publisher and subscriber. @ 2022-06-16 03:29 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 3+ messages in thread From: Amit Kapila @ 2022-06-16 03:29 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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_14_STABLE Details ------- https://git.postgresql.org/pg/commitdiff/0980adfd4d021e3329bf41452ce1a1210321974f 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(-) ^ permalink raw reply [nested|flat] 3+ messages in thread
* pgsql: Fix data inconsistency between publisher and subscriber. @ 2022-06-16 03:29 Amit Kapila <akapila@postgresql.org> 0 siblings, 0 replies; 3+ messages in thread From: Amit Kapila @ 2022-06-16 03:29 UTC (permalink / raw) To: pgsql-committers@lists.postgresql.org 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(-) ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2022-06-16 03:29 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2022-06-16 03:29 pgsql: Fix data inconsistency between publisher and subscriber. Amit Kapila <akapila@postgresql.org> 2022-06-16 03:29 pgsql: Fix data inconsistency between publisher and subscriber. Amit Kapila <akapila@postgresql.org> 2022-06-16 03:29 pgsql: Fix data inconsistency between publisher and subscriber. Amit Kapila <akapila@postgresql.org>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox