pgsql: Fix wal_consistency_checking nbtree bug.

From: Peter Geoghegan <pg(at)bowt(dot)ie>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix wal_consistency_checking nbtree bug.
Date: 2020-11-05 23:02:35
Message-ID: E1kaoH5-0006I0-Ck@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix wal_consistency_checking nbtree bug.

wal_consistency_checking indicated an inconsistency in certain cases
involving nbtree page deletion. The underlying issue is that there was
a minor difference between the page image produced after a REDO routine
ran and the corresponding page image following original execution.

This harmless inconsistency has been around forever. We more or less
expect total consistency among even deleted nbtree pages these days,
though, so this won't do anymore.

To fix, tweak the REDO routine to match original execution.

Oversight in commit f47b5e13.

Branch
------
master

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

Modified Files
--------------
src/backend/access/nbtree/nbtxlog.c | 2 ++
1 file changed, 2 insertions(+)

Browse pgsql-committers by date

  From Date Subject
Next Message Amit Kapila 2020-11-06 02:51:25 pgsql: Use strlcpy instead of memcpy for copying the slot name in pgsta
Previous Message Magnus Hagander 2020-11-05 19:25:45 Re: pgsql: Add pg_depend.refobjversion.