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

From: Michael Banck <mbanck(at)gmx(dot)net>
To: Sebastian Webber <sebastian(at)swebber(dot)me>
Cc: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: Re: 17.8 standby crashes during WAL replay from 17.5 primary: "could not access status of transaction"
Date: 2026-02-14 09:05:02
Message-ID: 20260214090150.GC2297@p46.dedyn.io;lightning.p46.dedyn.io
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi,

On Fri, Feb 13, 2026 at 05:31:18PM -0300, Sebastian Webber wrote:
> 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.

Ouch.

For the record, somebody else (Jacob Bunk Nielsen) reported the same(?) issue
independently on Slack:

|We are running a PostgreSQL 17.7 primary with a number of physical replicas. We upgraded some of the replicas from 17.5 to 17.8 earlier today, and now 4 of them consistently die after a short time with errors like:
|
|Feb 13 13:36:01 srv2 postgres[13068]: [12-1] 2026-02-13 13:36:01 UTC::@:[13068]: FATAL: could not access status of transaction 155428864
|Feb 13 13:36:01 srv2 postgres[13068]: [12-2] 2026-02-13 13:36:01 UTC::@:[13068]: DETAIL: Could not read from file "pg_multixact/offsets/0943" at offset 172032: read too few bytes.
|Feb 13 13:36:01 srv2 postgres[13068]: [12-3] 2026-02-13 13:36:01 UTC::@:[13068]: CONTEXT: WAL redo at 9F79/27144740 for MultiXact/CREATE_ID: 155428863 offset 1359592572 nmembers 2: 448728610 (keysh) 448728612 (keysh)
|
|Did we hit a bug in the newly released 17.8?

Sebastian, as it looks like you are able to reproduce it - are you maybe in a
position to bisect from 17.5 to 17.8 to see which commit is responsible for this?

Michael

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Richard Guo 2026-02-14 09:41:00 Re: BUG #19405: Assertion in eval_windowaggregates() fails due to integer overflow
Previous Message Thomas Munro 2026-02-14 08:15:45 Re: BUG #19406: substring(text) fails on valid UTF-8 toasted value in PostgreSQL 15.16