Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1wPxmd-001BBY-1E
	for pgsql-bugs@arkaria.postgresql.org;
	Thu, 21 May 2026 07:25:31 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.96)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1wPxmb-009aZo-1A
	for pgsql-bugs@arkaria.postgresql.org;
	Thu, 21 May 2026 07:25:30 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.96)
	(envelope-from <x4mmm@yandex-team.ru>)
	id 1wPxma-009aZg-34
	for pgsql-bugs@lists.postgresql.org;
	Thu, 21 May 2026 07:25:30 +0000
Received: from forwardcorp1a.mail.yandex.net ([178.154.239.72])
	by makus.postgresql.org with esmtps  (TLS1.3) tls
 TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384
	(Exim 4.98.2)
	(envelope-from <x4mmm@yandex-team.ru>)
	id 1wPxmX-00000000466-2hDe
	for pgsql-bugs@lists.postgresql.org;
	Thu, 21 May 2026 07:25:29 +0000
Received: from mail-nwsmtp-smtp-corp-main-69.vla.yp-c.yandex.net
 (mail-nwsmtp-smtp-corp-main-69.vla.yp-c.yandex.net
 [IPv6:2a02:6b8:c1f:3a87:0:640:845c:0])
	by forwardcorp1a.mail.yandex.net (Yandex) with ESMTPS id 33DF6C0200;
	Thu, 21 May 2026 10:25:22 +0300 (MSK)
Received: from smtpclient.apple (regus.net [204.209.177.179])
	by mail-nwsmtp-smtp-corp-main-69.vla.yp-c.yandex.net (smtpcorp) with ESMTPSA
 id GPNXAU0MEmI0-lHtMNPzE;
	Thu, 21 May 2026 10:25:21 +0300
X-Yandex-Fwd: 1
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex-team.ru;
	s=default; t=1779348321;
	bh=hKSJWx1kiYUQIwsEVRqR3RBLLNuh/0+OqaBmZ+CHFt8=;
	h=Message-Id:To:Date:References:Cc:In-Reply-To:From:Subject;
	b=dDsgBcZUg+33J3Dft624z4CM7aW03J3GbtiTGXl2hpKoEceFCNI76yuo3k4rwsoX3
	 OPMjdbjk9Mc3erLl10Y5jHms3gK79sL54g5yPngh7MnZj1jqeWOWa4a7/Fv9I8PfBK
	 qOln44t2JvZsZln0xp90IKhR6WqmoSXhmFrNSdHo=
Authentication-Results: mail-nwsmtp-smtp-corp-main-69.vla.yp-c.yandex.net;
 dkim=pass header.i=@yandex-team.ru
Content-Type: text/plain;
	charset=us-ascii
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.500.181\))
Subject: Re: BUG #19490: Streaming standby on 16.14 stops applying WAL on
 MultiXactOffsetSLRU when primary is 16.8
From: Andrey Borodin <x4mmm@yandex-team.ru>
In-Reply-To: 
 <CAL9smLBMxKBCmsA9UGcmf93bT2_MsZ+POH-oHREuwKdmMU7jfQ@mail.gmail.com>
Date: Thu, 21 May 2026 00:25:05 -0700
Cc: radim@boringsql.com,
 PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Content-Transfer-Encoding: 7bit
Message-Id: <46DB3CAB-EA1C-41A5-9D6D-5F913A2AAF66@yandex-team.ru>
References: <19490-9c59c6a583513b99@postgresql.org>
 <46FE61C9-F273-45FD-BED7-0F8CDA6EB992@yandex-team.ru>
 <CAL9smLBMxKBCmsA9UGcmf93bT2_MsZ+POH-oHREuwKdmMU7jfQ@mail.gmail.com>
To: Marko Tiikkaja <marko@joh.to>
X-Mailer: Apple Mail (2.3864.500.181)
List-Id: <pgsql-bugs.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-bugs@lists.postgresql.org>
List-Owner: <mailto:pgsql-bugs-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-bugs>
Archived-At: 
 <https://www.postgresql.org/message-id/46DB3CAB-EA1C-41A5-9D6D-5F913A2AAF66%40yandex-team.ru>
Precedence: bulk



> On 21 May 2026, at 00:12, Marko Tiikkaja <marko@joh.to> wrote:
> 
> #8  0x0000654c8ae2acba in SimpleLruWriteAll (ctl=0x654c8b63e400

Thanks!

This clearly points to SimpleLruWriteAll() added in 77dff5d937b1.
If by chance you will have a backtrace of another deadlocking process -
please post it.

But it's not strictly necessary for analysis, I think we can figure out what
happened from the backtrace you already posted.


Best regards, Andrey Borodin.