pgsql: Fix multixact members truncation at page boundary

From: Heikki Linnakangas <heikki(dot)linnakangas(at)iki(dot)fi>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Fix multixact members truncation at page boundary
Date: 2026-09-16 12:30:35
Message-ID: E1x6omZ-00000000aPy-0Yaj@gemulon.postgresql.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Fix multixact members truncation at page boundary

Like in PerformOffsetsTruncation() and e.g. in TruncateSUBTRANS(),
need to step back to previous page at page boundary, to avoid passing
a cutoff page to SimpleLruTruncate() that hasn't been created
yet. Otherwise you can get a bogus 'LOG: could not truncate directory
"pg_multixact/members": apparent wraparound' message in the log.

Reported-by: Noah Misch <noah(at)leadboat(dot)com>
Discussion: https://www.postgresql.org/message-id/20260827231757.78.noahmisch@microsoft.com
Backpatch-through: 19

Branch
------
REL_19_STABLE

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

Modified Files
--------------
src/backend/access/transam/multixact.c | 17 +++++++++++------
1 file changed, 11 insertions(+), 6 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Aleksander Alekseev 2026-09-16 12:32:07 Re: pgsql: Revert online data checksum transitions
Previous Message Manuel Reyes Bravo 2026-09-16 12:26:16 Re: pgsql: Fix index rebuild progress reporting for REPACK (CONCURRENTLY)