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 1wZzfX-001SLt-1W for pgsql-bugs@arkaria.postgresql.org; Wed, 17 Jun 2026 23:27:40 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1wZzfW-008CLz-0Z for pgsql-bugs@arkaria.postgresql.org; Wed, 17 Jun 2026 23:27:38 +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 1wZzfV-008CLq-2z for pgsql-bugs@lists.postgresql.org; Wed, 17 Jun 2026 23:27:37 +0000 Received: from fout-b7-smtp.messagingengine.com ([202.12.124.150]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.98.2) (envelope-from ) id 1wZzfU-00000000sXN-2POQ for pgsql-bugs@lists.postgresql.org; Wed, 17 Jun 2026 23:27:37 +0000 Received: from phl-compute-02.internal (phl-compute-02.internal [10.202.2.42]) by mailfout.stl.internal (Postfix) with ESMTP id 851A31D000C0; Wed, 17 Jun 2026 19:27:34 -0400 (EDT) Received: from phl-frontend-04 ([10.202.2.163]) by phl-compute-02.internal (MEProxy); Wed, 17 Jun 2026 19:27:34 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=paquier.xyz; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm1; t=1781738854; x=1781825254; bh=HxNaDpv5dT mkqnQEo/J7RYZGSVWYGJVISCylZWqDgKo=; b=CgvsrLHTUAqkTVl+nsOCD3eu6o DdtJ3qw5tAGYYImKsZSmHhI0HzGdjm3/pZfBNXuufEqzDtRGPqpu+ETimwfNgOVm n+tmbve64uuF/4NDDCr6n1jX2deHxqEYHZjnqZXUEQiQ/BXAODazNr92VJCf7mFA pr1ddpuO/C78LHaMjI6sJlywnQ3C6KcTg+EG3YaLgpEtWjSWc+bbuXuF2oC1Xl/5 YxmxHvhJvdyqbJBZz1qjuRYDDvYHMk4c02+0lXKWPQUk2PcHpebrMgJjAANLiTuA 0Be/M+TTsoBj0xxLn65tcAgAM+1bTziQuNn/k1q4uyXrfrzevQhOAR7uGCzQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; t= 1781738854; x=1781825254; bh=HxNaDpv5dTmkqnQEo/J7RYZGSVWYGJVISCy lZWqDgKo=; b=Zngp1ay20VqDZzab8L/AYtXQNWWGtCLrlrYZtwaRZ0UK6FqH0FN DP6OBF8jsy5zt34IzcqEOKq2HHdoTkCXX35GO82DQhwlLu8JqMm+xVIJcOMRsroP OkSJ2fRLuN7boMU6ZiCD+zgzs5V3z0CGiGaqehZYwy+1S9S3aLpyvya2auzCvk2j 854nAxPnweu5PQN4Igd1AquI9lwLFj5kP4ToNyLE9hlutFkNt85rDT0zR0id/ocG Epa3L+sf0MFz3xIb397/zjUilJuZbAmzCIvRzSOaPZ7g8ilNSsbUK9mr8a8nD78e mF9zMlAbZ4TN0Va+0c0kZlEU+26g4c2xHTQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: dmFkZTEUSz3uFJMigjinLdPc45yZZiDK+6GPZCEgtQzPwefF+owRQLNV7FAhbHEoBgsY+t qGhxe0OJHe6ig4d499KmVMsIHDn3sHCmGDatJ5eHiIgATPX0su1FjJ0JIhv21QYNqvhblA Eofij10WVLqqBsJ1SYVv0AfolmOfm5QTRnwdf2qkdy10DRRE6HLyXhhTQz44rozzBtvEGe U8DptqJ3Y/MG7/cWiRS2qq2b/WHFHI0tqjck1TovSsUN+b960eZmb6l7b1FeSulRFpUbg/ gyBGr2zm3nM9wkDBYZb+5n1+og0WuQWl7XEfiBWR73keUNBa6GWBLLX2bAWvOyXcOAKysM RinaAGxyHPtwqylmcGpIiUpKx3Ycv8wU/6r48GZ/squFDuY21ZrywYgLa9QyOwGTUSYeCq UuSOP5iCXkIJclAsOFU3XLo0Nz8+jCW7nPlC4Q7mQnvAl83WS161NLiYPoIDKq7Fv60O4K u/LZHg0s2pKAc0g1+tqq5kzoKLLptqaJczCthCzjX+BFbd5xpjNJ65Fc9ml7n59EnwXzWn FjB8l/TmC02+ET3jNGaIWnd9z53Qm8RLBdAofaVHPJMZnRJFo0YrEuYdgFFZgdX9JoVexV MkjFs1WouFiYNsThkSOWwHNR5NzNkZraHQtXz5KXBONqoODv74/z1yq74hbg X-ME-Proxy: Feedback-ID: i0fe9450f:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Wed, 17 Jun 2026 19:27:32 -0400 (EDT) Date: Thu, 18 Jun 2026 08:27:28 +0900 From: Michael Paquier To: =?utf-8?B?0KHQtdGA0LPQtdC5INCU0LwuINCQ0L/QvtC50YfQtdC90LrQvg==?= Cc: Andrey Borodin , =?iso-8859-1?Q?=C1lvaro?= Herrera , PostgreSQL mailing lists Subject: Re: BUG #19521: After a minor PostgreSQL update from 14.22 to 14.23, the database goes into an infinite loop. Message-ID: References: <416ADEE5-0410-488A-BCFF-C3D8E1D3E6A0@yandex-team.ru> <2281171781713245@mail.yandex.ru> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="y7D6ZZ6+VycrT4b9" Content-Disposition: inline In-Reply-To: <2281171781713245@mail.yandex.ru> List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --y7D6ZZ6+VycrT4b9 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Wed, Jun 17, 2026 at 09:49:22PM +0500, =D0=A1=D0=B5=D1=80=D0=B3=D0=B5=D0= =B9 =D0=94=D0=BC. =D0=90=D0=BF=D0=BE=D0=B9=D1=87=D0=B5=D0=BD=D0=BA=D0=BE wr= ote: > It doesn't seem to be a code error, but rather a configuration issue > on the server itself. Given that I cannot provide any additional > information and was unable to reproduce the error, I would like to > close the ticket. Thank you for your response. Okay, thanks for the update. The handling of multixacts during recovery has already been tweaked a bit. I think that we are in a good spot in terms of lock handling in the stable branches, but if you still see something strange, please feel free to update this thread with more information for investigation. -- Michael --y7D6ZZ6+VycrT4b9 Content-Type: application/pgp-signature; name=signature.asc -----BEGIN PGP SIGNATURE----- iQIzBAEBCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmozLWAACgkQnvQgOdby QH3z/Q/+N7D8T1MfuJ1/hp82JoUeWbM4/UWbUsWUTn2lENORoBsCzJHSD8UOJ7JX qDHVUW3Z1Zolg9l+7sGD6Mk4c+yD8WL+/S63mi5XljkeXNH9cz7CEtHnUrpVX+PX FPlLGlSVD6tHzAziw+t5AXC8TuyYgz84T05R6tHrpc1Ty6yKTMwhnTGRlNXPUKHA PcchVMXWRU3p8FviDiVWCXTumtl8wGYsXtyxo12ghdnSRQbSzahRlgiQwj2b0h6T Tys4anICjWtnQFu9VBS+gDf5o5ak6n8eW/+Dy1pjd5WbDSnGqFrmzIczRmx7fSBn afwuqSFQJLnZAdu4PkvCzXZ4R2iUifGgVSP03vWAWtt/gVQotY2hyPMt7w2xdAkM sNGouRiVXebMELe4k+Jyz3um696yPsPFXrAiYKIV5Zc78OVAguGntjo/FsP5IVHO yL+uBtMmdm6anGvFoHws9WqLio66cd+iSF4k41vLtSIc75ZKXIdLmygDE9s8+LkO jNZpp0wPQ7IS4VUeM7sBkhysVdlkHvFWtxjyxrjUGpaEyjPeY2vJ8bYXgr3iSFBB 5yOUOIV6uKyCODHDr6C7BSLZ5KbdjKnTjaHOOrsjQ4DOSR4jttlJuLcwtvzWs5yB A+Omz9CWiKQ8wSWXdKePIfD+vri4dDJpcuTDLc4mkTjdZGQ0Wjs= =99GM -----END PGP SIGNATURE----- --y7D6ZZ6+VycrT4b9--