From: Matt Gibbins <matt_gibbins@fastmail.com.au>
To: Erik Wienhold <ewie@ewie.name>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale
Date: Sun, 26 Mar 2023 22:41:24 +1100
Message-ID: <d6e581b0-8103-3bf2-0c86-2dbcfd977115@fastmail.com.au> (raw)
In-Reply-To: <1158764658.329568.1679823463195@office.mailbox.org>
References: <93809259-173b-9bf0-acb8-d6e0b5c06b87@fastmail.com.au>
<1684230080.452693.1679762358599@office.mailbox.org>
<7429705a-e70f-03d5-9ef3-c60d86d65786@fastmail.com.au>
<1970524333.377932.1679805006974@office.mailbox.org>
<cb655280-a7b5-01a9-3f6b-c1b31ef47396@fastmail.com.au>
<1158764658.329568.1679823463195@office.mailbox.org>
On 26/3/23 20:37, Erik Wienhold wrote:
>> On 26/03/2023 10:26 CEST Matt Gibbins<matt_gibbins@fastmail.com.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
Erik
Thank you for your assistance.
The offending library was libicudata.so.67.1.
Reinstalling libicu67 has resolved the issue.
Not sure why it wasn't upgraded as I have been doing several upgrades on
the system.
Matt.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: matt_gibbins@fastmail.com.au, ewie@ewie.name, pgsql-admin@lists.postgresql.org
Subject: Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale
In-Reply-To: <d6e581b0-8103-3bf2-0c86-2dbcfd977115@fastmail.com.au>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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