Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY

From: Петър Славов <pet(dot)slavov(at)gmail(dot)com>
To: Andrey Borodin <x4mmm(at)yandex-team(dot)ru>
Cc: PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY
Date: 2022-05-19 06:23:58
Message-ID: CAC5T6ECOXbWGTbg2uMXs8rBD5Jsc1vB104DyXySWMhKRkLSPNQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Hi Andrey,
This test looks similar to me but I cannot say what is the difference. My
tests are done under heavier load maybe.
Also I couldn't reproduce this with a table with low num number of columns
(integrer and text). I am not sure if this is relevant...

Peter

На чт, 19.05.2022 г. в 7:22 ч. Andrey Borodin <x4mmm(at)yandex-team(dot)ru> написа:

>
>
> > 18 мая 2022 г., в 15:42, PG Bug reporting form <noreply(at)postgresql(dot)org>
> написал(а):
> > I was able to reproduce this on PostgreSQL 14.1/2/3 locally on
> > docker instance and on AWS EC2.
>
>
> Uhm, that's very...interesting. I'll look closely next week. Though I
> didn't have a chance to reproduce yet.
> We have fixed similar problem in 14.1. And now we have very similar TAP
> test to you reproduction [0]. How do you think, what's the key difference
> between TAP test and your repro?
>
> Thanks! Best regards, Andrey Borodin.
>
> [0]
> https://github.com/postgres/postgres/blob/REL_14_STABLE/contrib/amcheck/t/002_cic.pl

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2022-05-19 08:02:32 Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY
Previous Message Петър Славов 2022-05-19 05:24:27 Re: BUG #17485: Records missing from Primary Key index when doing REINDEX INDEX CONCURRENTLY