Re: Corrupt btree index includes rows that don't match - Mailing list pgsql-general

From shammat@gmx.net
Subject Re: Corrupt btree index includes rows that don't match
Date
Msg-id 6833523d-8e84-4749-952a-dcbfe9246d19@gmx.net
Whole thread Raw
In response to Corrupt btree index includes rows that don't match  (Erik Johnston <erikj@element.io>)
Responses Re: Corrupt btree index includes rows that don't match
List pgsql-general
> One coincidence is that we started seeing the first symptoms of this
> around the same time as libicu was updated with a security patch.
> However, postgres hasn’t been restarted and doesn’t reference the
> new version in its process maps. Plus state groups are integers
> anyway. We also use the C locale, not ICU.
Sounds as if you are hit by locale changes:

https://wiki.postgresql.org/wiki/Locale_data_changes


I think you will need to upgrade to prevent future problems like that:

Postgres 15 introduced some mechanisms to track and validate version discrepancies after an OS update.

Postgres 17 added a "built-in" collation provider which is independent of glibc






pgsql-general by date:

Previous
From: Erik Johnston
Date:
Subject: Corrupt btree index includes rows that don't match
Next
From: Ron Johnson
Date:
Subject: Re: Corrupt btree index includes rows that don't match