pg.ddx.io  pgsql-hackers@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Alexander Lakhin <exclusion@gmail.com>
To: Thomas Munro <thomas.munro@gmail.com>
To: Noah Misch <noah@leadboat.com>
Cc: Andres Freund <andres@anarazel.de>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Nathan Bossart <nathandbossart@gmail.com>
Cc: Melanie Plageman <melanieplageman@gmail.com>
Cc: Michael Paquier <michael@paquier.xyz>
Cc: Fujii Masao <masao.fujii@oss.nttdata.com>
Cc: pgsql-hackers@postgresql.org <pgsql-hackers@postgresql.org>
Subject: Re: race condition when writing pg_control
Date: Wed, 24 Jul 2024 11:00:00 +0300
Message-ID: <7ff9de7f-7203-cad9-76d9-45497cbedac7@gmail.com> (raw)
In-Reply-To: <CA+hUKGJ2Mfp1s+nKk1rxQytB0p2OVxUUiYTpi4S3a7UX862K5Q@mail.gmail.com>
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>

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





view thread (32+ messages)  latest in thread

Message-ID: <7ff9de7f-7203-cad9-76d9-45497cbedac7@gmail.com>
Permalink:  ../7ff9de7f-7203-cad9-76d9-45497cbedac7@gmail.com/
Also on:    postgresql.org/message-id/7ff9de7f-7203-cad9-76d9-45497cbedac7@gmail.com

 · 

reply
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-hackers@postgresql.org
  Cc: exclusion@gmail.com, thomas.munro@gmail.com, noah@leadboat.com, andres@anarazel.de, tgl@sss.pgh.pa.us, nathandbossart@gmail.com, melanieplageman@gmail.com, michael@paquier.xyz, masao.fujii@oss.nttdata.com
  Subject: Re: race condition when writing pg_control
  In-Reply-To: <7ff9de7f-7203-cad9-76d9-45497cbedac7@gmail.com>

* 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