Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale - Mailing list pgsql-admin

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.

body,div,table,thead,tbody,tfoot,tr,th,td,p { font-family:"Liberation Sans"; font-size:x-small }a.comment-indicator:hover + comment { background:#ffd; position:absolute; display:block; border:1px solid black; padding:0.5em; }a.comment-indicator { background:red; display:inline-block; border:1px solid black; width:0.5em; height:0.5em; }comment { display:none; }