From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: weijie1006jl@gmail.com
Subject: BUG #18648: When I restore the database on rockylinux9, I will use amcheck to check that there will be an abnorm
Date: Wed, 09 Oct 2024 00:54:06 +0000
Message-ID: <18648-03806c678dfd819d@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18648
Logged by: weijie JL
Email address: weijie1006jl@gmail.com
PostgreSQL version: 14.12
Operating system: RockyLinux 9
Description:
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.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, weijie1006jl@gmail.com
Subject: Re: BUG #18648: When I restore the database on rockylinux9, I will use amcheck to check that there will be an abnorm
In-Reply-To: <18648-03806c678dfd819d@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox