pgsql: Fix assorted bugs in GIN's WAL replay logic. - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Fix assorted bugs in GIN's WAL replay logic.
Date
Msg-id E1P5RRI-00007F-L5@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix assorted bugs in GIN's WAL replay logic.

The original coding was quite sloppy about handling the case where
XLogReadBuffer fails (because the page has since been deleted).  This
would result in either "bad buffer id: 0" or an Assert failure during
replay, if indeed the page were no longer there.  In a couple of places
it also neglected to check whether the change had already been applied,
which would probably result in corrupted index contents.  I believe that
bug #5703 is an instance of the first problem.  These issues could show up
without replication, but only if you were unfortunate enough to crash
between modification of a GIN index and the next checkpoint.

Back-patch to 8.2, which is as far back as GIN has WAL support.

Branch
------
REL8_3_STABLE

Details
-------
http://git.postgresql.org/gitweb?p=postgresql.git;a=commitdiff;h=2afd044c9491c484d0b2b6910b17896a64a08c01

Modified Files
--------------
src/backend/access/gin/ginxlog.c |  198 ++++++++++++++++++++++---------------
1 files changed, 118 insertions(+), 80 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Improve the planner's simplification of NOT constructs.
Next
From: Tom Lane
Date:
Subject: pgsql: Fix assorted bugs in GIN's WAL replay logic.