Re: race condition in pg_class - Mailing list pgsql-hackers

From Andrey M. Borodin
Subject Re: race condition in pg_class
Date
Msg-id 2B34E318-9FC7-40B4-B156-FC2EC7F9262A@yandex-team.ru
Whole thread Raw
In response to race condition in pg_class  (Smolkin Grigory <smallkeen@gmail.com>)
List pgsql-hackers

> On 25 Oct 2023, at 13:39, Smolkin Grigory <smallkeen@gmail.com> wrote:
>
> We are running PG13.10 and recently we have encountered what appears to be a bug due to some race condition between
ALTERTABLE ... ADD CONSTRAINT and some other catalog-writer, possibly ANALYZ 

> I've tried to reproduce this scenario with CREATE INDEX and various concurrent statements, but no luck.

Maybe it would be possible to reproduce with modifying tests for concurrent index creation. For example add “ANALYZE”
here[0]. 
Keep in mind that for easier reproduction it would make sense to increase transaction count radically.


Best regards, Andrey Borodin.


[0] https://github.com/postgres/postgres/blob/master/contrib/amcheck/t/002_cic.pl#L34




pgsql-hackers by date:

Previous
From: Aleksander Alekseev
Date:
Subject: Re: RFC: Pluggable TOAST
Next
From: Andrei Zubkov
Date:
Subject: Re: [PATCH] Tracking statements entry timestamp in pg_stat_statements