Thread: Re: Corrupt btree index includes rows that don't match

Re: Corrupt btree index includes rows that don't match

From
shammat@gmx.net
Date:
Ron Johnson schrieb am 04.07.2025 um 12:05:
> On Fri, Jul 4, 2025 at 5:50 AM <shammat@gmx.net <mailto:shammat@gmx.net>> wrote:
>
>     > 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 <https://wiki.postgresql.org/wiki/Locale_data_changes>
>
> Why?  Locale only cares about strings, and "Plus state groups are integers anyway."

Ah, I misread it to be about the the room_id.