pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #18648: When I restore the database on rockylinux9, I will use amcheck to check that there will be an abnorm
3+ messages / 3 participants
[nested] [flat]
* BUG #18648: When I restore the database on rockylinux9, I will use amcheck to check that there will be an abnorm
@ 2024-10-09 00:54 PG Bug reporting form <noreply@postgresql.org>
2024-10-09 08:40 ` Re: BUG #18648: When I restore the database on rockylinux9, I will use amcheck to check that there will be an abnorm Heikki Linnakangas <hlinnaka@iki.fi>
2024-10-10 01:02 ` Re: BUG #18648: When I restore the database on rockylinux9, I will use amcheck to check that there will be an abnorm weijie JL <weijie1006jl@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: PG Bug reporting form @ 2024-10-09 00:54 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: weijie1006jl@gmail.com
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #18648: When I restore the database on rockylinux9, I will use amcheck to check that there will be an abnorm
2024-10-09 00:54 BUG #18648: When I restore the database on rockylinux9, I will use amcheck to check that there will be an abnorm PG Bug reporting form <noreply@postgresql.org>
@ 2024-10-09 08:40 ` Heikki Linnakangas <hlinnaka@iki.fi>
1 sibling, 0 replies; 3+ messages in thread
From: Heikki Linnakangas @ 2024-10-09 08:40 UTC (permalink / raw)
To: weijie1006jl@gmail.com, pgsql-bugs@lists.postgresql.org, PG Bug reporting form <noreply@postgresql.org>
On 09/10/2024 03:54, PG Bug reporting form wrote:
> 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.
Could be this issue: https://wiki.postgresql.org/wiki/Locale_data_changes
--
Heikki Linnakangas
Neon (https://neon.tech)
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #18648: When I restore the database on rockylinux9, I will use amcheck to check that there will be an abnorm
2024-10-09 00:54 BUG #18648: When I restore the database on rockylinux9, I will use amcheck to check that there will be an abnorm PG Bug reporting form <noreply@postgresql.org>
@ 2024-10-10 01:02 ` weijie JL <weijie1006jl@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: weijie JL @ 2024-10-10 01:02 UTC (permalink / raw)
To: weijie1006jl@gmail.com; pgsql-bugs@lists.postgresql.org
It is indeed this issue that caused the problem. Thank you very much.
> 2024年10月9日 08:54，PG Bug reporting form <noreply@postgresql.org> 写道：
>
> 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.
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2024-10-10 01:02 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-10-09 00:54 BUG #18648: When I restore the database on rockylinux9, I will use amcheck to check that there will be an abnorm PG Bug reporting form <noreply@postgresql.org>
2024-10-09 08:40 ` Heikki Linnakangas <hlinnaka@iki.fi>
2024-10-10 01:02 ` weijie JL <weijie1006jl@gmail.com>
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