pg.ddx.io  pgsql-bugs@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Andrey Borodin <x4mmm@yandex-team.ru>
Cc: Noah Misch <noah@leadboat.com>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: Peter Geoghegan <pg@bowt.ie>
Cc: Andres Freund <andres@anarazel.de>
Subject: Re: conchuela timeouts since 2021-10-09 system upgrade
Date: Thu, 28 Oct 2021 11:47:01 -0400
Message-ID: <486056.1635436021@sss.pgh.pa.us> (raw)
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>

Andrey Borodin <x4mmm@yandex-team.ru> writes:
>> 26 окт. 2021 г., в 22:41, Tom Lane <tgl@sss.pgh.pa.us> написал(а):
>> 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





view thread (40+ messages)  latest in thread

Message-ID: <486056.1635436021@sss.pgh.pa.us>
Permalink:  ../486056.1635436021@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/486056.1635436021@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-bugs@postgresql.org
  Cc: tgl@sss.pgh.pa.us, x4mmm@yandex-team.ru, noah@leadboat.com, pgsql-bugs@lists.postgresql.org, michael@paquier.xyz, pg@bowt.ie, andres@anarazel.de
  Subject: Re: conchuela timeouts since 2021-10-09 system upgrade
  In-Reply-To: <486056.1635436021@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox