pgsql: Fix corrupt GIN_SEGMENT_ADDITEMS WAL records on big-endian hardw - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Fix corrupt GIN_SEGMENT_ADDITEMS WAL records on big-endian hardw
Date
Msg-id E1bgEkg-0001iq-Eb@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix corrupt GIN_SEGMENT_ADDITEMS WAL records on big-endian hardware.

computeLeafRecompressWALData() tried to produce a uint16 WAL log field by
memcpy'ing the first two bytes of an int-sized variable.  That accidentally
works on little-endian hardware, but not at all on big-endian.  Replay then
thinks it's looking at an ADDITEMS action with zero entries, and reads the
first two bytes of the first TID therein as the next segno/action,
typically leading to "unexpected GIN leaf action" errors during replay.
Even if replay failed to crash, the resulting GIN index page would surely
be incorrect.  To fix, just declare the variable as uint16 instead.

Per bug #14295 from Spencer Thomason (much thanks to Spencer for turning
his problem into a self-contained test case).  This likely also explains
a previous report of the same symptom from Bernd Helmle.

Back-patch to 9.4 where the problem was introduced (by commit 14d02f0bb).

Discussion: <20160826072658.15676.7628@wrigleys.postgresql.org>
Possible-Report: <2DA7350F7296B2A142272901@eje.land.credativ.lan>

Branch
------
REL9_6_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/36646d3aff0cf6ff9f26033e38808d23e27426e8

Modified Files
--------------
src/backend/access/gin/gindatapage.c | 2 +-
1 file changed, 1 insertion(+), 1 deletion(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Fix corrupt GIN_SEGMENT_ADDITEMS WAL records on big-endian hardw
Next
From: Tom Lane
Date:
Subject: pgsql: Fix corrupt GIN_SEGMENT_ADDITEMS WAL records on big-endian hardw