From: weijie JL <weijie1006jl@gmail.com>
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable
Mime-Version: 1.0 (Mac OS X Mail 16.0 \(3818.100.11.1.3\))
Subject: Re: BUG #18648: When I restore the database on rockylinux9, I will
 use amcheck to check that there will be an abnorm
Date: Thu, 10 Oct 2024 09:02:10 +0800
References: <18648-03806c678dfd819d@postgresql.org>
To: weijie1006jl@gmail.com,
 pgsql-bugs@lists.postgresql.org
In-Reply-To: <18648-03806c678dfd819d@postgresql.org>
Message-Id: <DE01E143-955F-4914-8A29-198EF7518152@gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/DE01E143-955F-4914-8A29-198EF7518152%40gmail.com>
Precedence: bulk

It is indeed this issue that caused the problem. Thank you very much.


> 2024=E5=B9=B410=E6=9C=889=E6=97=A5 08:54=EF=BC=8CPG Bug reporting form =
<noreply@postgresql.org> =E5=86=99=E9=81=93=EF=BC=9A
>=20
> The following bug has been logged on the website:
>=20
> Bug reference:      18648
> Logged by:          weijie JL
> Email address:      weijie1006jl@gmail.com
> PostgreSQL version: 14.12
> Operating system:   RockyLinux 9
> Description:       =20
>=20
> I used dnf to install PostgreSQL on a physical machine running Rocky =
Linux
> 9, and then performed a database restore using the pgBackRest tool. =
After
> multiple experiments, I still found that there were index corruption =
issues
> after the restore. Specifically, using amcheck to check the indexes =
resulted
> in the following error: ERROR: XX002: item order invariant violated =
for
> index "idx_template_xxxx_unique". However, this restore process does =
not
> reproduce the issue on CentOS 7.9. The business impact of this index =
anomaly
> is that when the query performs a full table scan, it can retrieve the
> required data, but when using the index, the query results are empty.
>=20