MIME-Version: 1.0
References: <AS2PR05MB1075477BA334D4DA262AD75BFEF16A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <AS2PR05MB107549DDE42DC0B8E31CB52BFEF90A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <5043ff13-2f39-4a80-a8f8-6765746b6a89@aklaver.com> <AS2PR05MB10754EE81F34146EE8972713EEF91A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <58221272-d684-4799-a113-d5a5031a0b05@aklaver.com> <AS2PR05MB107541E760AECB8639BB968B5EF63A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <fd548bde-54d3-426a-a2b6-058750cfb554@aklaver.com> <AS2PR05MB1075432E74AF2FA975B02519AEF61A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <b1fec029-b8fb-4177-a01a-9457e813ce68@aklaver.com> <AS2PR05MB107546BEE7B8092148A0B51A0EF61A@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <25b5291f-a3d3-4655-a3d3-57f28b70ec5a@aklaver.com> <AS2PR05MB107546C1B04FC4B3CCF32E60CEF7DA@AS2PR05MB10754.eurprd05.prod.outlook.com>
 <78328b08-249e-4251-8a10-b5dac183442a@aklaver.com> <DB5PR05MB107646FFE78759D1D5431F802EF7AA@DB5PR05MB10764.eurprd05.prod.outlook.com>
 <0868c260-9812-4629-b32d-026c1fe6089f@aklaver.com> <AS2PR05MB1075476F648651C8CC02D8048EF79A@AS2PR05MB10754.eurprd05.prod.outlook.com>
In-Reply-To: <AS2PR05MB1075476F648651C8CC02D8048EF79A@AS2PR05MB10754.eurprd05.prod.outlook.com>
From: Greg Sabino Mullane <htamfids@gmail.com>
Date: Mon, 9 Mar 2026 11:24:15 -0400
Message-ID: <CAKAnmmLsxdt51sp-w0JxMi0haGXHFKD2pXURfOSOa5iVzjni4w@mail.gmail.com>
Subject: Re: Index (primary key) corrupt?
To: Wim Rouquart <wim.rouquart@kbc.be>
Cc: Adrian Klaver <adrian.klaver@aklaver.com>, 
	"pgsql-general@lists.postgresql.org" <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000000d84eb064c990147"
Archived-At: <https://www.postgresql.org/message-id/CAKAnmmLsxdt51sp-w0JxMi0haGXHFKD2pXURfOSOa5iVzjni4w%40mail.gmail.com>
Precedence: bulk

--0000000000000d84eb064c990147
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Mon, Mar 9, 2026 at 10:12=E2=80=AFAM Wim Rouquart <wim.rouquart@kbc.be> =
wrote:

> I already saw finding the actual cause as a 'lost cause' as these things
> tend to happen, however what bothers me most is that a tool like amcheck
> which is supposed to find corruption also shows up with no result.
>

Well, no, these things really should not happen. :)

It may be too late, but it would be real interesting to see this query both
before and after the REINDEX:

select * from pg_index where indrelid  =3D 'bcf_work_type'::regclass and
indisprimary;

An incorrect indrelid is one way I can think of as to how pg_dump would
miss it, but that wouldn't explain why reindex would subsequently fix it.


Cheers,
Greg

--0000000000000d84eb064c990147
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Mon, Mar 9, 2026 at 10:12=E2=80=AFAM W=
im Rouquart &lt;<a href=3D"mailto:wim.rouquart@kbc.be">wim.rouquart@kbc.be<=
/a>&gt; wrote:</div><div class=3D"gmail_quote gmail_quote_container"><block=
quote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-left:1=
px solid rgb(204,204,204);padding-left:1ex">I already saw finding the actua=
l cause as a &#39;lost cause&#39; as these things tend to happen, however w=
hat bothers me most is that a tool like amcheck which is supposed to find c=
orruption also shows up with no result.<br></blockquote><div><br></div><div=
>Well, no, these things really should not happen. :)=C2=A0</div><div><br></=
div><div>It may be too late, but it would be real interesting to see this q=
uery both before and after the REINDEX:</div><div><br></div><div>select * f=
rom pg_index where indrelid =C2=A0=3D &#39;bcf_work_type&#39;::regclass and=
 indisprimary;</div><div><br></div><div>An incorrect indrelid is one way I =
can think of as to how pg_dump would miss it, but that wouldn&#39;t explain=
 why reindex would subsequently fix it.</div><div><br></div><div>=C2=A0</di=
v></div><div dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr"><div>Ch=
eers,</div><div>Greg</div><div><br></div></div></div></div>

--0000000000000d84eb064c990147--