pgsql: Fix WAL format incompatibility introduced by backpatching of52a - Mailing list pgsql-committers

From Alexander Korotkov
Subject pgsql: Fix WAL format incompatibility introduced by backpatching of52a
Date
Msg-id E1h83Gz-0003U7-6j@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix WAL format incompatibility introduced by backpatching of 52ac6cd2d0

52ac6cd2d0 added new field to ginxlogDeletePage and was backpatched to 9.4.
That led to problems when patched postgres instance applies WAL records
generated by non-patched one.  WAL records generated by non-patched instance
don't contain new field, which patched one is expecting to see.

Thankfully, we can distinguish patched and non-patched WAL records by their data
size.  If we see that WAL record is generated by non-patched instance, we skip
processing of new field.  This commit comes with some assertions.  In
particular, if it appears that on some platform struct data size didn't change
then static assertion will trigger.

Reported-by: Simon Riggs
Discussion: https://postgr.es/m/CANP8%2Bj%2BK4whxf7ET7%2BgO%2BG-baC3-WxqqH%3DnV4X2CgfEPA3Yu3g%40mail.gmail.com
Author: Alexander Korotkov
Reviewed-by: Simon Riggs, Alvaro Herrera
Backpatch-through: 9.4

Branch
------
REL9_4_STABLE

Details
-------
https://git.postgresql.org/pg/commitdiff/d1166af192ed0bb40ed9dc53d4e799117403233b

Modified Files
--------------
src/backend/access/gin/ginxlog.c | 18 ++++++++++++++++++
src/include/access/gin_private.h | 14 ++++++++++++++
2 files changed, 32 insertions(+)


pgsql-committers by date:

Previous
From: Alexander Korotkov
Date:
Subject: pgsql: Fix WAL format incompatibility introduced by backpatching of52a
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Make heap TID a tiebreaker nbtree index column.