Feedback-ID: i0fe9450f:Fastmail
Date: Tue, 25 Jun 2024 13:00:39 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Kyotaro Horiguchi <horikyota.ntt@gmail.com>
Cc: florisvannee@optiver.com, andres@anarazel.de,
	bertranddrouvot.pg@gmail.com, tgl@sss.pgh.pa.us,
	pgsql-bugs@lists.postgresql.org
Subject: Re: error "can only drop stats once" brings down database
Message-ID: <ZnpA5zqSgW2FfqYF@paquier.xyz>
References: <20240611.164457.1388765109177375375.horikyota.ntt@gmail.com>
 <ZmuQz8IN6MpLxKs8@paquier.xyz>
 <Zm91CpHheqXC_S_V@paquier.xyz>
 <20240625.092248.1063552122181843294.horikyota.ntt@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="5Cok7QvNokBhS0HR"
Content-Disposition: inline
In-Reply-To: <20240625.092248.1063552122181843294.horikyota.ntt@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/ZnpA5zqSgW2FfqYF%40paquier.xyz>
Precedence: bulk


--5Cok7QvNokBhS0HR
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Tue, Jun 25, 2024 at 09:22:48AM +0900, Kyotaro Horiguchi wrote:
> Is it something like this? I forgot the reason why this was excluded
> from the vinal version, though.
>=20
> https://www.postgresql.org/message-id/20201001.090722.322196928507744460.=
horikyota.ntt%40gmail.com

That's a bit different than the gc_count presented in 0004, because
there is no relationship to autovacuum with the cleanup of the
entries, still there is some overlap in the thought process: this
suggestion just makes sure that any backend holding local references
to a shared entry with a different age does not attempt to manipulate
it after switching locally to a dropped state.=20
--
Michael

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

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

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmZ6QOcACgkQnvQgOdby
QH1B2BAAmmgcEZ93ufYNuMfLqZ9xBvL3vK946VlZhVyjE+RssIcpSe0bEvtR/F8l
6CSp8LDwbGSynrTcq3rto/wuQC9e/OSkv0Kf91YLi1g6xSd+i/fquuKRmMZ7n8a0
Ka/x0bdJd6IUomzCwRs0QToxd/sC6KRw/KOskop/+YhopixJuR5l3BHAjkhsIRqA
ZBSoMgQP244ADnvt+4xF2eBHgZKEJhZ7+5htaDf48MiBIlc8O62JcZI7vh0r1Cui
vvaOQN1XxVA2cee0sp6VwkPN9txz8Nzz1vh5e7/73nidlr8oFJKVIipP/kD7EhVX
dGthSMllYckXosvrF92jJwyTNbkRxKXBrpXEuh9BHvbh9cYIDaKQNnqCJEGH+sfs
hUXKpG3SZww9Xs+tMFo+gdy8ezW8Nx4t8WmfV5zkPTWrxImh9vz9GJXSpHoQL+tY
bz8EHPb9ra+l4xOaESf6SyOrNcffxREBpzM89NYcwudOBT0dJBrRqjSca0MSZ8m9
lfAoYP/t4kisxnEbY/FAfVHUIUV9MbatkM2C4/ikkrdL0Rw+dHarS3O7O8iuEHSV
qcFJ1BpJ7K/+Ybk5aEBjCWwjShMk6SSXZNgKCuS3lIyeZE0BmQYI4jhQj2GIKs1x
Uk/Thoug2hY5tQqiqU2TrH8ne1PouH2d+C3f6M2uLBWC1xd2ZDY=
=0PBR
-----END PGP SIGNATURE-----

--5Cok7QvNokBhS0HR--