17.8 standby crashes during WAL replay from 17.5 primary: "could not access status of transaction"

From: Sebastian Webber <sebastian(at)swebber(dot)me>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: 17.8 standby crashes during WAL replay from 17.5 primary: "could not access status of transaction"
Date: 2026-02-13 20:31:18
Message-ID: CACV2tSw3VYS7d27ftO_cs+aF3M54+JwWBbqSGLcKoG9cvyb6EA@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

PostgreSQL version: 17.8 (standby), 17.5 (primary)

Primary: PostgreSQL 17.5 (Debian 17.5-1.pgdg130+1) on
aarch64-unknown-linux-gnu
Standby: PostgreSQL 17.8 (Debian 17.8-1.pgdg13+1) on
aarch64-unknown-linux-gnu

Platform: Docker containers on macOS (Apple Silicon / aarch64), Docker
Desktop

Description
-----------

A PostgreSQL 17.8 standby crashes during WAL replay when streaming
from a 17.5 primary. The crash occurs after replaying a
MultiXact/TRUNCATE_ID record followed by a MultiXact/CREATE_ID
record.

Steps to reproduce
------------------

1. Start a 17.5 primary configured for streaming replication
2. Seed a database with ~2GB of data (tables with foreign key
constraints)
3. Start a 17.5 standby via pg_basebackup, confirm streaming
replication
4. Generate ~500K MultiXact IDs using concurrent SELECT ... FOR SHARE
/ FOR KEY SHARE on the same rows
5. Run VACUUM on the multixact-heavy tables (generates TRUNCATE_ID
WAL records)
6. Stop the 17.5 standby
7. Continue generating ~2M additional MultiXact IDs on the primary
(builds WAL backlog)
8. Start a 17.8 standby on the same data volume -- it begins
replaying the WAL backlog
9. Standby crashes during replay

An automated reproducer (Go program + shell scripts) is available at:
https://gist.github.com/sebastianwebber/2cd25d298bfe85cabcd8d41f83591acb

It requires Go 1.22+ and Docker. Typical runtime is ~10 minutes.

go run main.go --cleanup

Actual output (standby log)
----------------------------

The standby successfully replays multiple SLRU page boundaries with
this pattern:

DEBUG: next offsets page is not initialized, initializing it now
CONTEXT: WAL redo at 3/28C148D8 for MultiXact/CREATE_ID: 856063 offset
6680130 nmembers 9: ...
DEBUG: skipping initialization of offsets page 418 because it was
already initialized on multixid creation
CONTEXT: WAL redo at 3/28C149B8 for MultiXact/ZERO_OFF_PAGE: 418

This repeats for pages 408 through 418. Then a truncation occurs:

DEBUG: replaying multixact truncation: offsets [1, 490986), offsets
segments [0, 7), members [1, 3864017), members segments [0, 49)
CONTEXT: WAL redo at 3/29D6D548 for MultiXact/TRUNCATE_ID: offsets [1,
490986), members [1, 3864017)

The very next CREATE_ID crashes:

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)

LOG: startup process (PID 29) exited with exit code 1
LOG: shutting down due to startup process failure

Expected output
---------------

The standby should successfully replay all WAL records and reach a
consistent streaming state.

Configuration (non-default on primary)
--------------------------------------

wal_level = replica
max_wal_senders = 10
max_connections = 1200
shared_buffers = 256MB
wal_keep_size = 16GB
autovacuum_multixact_freeze_max_age = 100000
vacuum_multixact_freeze_min_age = 1000
vacuum_multixact_freeze_table_age = 50000

Standby configured with log_min_messages = debug1.

--
Sebastian Webber

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Nathan Bossart 2026-02-13 21:00:18 Re: BUG #19407: pg_dump : DROP RULE creates forward references
Previous Message Tom Lane 2026-02-13 20:18:19 Re: BUG #19409: Function jsonb_strip_nulls() changed from immutable to stable.