Date: Sat, 29 Jan 2022 14:43:08 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Peter Geoghegan <pg@bowt.ie>
Cc: Noah Misch <noah@leadboat.com>, Maxim Boguk <maxim.boguk@gmail.com>,
	PostgreSQL mailing lists <pgsql-bugs@lists.postgresql.org>
Subject: Re: BUG #17386: btree index corruption after reindex concurrently on
 write heavy table
Message-ID: <YfTT7BBonfQYLPdX@paquier.xyz>
References: <17386-2227568627fb44ce@postgresql.org>
 <CAK-MWwQ7fboHz_s8aTn08i0W2aNH6QoELeWwmH-y80tOfsdDBQ@mail.gmail.com>
 <20220129023418.GA2452893@rfd.leadboat.com>
 <CAH2-WzkH8zHOS2X49jmc67_G5TXM8kNSh285nHKpmpf+qa8Rrg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="DfEoysDLhbIT8VXn"
Content-Disposition: inline
In-Reply-To: 
 <CAH2-WzkH8zHOS2X49jmc67_G5TXM8kNSh285nHKpmpf+qa8Rrg@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/YfTT7BBonfQYLPdX%40paquier.xyz>
Precedence: bulk


--DfEoysDLhbIT8VXn
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

On Fri, Jan 28, 2022 at 07:00:31PM -0800, Peter Geoghegan wrote:
> If I had to guess, then I'd guess that this has something to do with
> orphaned HOT chains, like those we saw in the bug report that led to
> bugfix commit 18b87b20 (which is in 14.2 but not 14.1). I could easily
> be wrong about that, so take it with a grain of salt. I find it a
> little suspicious that we're hearing about a REINDEX CONCURRENTLY
> problem in Postgres 14, which is much less mature than Postgres 12
> (where REINDEX CONCURRENTLY first appeared).

Possible, but hard to say without an actual proof.  Maxim, if the
problem is reproducible easily on your end, could you give a try to v12
and v13 and see if it happens as well there?
--
Michael

--DfEoysDLhbIT8VXn
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmH00+wACgkQnvQgOdby
QH0Elw//boAX/DUWBW/C1t+wywMzUk4pcm3TdAiZDK8o+zUIbcTl+3sB+V4OhH4Y
OntW1klTG1vwnwq99FusEfzdy6UGmgTAQAd46Oi5QBdJ62fCk3KcTg2okUZPPTiN
i6m+gxUMGy2DUvCClB4NxnLqXcGI6xh4QHZMaUqdUkkvjCB0qPQ48L/lLmIopvn5
RgE1tJOiCKkE2fYK8EaXMjIOzJrhC4YgfjNbTpzmk5EVkOAtouNw4hAQ7oOzU1Xy
vGwS5QDokq8aQeGOoc4k2wZ4uwEYIOE571PdBQo7bdYpbg1+bcSdusmGCcm8Dcw6
xHYb7IBW2Q1OreHRfeRb2dHrj7GeNrBtLJvAMfXa8bcAFvEAoz0m2nV24CPh96xE
Uzd/WR/FajYM0SpEm0kC3U2dYF/cPllCfX6UVow/HSIlGCP/CJV3nNbLH7f1DJVR
1Z0Qx+ciAojtu4XTNTGaddWNx9HPLSQEXGpCKgrgh8F4yZInRbyfBPDwFYqqF4wr
cKevEset73QsaVpkhSqMxnZG7YPxzMpuoaAb80b4qK9HwAwBbGY4Ou0og0NL9mJ6
vQpiCoDave5/d6OJGblHQ9uMsvv8NpsClNHrd4RVcnsejexmNNa/w/4a80JYLBtG
/Fx5gSjW7uZTlyRlUTkVLr5fA+NVoPjLma3A7Pzpgq28AnJwYU4=
=qX7n
-----END PGP SIGNATURE-----

--DfEoysDLhbIT8VXn--