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.
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. |