BUG #18648: When I restore the database on rockylinux9, I will use amcheck to check that there will be an abnorm

From: PG Bug reporting form <noreply(at)postgresql(dot)org>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Cc: weijie1006jl(at)gmail(dot)com
Subject: BUG #18648: When I restore the database on rockylinux9, I will use amcheck to check that there will be an abnorm
Date: 2024-10-09 00:54:06
Message-ID: 18648-03806c678dfd819d@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 18648
Logged by: weijie JL
Email address: weijie1006jl(at)gmail(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message PG Bug reporting form 2024-10-09 01:34:39 BUG #18649: PG17 release note bug for "AS LOCAL"
Previous Message Tom Lane 2024-10-08 20:24:07 Re: BUG #18647: INSERT statements execute functions twice.