Re: conchuela timeouts since 2021-10-09 system upgrade

From: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Noah Misch <noah(at)leadboat(dot)com>, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>, Michael Paquier <michael(at)paquier(dot)xyz>, Peter Geoghegan <pg(at)bowt(dot)ie>, Andres Freund <andres(at)anarazel(dot)de>
Subject: Re: conchuela timeouts since 2021-10-09 system upgrade
Date: 2021-10-25 08:30:32
Message-ID: B5CC4C8F-1B73-4359-AF68-26A08A17BCD1@yandex-team.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> 25 окт. 2021 г., в 02:53, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> написал(а):
>
> I can poke into it tomorrow.

FWIW it's easy to make the issue reproduce faster with following diff

diff --git a/contrib/amcheck/t/003_cic_2pc.pl b/contrib/amcheck/t/003_cic_2pc.pl
index f4255c1fb8..0d68c53387 100644
--- a/contrib/amcheck/t/003_cic_2pc.pl
+++ b/contrib/amcheck/t/003_cic_2pc.pl
@@ -141,7 +141,7 @@ $node->safe_psql('postgres', q(REINDEX TABLE tbl;));
my $pgbench_out = '';
my $pgbench_timer = IPC::Run::timeout(180);
my $pgbench_h = $node->background_pgbench(
- '--no-vacuum --client=1 --transactions=100',
+ '--no-vacuum --client=1 --transactions=1',
{
'002_pgbench_concurrent_cic' => q(
DROP INDEX CONCURRENTLY idx;

I.e. if pgbench exits earlier than we call finish() it always hangs. I observe reproduction on my Drogonfly VM and I can share VM state if it's of any help.

Best regards, Andrey Borodin.

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Andrew Gierth 2021-10-25 08:43:18 Re: BUG #17245: Index corruption involving deduplicated entries
Previous Message Marek Läll 2021-10-25 07:35:34 Re: BUG #17240: <timestamptz> at time zone ... ; wrong result