Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.600.51.1.1\))
Subject: Re: 16.14 regression: startup process self-deadlocks during multixact
 WAL replay in RecordNewMultiXact
From: Andrey Borodin <x4mmm@yandex-team.ru>
In-Reply-To: 
 <CA+yEoBxD18Z3VxOwLfk+959giwrt=6Jo5HujnvyZZN2Y63TWBg@mail.gmail.com>
Date: Wed, 27 May 2026 17:48:51 +0500
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <106926E9-B7D6-4F6A-A03C-94BFA76E9E4A@yandex-team.ru>
References: 
 <CA+yEoBxD18Z3VxOwLfk+959giwrt=6Jo5HujnvyZZN2Y63TWBg@mail.gmail.com>
To: Olegs Germanovs <olegs.germanovs@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/106926E9-B7D6-4F6A-A03C-94BFA76E9E4A%40yandex-team.ru>
Precedence: bulk


> On 27 May 2026, at 17:33, Olegs Germanovs <olegs.germanovs@gmail.com> =
wrote:
>=20
> 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=3DREL_16_STABLE&i=
d=3D42a3194e548349b658a808347df3d3d5e6b968af
[1] =
https://www.postgresql.org/message-id/flat/46FE61C9-F273-45FD-BED7-0F8CDA6=
EB992%40yandex-team.ru#69de260aa4dc6a1882732d466783afc9=