]> git.ipfire.org Git - thirdparty/postgresql.git/commit
Don't reset 'latest_page_number' when replaying multixid truncation
authorHeikki Linnakangas <heikki.linnakangas@iki.fi>
Mon, 16 Feb 2026 15:16:59 +0000 (17:16 +0200)
committerHeikki Linnakangas <heikki.linnakangas@iki.fi>
Mon, 16 Feb 2026 15:20:56 +0000 (17:20 +0200)
commit547a8aaa7d4fffd686c75b1e00b1c11c0980aabc
tree123d3621da0b6e6a5ef3a1125e5d29dac0b0bb37
parentc60a58204435277b98af5d3aba945b424a4becb5
Don't reset 'latest_page_number' when replaying multixid truncation

'latest_page_number' is set to the correct value, according to
nextOffset, early at system startup. Contrary to the comment, it hence
should be set up correctly by the time we get to WAL replay.

This fixes a failure to replay WAL generated on older minor versions,
before commit 789d65364c (18.2, 17.8, 16.12, 15.16, 14.21). The
failure occurs after a truncation record has been replayed and looks
like this:

    FATAL:  could not access status of transaction 858112
    DETAIL:  Could not read from file "pg_multixact/offsets/000D" at offset 24576: read too few bytes.
    CONTEXT:  WAL redo at 3/2A3AB408 for MultiXact/CREATE_ID: 858111 offset 6695072 nmembers 5: 1048228 (sh) 1048271 (keysh) 1048316 (sh) 1048344 (keysh) 1048370 (sh)

Reported-by: Sebastian Webber <sebastian@swebber.me>
Reviewed-by: Andrey Borodin <x4mmm@yandex-team.ru>
Reviewed-by: Kirill Reshke <reshkekirill@gmail.com>
Discussion: https://www.postgresql.org/message-id/20260214090150.GC2297@p46.dedyn.io;lightning.p46.dedyn.io
Backpatch-through: 14-18
src/backend/access/transam/multixact.c
src/include/access/slru.h