Message-ID: <7ff9de7f-7203-cad9-76d9-45497cbedac7@gmail.com>
Date: Wed, 24 Jul 2024 11:00:00 +0300
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.4.2
Subject: Re: race condition when writing pg_control
Content-Language: en-US
To: Thomas Munro <thomas.munro@gmail.com>, Noah Misch <noah@leadboat.com>
Cc: Andres Freund <andres@anarazel.de>, Tom Lane <tgl@sss.pgh.pa.us>,
 Nathan Bossart <nathandbossart@gmail.com>,
 Melanie Plageman <melanieplageman@gmail.com>,
 Michael Paquier <michael@paquier.xyz>,
 Fujii Masao <masao.fujii@oss.nttdata.com>,
 "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
References: <20200603020259.GA89559@paquier.xyz>
 <CA+hUKGKToqjdeRtr8ZHVbPToShun5ifjioj6x3nsjseOkhCMEQ@mail.gmail.com>
 <CAAKRu_YNGwEYrorQYza_W8tU+=toXRHG8HpyHC-KDbZqA_ZVSA@mail.gmail.com>
 <20240516183558.GA1620903@nathanxps13> <2136775.1715885450@sss.pgh.pa.us>
 <20240516185805.hnbt2tr23q7xbx3m@awork3.anarazel.de>
 <2138498.1715886091@sss.pgh.pa.us>
 <20240516190744.6beu43cjdvrml6uw@awork3.anarazel.de>
 <CA+hUKG+5GfOzJyH5dMh1ttgLcn8RwUS6Q=jJ+Cw_nPhq1cwsbw@mail.gmail.com>
 <CA+hUKGJU378uN_OOc28pN0hgjj2TFOb-jYZX6kamkGB9BBMK5w@mail.gmail.com>
 <20240712114322.08.nmisch@google.com>
 <CA+hUKGJ2Mfp1s+nKk1rxQytB0p2OVxUUiYTpi4S3a7UX862K5Q@mail.gmail.com>
From: Alexander Lakhin <exclusion@gmail.com>
In-Reply-To: 
 <CA+hUKGJ2Mfp1s+nKk1rxQytB0p2OVxUUiYTpi4S3a7UX862K5Q@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/7ff9de7f-7203-cad9-76d9-45497cbedac7%40gmail.com>
Precedence: bulk

Hello Thomas,

15.07.2024 06:44, Thomas Munro wrote:
> I'm going to upgrade this to a proposal:
>
> https://commitfest.postgresql.org/49/5124/
>
> I wonder how often this happens in the wild.

Please look at a recent failure [1], produced by buildfarm animal
culicidae, which tests EXEC_BACKEND. I guess it's caused by the issue
discussed.

Maybe it would make sense to construct a reliable reproducer for the
issue (I could not find a ready-to-use recipe in this thread)...

What do you think?

[1] https://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=culicidae&dt=2024-07-24%2004%3A08%3A23

Best regards,
Alexander