Date: Thu, 13 Jun 2024 13:22:23 -0700
From: Noah Misch <noah@leadboat.com>
To: Michail Nikolaev <michail.nikolaev@gmail.com>
Cc: Michael Paquier <michael@paquier.xyz>,
	Robert Haas <robertmhaas@gmail.com>, pgsql-hackers@postgresql.org,
	Tom Lane <tgl@sss.pgh.pa.us>, Smolkin Grigory <smallkeen@gmail.com>
Subject: Re: race condition in pg_class
Message-ID: <20240613202223.11.nmisch@google.com>
References: <20240512232923.aa.nmisch@google.com>
 <20240605181706.fe.nmisch@google.com>
 <CA+TgmobfMU5pdXP36D5iAwxV5WKE_vuDLtp_1QyH+H5jMMt21g@mail.gmail.com>
 <ZmJENQ1BiMoStBPD@paquier.xyz>
 <CA+TgmoZ_Qezv0+AXN4s=OumQwvo9cf+1e+BA=y42WKth+QQK+A@mail.gmail.com>
 <20240611021927.30.nmisch@google.com>
 <ZmfUgRBbyLIGoHyM@paquier.xyz>
 <CANtu0ohuv2t02FcxrWxLbLJ_RosWuShsCdhy0PUJ_bTd_9MWrw@mail.gmail.com>
 <20240612194857.1c.nmisch@google.com>
 <CANtu0ogYLrufbSWOLDjfcDNCU=R6i2SJCEG_Uejtezx_+2vHng@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CANtu0ogYLrufbSWOLDjfcDNCU=R6i2SJCEG_Uejtezx_+2vHng@mail.gmail.com>
User-Agent: Mutt/2.2.12 (2023-09-09)
Archived-At: 
 <https://www.postgresql.org/message-id/20240613202223.11.nmisch%40google.com>
Precedence: bulk

On Wed, Jun 12, 2024 at 10:02:00PM +0200, Michail Nikolaev wrote:
> > Can you say more about the connection you see between $SUBJECT and that?
> That
> > looks like a valid report of an important bug, but I'm not following the
> > potential relationship to $SUBJECT.
> 
> I was guided by the following logic:
> * A pg_class race condition can cause table indexes to look stale.
> * REINDEX updates indexes
> * errors can be explained by different backends using different arbiter
> indexes

Got it.  The race condition of $SUBJECT involves inplace updates, and the
wrong content becomes permanent.  Hence, I suspect they're unrelated.