Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1mg7ca-0007JH-4N
	for pgsql-bugs@arkaria.postgresql.org; Thu, 28 Oct 2021 15:47:16 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-bugs-owner+archive@lists.postgresql.org>)
	id 1mg7cY-0007EG-Va
	for pgsql-bugs@arkaria.postgresql.org; Thu, 28 Oct 2021 15:47:14 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1mg7cY-0007E6-OA
	for pgsql-bugs@lists.postgresql.org; Thu, 28 Oct 2021 15:47:14 +0000
Received: from sss.pgh.pa.us ([66.207.139.130])
	by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <tgl@sss.pgh.pa.us>)
	id 1mg7cW-00086F-E5
	for pgsql-bugs@lists.postgresql.org; Thu, 28 Oct 2021 15:47:14 +0000
Received: from sss1.sss.pgh.pa.us (localhost [127.0.0.1])
	by sss.pgh.pa.us (8.15.2/8.15.2) with ESMTP id 19SFl1nG486057;
	Thu, 28 Oct 2021 11:47:02 -0400
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrey Borodin <x4mmm@yandex-team.ru>
cc: Noah Misch <noah@leadboat.com>,
        PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>,
        Michael Paquier <michael@paquier.xyz>, Peter Geoghegan <pg@bowt.ie>,
        Andres Freund <andres@anarazel.de>
Subject: Re: conchuela timeouts since 2021-10-09 system upgrade
In-reply-to: <D6202938-81AD-42DD-BDC6-D4221189251C@yandex-team.ru>
References: <20211019030212.GB3403374@rfd.leadboat.com>
 <20211024050028.GA3310519@rfd.leadboat.com>
 <64835CF9-D9AA-49BF-A685-01C23B1023C1@yandex-team.ru>
 <20211024161942.GB3945842@rfd.leadboat.com>
 <640FA6DC-A998-4499-B3B4-2773685B8C56@yandex-team.ru>
 <3792312.1635119599@sss.pgh.pa.us>
 <B5CC4C8F-1B73-4359-AF68-26A08A17BCD1@yandex-team.ru>
 <4170532.1635195582@sss.pgh.pa.us> <20211026015157.GA113335@rfd.leadboat.com>
 <52098.1635228234@sss.pgh.pa.us> <20211026134500.GA128912@rfd.leadboat.com>
 <139687.1635277318@sss.pgh.pa.us>
 <D6202938-81AD-42DD-BDC6-D4221189251C@yandex-team.ru>
Comments: In-reply-to Andrey Borodin <x4mmm@yandex-team.ru>
	message dated "Wed, 27 Oct 2021 14:08:51 +0300"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <486055.1635436021.1@sss.pgh.pa.us>
Content-Transfer-Encoding: quoted-printable
Date: Thu, 28 Oct 2021 11:47:01 -0400
Message-ID: <486056.1635436021@sss.pgh.pa.us>
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/486056.1635436021%40sss.pgh.pa.us>
Precedence: bulk

Andrey Borodin <x4mmm@yandex-team.ru> writes:
>> 26 =D0=BE=D0=BA=D1=82. 2021 =D0=B3., =D0=B2 22:41, Tom Lane <tgl@sss.pg=
h.pa.us> =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0=D0=BB(=D0=B0):
>> We can get around that though, by using pg_try_advisory_lock and not
>> proceeding if it fails.  The attached POC does this for the 002 test;
>> it looks like the same thing could be done to 003.

> That's a neat idea. PFA patch with copy of this changes to 003.

Pushed.  It'll be interesting to see if conchuela's behavior changes.

			regards, tom lane