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 ) id 1wZYl6-0018OZ-1O for pgsql-bugs@arkaria.postgresql.org; Tue, 16 Jun 2026 18:43:37 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wZYl5-002G1E-09 for pgsql-bugs@arkaria.postgresql.org; Tue, 16 Jun 2026 18:43:35 +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 ) id 1wZYl4-002G16-25 for pgsql-bugs@lists.postgresql.org; Tue, 16 Jun 2026 18:43:34 +0000 Received: from forwardcorp1a.mail.yandex.net ([2a02:6b8:c0e:500:1:45:d181:df01]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wZYl2-00000000gbX-0fdC for pgsql-bugs@lists.postgresql.org; Tue, 16 Jun 2026 18:43:33 +0000 Received: from mail-nwsmtp-smtp-corp-main-66.iva.yp-c.yandex.net (mail-nwsmtp-smtp-corp-main-66.iva.yp-c.yandex.net [IPv6:2a02:6b8:c0c:bf1f:0:640:c739:0]) by forwardcorp1a.mail.yandex.net (Yandex) with ESMTPS id C3CDEC09EA; Tue, 16 Jun 2026 21:43:23 +0300 (MSK) Received: from smtpclient.apple (unknown [2a02:6bf:8080:898::1:25]) by mail-nwsmtp-smtp-corp-main-66.iva.yp-c.yandex.net (smtpcorp) with ESMTPSA id MhVQMi7aZ4Y0-zkxWihcq; Tue, 16 Jun 2026 21:43:23 +0300 X-Yandex-Fwd: 1 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yandex-team.ru; s=default; t=1781635403; bh=cOOeOFyP5FHYCdOeOFHRUk7gUxcmI5UzcIo+/WYTd9M=; h=Message-Id:To:Date:References:Cc:In-Reply-To:From:Subject; b=B85P4HjDlpz0MqtVwYGh75rDtwyFQ4PfYlZplw+2B35Pk4EjT9zLkeMbt6LFKSBId k1LzW8EjPkPyjMN6Sv8wvs9GHvXnq19/qf/8RG5ueVE/uiU9oyZM9KrLGDH4HHI33g Ik7/hpMm2D1S3tByoEoVxl2Oz6ExHxY2RokwF+GI= Authentication-Results: mail-nwsmtp-smtp-corp-main-66.iva.yp-c.yandex.net; dkim=pass header.i=@yandex-team.ru Content-Type: text/plain; charset=utf-8 Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3864.600.51.1.1\)) Subject: Re: BUG #19521: After a minor PostgreSQL update from 14.22 to 14.23, the database goes into an infinite loop. From: Andrey Borodin In-Reply-To: Date: Tue, 16 Jun 2026 23:43:12 +0500 Cc: sdaekb@yandex.ru, PostgreSQL mailing lists Content-Transfer-Encoding: quoted-printable Message-Id: <416ADEE5-0410-488A-BCFF-C3D8E1D3E6A0@yandex-team.ru> References: To: =?utf-8?Q?=C3=81lvaro_Herrera?= X-Mailer: Apple Mail (2.3864.600.51.1.1) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 16 Jun 2026, at 23:36, =C3=81lvaro Herrera = wrote: >=20 > On 2026-Jun-15, Andrey Borodin wrote: >=20 >>> On 15 Jun 2026, at 18:39, PG Bug reporting form = wrote: >>>=20 >>> After rolling back to version 14.22, everything works as intended. >>=20 >> Hi! Thanks for the report. Can you please give a bit more logs? This = excerpt is >> missing errors from the startup process. And message from this = process could shed >> a light on a root cause. >=20 > I suspect e35e466f61b [1] might be related. That's a bug that was > fixed in 2bb60eb4fea [2], just after 14.23. >=20 > [1] https://postgr.es/c/e35e466f61b > [2] https://postgr.es/c/2bb60eb4fea >=20 > If not, some data from pg_waldump around the problem area might be = useful. Yeah, that was my concern. But that bug manifests as startup process = failure. I've contacted Sergey offlist, he observed hanging postgres: data: startup recovering 000000060000C29100000016 so it's hard to tell what's going on without backtrace... Best regards, Andrey Borodin.=