From: Michael Paquier <michael@paquier.xyz>
To: Andres Freund <andres@anarazel.de>
Cc: Andrey Borodin <x4mmm@yandex-team.ru>
Cc: Alvaro Herrera <alvherre@alvh.no-ip.org>
Cc: Robert Haas <robertmhaas@gmail.com>
Cc: Peter Geoghegan <pg@bowt.ie>
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: Mon, 30 May 2022 15:54:08 +0900
Message-ID: <YpRqEBsFui+lzGj9@paquier.xyz> (raw)
In-Reply-To: <20220528193413.cvhno3ky4tikuiqo@alap3.anarazel.de>
References: <CA+TgmoYP7BnHXTEoJRUnOuie2J05Qo8ti5mnE2u-1c4Hk+8zJw@mail.gmail.com>
<202205251643.2py5jjpaw7wy@alvherre.pgsql>
<20220527231332.jwvrx6b3ytzt5snv@alap3.anarazel.de>
<A4F69174-AEC8-4108-BD32-CF201E56AF3E@yandex-team.ru>
<20220528070219.kbj527dx2sxmuomi@alap3.anarazel.de>
<4B1BA5BF-37EC-4EE7-AB3B-4C4D95A8059A@yandex-team.ru>
<20220528193413.cvhno3ky4tikuiqo@alap3.anarazel.de>
On Sat, May 28, 2022 at 12:34:13PM -0700, Andres Freund wrote:
> I've not been able to reproduce this issue. Even after increasing the number
> of clients and transactions, and running the test a number of times. With
> d9d0762 reverted, the problem doesn't happen anymore for me.
Neither was I able to reproduce this issue after a couple of hours
making my laptop hotter, using either the TAP tests or some equivalent
manual tests, and the revert of d9d0762 helps.
> Any chance you hit this with d9d0762 reverted? It's easy to e.g. revert and
> run the tests without recreating the temp-install, to reduce cycle times.
>
> Was there anything else running on the system? c98763bf51bf also needs to
> reverted, of course.
Yeah, I agree that we'd better revert c98763bf for the time being.
And f9900df on top of that?
I was trying to think of ways to get an isolation test out of that,
but that proves to be sort of tricky as we need to manipulate the HOT
chains after the validation phase has begun with the snapshot from the
build phase. It is easy to block before the validation transaction
starts, like in WaitForLockersMultiple() beforehand, though.
--
Michael
Attachments:
signature.asc (application/pgp-signature, 832B) download
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: michael@paquier.xyz, andres@anarazel.de, x4mmm@yandex-team.ru, alvherre@alvh.no-ip.org, robertmhaas@gmail.com, pg@bowt.ie, 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: <YpRqEBsFui+lzGj9@paquier.xyz>
* 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