public inbox for [email protected]  

help / color / mirror / Atom feed

From: Andrey Borodin <[email protected]>
To: Olegs Germanovs <[email protected]>
Cc: PostgreSQL mailing lists <[email protected]>
Subject: Re: 16.14 regression: startup process self-deadlocks during multixact WAL replay in RecordNewMultiXact
Date: Wed, 27 May 2026 17:48:51 +0500
Message-ID: <[email protected]> (raw)
In-Reply-To: <CA+yEoBxD18Z3VxOwLfk+959giwrt=6Jo5HujnvyZZN2Y63TWBg@mail.gmail.com>
References: <CA+yEoBxD18Z3VxOwLfk+959giwrt=6Jo5HujnvyZZN2Y63TWBg@mail.gmail.com>



> On 27 May 2026, at 17:33, Olegs Germanovs <[email protected]> wrote:
> 
> After upgrading from 16.13 to 16.14, archive recovery of a basebackup
>   hangs indefinitely during multixact WAL replay.

Hi Olegs!

Thanks for the detailed report! Your analysis of the self-deadlock is spot on.

The fix for this problem has already been committed to REL_16_STABLE as 42a3194e5483 [0].
It was discussed on the pgsql-bugs thread "BUG #19490: Streaming standby on 16.14 stops
applying WAL on MultiXactOffsetSLRU when primary is 16.8" [1].

Please let us know if you still observe the problem or any other unusual behavior.


Best regards, Andrey Borodin.



[0] https://git.postgresql.org/cgit/postgresql.git/commit/?h=REL_16_STABLE&id=42a3194e548349b658a808...
[1] https://www.postgresql.org/message-id/flat/46FE61C9-F273-45FD-BED7-0F8CDA6EB992%40yandex-team.ru#69d...

view thread (2+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected], [email protected]
  Subject: Re: 16.14 regression: startup process self-deadlocks during multixact WAL replay in RecordNewMultiXact
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox