pgsql: Fix cache look-up failures while applying changes in logical rep - Mailing list pgsql-committers

From Amit Kapila
Subject pgsql: Fix cache look-up failures while applying changes in logical rep
Date
Msg-id E1o1LC2-0007ho-Lv@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix cache look-up failures while applying changes in logical replication.

While building a new attrmap which maps partition attribute numbers to
remoterel's, we incorrectly update the map for dropped column attributes.
Later, it caused cache look-up failure when we tried to use the map to
fetch the information about attributes.

This also fixes the partition map cache invalidation which was using the
wrong type cast to fetch the entry. We were using stale partition map
entry after invalidation which leads to the assertion or cache look-up
failure.

Reported-by: Shi Yu
Author: Hou Zhijie, Shi Yu
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/5a97b1325453d641a795710a92b233c665b662b1

Modified Files
--------------
src/backend/replication/logical/relation.c | 62 ++++++++++++++++++------------
src/test/subscription/t/013_partition.pl   | 56 +++++++++++++++++++++++++--
2 files changed, 89 insertions(+), 29 deletions(-)


pgsql-committers by date:

Previous
From: Michael Paquier
Date:
Subject: pgsql: Tweak behavior of psql --single-transaction depending on ON_ERRO
Next
From: Michael Paquier
Date:
Subject: pgsql: Re-add locally-generated files in pg_upgrade's .gitignore and Ma