From: Alvaro Herrera <alvherre@alvh.no-ip.org>
To: Andrey Borodin <x4mmm@yandex-team.ru>
Cc: Andres Freund <andres@anarazel.de>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Peter Geoghegan <pg@bowt.ie>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: Петър Славов <pet.slavov@gmail.com>
Cc: PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY
Date: Tue, 31 May 2022 17:30:51 +0200
Message-ID: <202205311530.yrxaulmj4d7y@alvherre.pgsql> (raw)
In-Reply-To: <4B1BA5BF-37EC-4EE7-AB3B-4C4D95A8059A@yandex-team.ru>
On 2022-May-28, Andrey Borodin wrote:
> And reverting d9d0762 does not fix the issue. I'm not sure if I'm observing some other problem here.
>
> v4 of a test not use pg_sleep() and fails with regular amcheck
> failure. Reverting d9d0762 fixes the test. Unless I execute the test
> for 1 million transactions, then it fail even with a revert...
>
> I suspect that v3 and v4 triggers different problems.
Hmm, the only failure I see with v4 is a deadlock of this sort:
2022-05-31 17:26:13.400 CEST [130375] 004_rc.pl ERROR: deadlock detected
2022-05-31 17:26:13.400 CEST [130375] 004_rc.pl DETAIL: Process 130375 waits for ShareLock on transaction 36108; blocked by process 130372.
Process 130372 waits for ShareLock on transaction 36107; blocked by process 130375.
Process 130375: INSERT INTO tbl VALUES(random()*1000,0,0,0,now())
on conflict(i) do update set updated_at = now();
Process 130372: INSERT INTO tbl VALUES(random()*1000,0,0,0,now())
on conflict(i) do update set updated_at = now();
which is of course not very interesting.
--
Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/
<Schwern> It does it in a really, really complicated way
<crab> why does it need to be complicated?
<Schwern> Because it's MakeMaker.
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: alvherre@alvh.no-ip.org, x4mmm@yandex-team.ru, andres@anarazel.de, robertmhaas@gmail.com, pg@bowt.ie, michael@paquier.xyz, pet.slavov@gmail.com, pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY
In-Reply-To: <202205311530.yrxaulmj4d7y@alvherre.pgsql>
* 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