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

Ron Johnson schrieb am 04.07.2025 um 12:05:
> On Fri, Jul 4, 2025 at 5:50 AM <shammat(at)gmx(dot)net <mailto:shammat(at)gmx(dot)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.