Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale

From: Erik Wienhold <ewie(at)ewie(dot)name>
To: Matt Gibbins <matt_gibbins(at)fastmail(dot)com(dot)au>
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale
Date: 2023-03-26 09:37:43
Message-ID: 1158764658.329568.1679823463195@office.mailbox.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On 26/03/2023 10:26 CEST Matt Gibbins <matt_gibbins(at)fastmail(dot)com(dot)au> wrote:
>
> On 26/3/23 15:30, Erik Wienhold wrote:
> > ./icu-test yue-Hans
>
> Erik
>
> Thanks for the test code.
>
> I compiled and executed as instructed with the following result
>
> Matt
>
> __
>
> version = 67.1
> ucol_open
>   status = U_INVALID_FORMAT_ERROR

Okay, at least not a problem with Postgres. I wonder if libicudata is corrupt
or simply not compatible even though it's the same version according to the
filenames. Whats the hash of your libicu files?

find /usr/lib/x86_64-linux-gnu -name 'libicu*.so*' | xargs sha256sum | sort -k2

I get:

daecc24ce07ac15b77833042bd07fa5c62e8b82f5d2c38361b45fe76658b0e45 /usr/lib/x86_64-linux-gnu/libicudata.so
daecc24ce07ac15b77833042bd07fa5c62e8b82f5d2c38361b45fe76658b0e45 /usr/lib/x86_64-linux-gnu/libicudata.so.67
daecc24ce07ac15b77833042bd07fa5c62e8b82f5d2c38361b45fe76658b0e45 /usr/lib/x86_64-linux-gnu/libicudata.so.67.1
0dd9fd815ec02f5052cb666433d380cb372f6016213c83b13bbf4a402b09f198 /usr/lib/x86_64-linux-gnu/libicui18n.so
0dd9fd815ec02f5052cb666433d380cb372f6016213c83b13bbf4a402b09f198 /usr/lib/x86_64-linux-gnu/libicui18n.so.67
0dd9fd815ec02f5052cb666433d380cb372f6016213c83b13bbf4a402b09f198 /usr/lib/x86_64-linux-gnu/libicui18n.so.67.1
1702a12144088442b222fcbef1de64f319656c7b58001fdfd639b8689d6721c5 /usr/lib/x86_64-linux-gnu/libicuio.so
1702a12144088442b222fcbef1de64f319656c7b58001fdfd639b8689d6721c5 /usr/lib/x86_64-linux-gnu/libicuio.so.67
1702a12144088442b222fcbef1de64f319656c7b58001fdfd639b8689d6721c5 /usr/lib/x86_64-linux-gnu/libicuio.so.67.1
fc098d6df6825c1e46ac31d984a0c1839a514eef018b1f835b7610b00e008b92 /usr/lib/x86_64-linux-gnu/libicutest.so
fc098d6df6825c1e46ac31d984a0c1839a514eef018b1f835b7610b00e008b92 /usr/lib/x86_64-linux-gnu/libicutest.so.67
fc098d6df6825c1e46ac31d984a0c1839a514eef018b1f835b7610b00e008b92 /usr/lib/x86_64-linux-gnu/libicutest.so.67.1
742eedc54a2b6b12003fbb5a71105fae1ed3062b5c2765083d5310738fc2b2b6 /usr/lib/x86_64-linux-gnu/libicutu.so
742eedc54a2b6b12003fbb5a71105fae1ed3062b5c2765083d5310738fc2b2b6 /usr/lib/x86_64-linux-gnu/libicutu.so.67
742eedc54a2b6b12003fbb5a71105fae1ed3062b5c2765083d5310738fc2b2b6 /usr/lib/x86_64-linux-gnu/libicutu.so.67.1
650d19e2164b13dbcac1f1cd493dbc01f0e3d873086e3a718d9ca09ddd59f2fd /usr/lib/x86_64-linux-gnu/libicuuc.so
650d19e2164b13dbcac1f1cd493dbc01f0e3d873086e3a718d9ca09ddd59f2fd /usr/lib/x86_64-linux-gnu/libicuuc.so.67
650d19e2164b13dbcac1f1cd493dbc01f0e3d873086e3a718d9ca09ddd59f2fd /usr/lib/x86_64-linux-gnu/libicuuc.so.67.1

Maybe reinstalling libicu67 solves your issue.

I'm out of ideas at this point. I recommend addressing your issue to Debian
or the ICU mailing list:

https://bugs.debian.org/cgi-bin/pkgreport.cgi?package=libicu67
https://sourceforge.net/p/icu/mailman/

--
Erik

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Matt Gibbins 2023-03-26 11:41:24 Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale
Previous Message Matt Gibbins 2023-03-26 08:26:42 Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale