Feedback-ID: i0fe9450f:Fastmail
Date: Fri, 1 Mar 2024 18:12:43 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Ronan Dunklau <ronan.dunklau@aiven.io>
Cc: pgsql-bugs <pgsql-bugs@lists.postgresql.org>
Subject: Re: FSM Corruption (was: Could not read block at end of the relation)
Message-ID: <ZeGcC5qMUXm791oc@paquier.xyz>
References: 
 <VtPLBUerbMM8BSDLQwIMV9Co_38iHS1TXE4V09x2ZVFhPkZMNE8LwgPSIzB8PHkVFXykGx04QNAzZVjJFAnU1w==@protonmail.internalid>
 <1878547.tdWV9SEqCh@aivenlaptop>
 <1958255.PYKUYFuaPT@aivenlaptop>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="yYHk0xjvOtbsCVnj"
Content-Disposition: inline
In-Reply-To: <1958255.PYKUYFuaPT@aivenlaptop>
Archived-At: 
 <https://www.postgresql.org/message-id/ZeGcC5qMUXm791oc%40paquier.xyz>
Precedence: bulk


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

On Fri, Mar 01, 2024 at 09:56:51AM +0100, Ronan Dunklau wrote:
> In our case, we need to repair the FSM. The instructions on the wiki do w=
ork,=20
> but maybe we should add something like the attached patch (modeled after =
the=20
> same feature in pg_visibility) to make it possible to repair the FSM=20
> corruption online. What do you think about it ?

I vaguely recall that something like that has been suggested around
917dc7d2393c in the past.

> The investigation of the corruption is still ongoing.

Thanks!
--
Michael

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

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

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAmXhnAsACgkQnvQgOdby
QH2TEw/9E9gmdWUYeGxXtqEBSojLj4+/KikvarNLZ0dJnI4N/31tWFyZX4J2VFBP
Z6cauFgsbUJdvDsmMWHGeNMqR/pxMTdZpKXwwbcqE9XAPHxkUpd8U1+0bDXgWSjq
jY1gyG5BNzn34JD7ez4tR/kDUFXqaKmZs1LeuGm/oo/gwtZI+vYhV2wtkMkRgFY2
vNg5AlDJ461wdka77x+u7TmpLLdJqUwNdeHzd0uzjrijMUx3JhtSwExrAn1eZ4Qi
ibrEDuJeWqgbLOml4Y2DbjPwqaf6S48srgzrsXlxKGWlLe3R9MwQHLDHK6vfLoQJ
VdZm9SOTOnJGItm88Y8m3NLwL43RliPO7iH0iTdGULTVxzGDIhUTZ3jEBiVwlxF/
JNzuruRMGcp7NwjdI0vGoTrTcU1RrPsvWmk4dI4AiIv+fdO0tjiVnJKTR/KTYXw8
10q38Ce3+s0/yR16vBtu/RFNKc0StuDvP7pQJHQU3sHJMFqrkiL5rgzogikETL2N
BpVlkdqDzfDtqPvsD/omXlUhUaruXrFjfjNRJoTGWD1+nQtUfc0xwGDEDuilKL6P
Ty5gUst8doOyPeZv/Z3qp/PK6jUuUjIEPIwKaTEOOzplltbDXgCY9Cq23Zr9xrHH
iV5ZVBeGIMJkhK9VCrwZIDKGF/u1haOx3EIMrJhOag9bGgHwkRI=
=cNNd
-----END PGP SIGNATURE-----

--yYHk0xjvOtbsCVnj--