Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pgMpz-0005Gj-7z for pgsql-admin@arkaria.postgresql.org; Sun, 26 Mar 2023 09:38:55 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pgMoy-0001KI-8Y for pgsql-admin@arkaria.postgresql.org; Sun, 26 Mar 2023 09:37:52 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pgMox-0001K9-Tm for pgsql-admin@lists.postgresql.org; Sun, 26 Mar 2023 09:37:51 +0000 Received: from mout-u-107.mailbox.org ([80.241.59.207]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pgMou-0004bY-Pp for pgsql-admin@lists.postgresql.org; Sun, 26 Mar 2023 09:37:51 +0000 Received: from smtp1.mailbox.org (smtp1.mailbox.org [IPv6:2001:67c:2050:b231:465::1]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-384) server-signature RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by mout-u-107.mailbox.org (Postfix) with ESMTPS id 4PkrTN0hTzz9sTS; Sun, 26 Mar 2023 11:37:44 +0200 (CEST) Date: Sun, 26 Mar 2023 11:37:43 +0200 (CEST) From: Erik Wienhold To: Matt Gibbins Cc: pgsql-admin@lists.postgresql.org Message-ID: <1158764658.329568.1679823463195@office.mailbox.org> In-Reply-To: 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> Subject: Re: Debian PostgreSQL 15 pg_createcluster - could not open collator for locale MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Priority: 3 Importance: Normal X-Rspamd-Queue-Id: 4PkrTN0hTzz9sTS List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On 26/03/2023 10:26 CEST Matt Gibbins wrot= e: > > 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 =3D 67.1 > ucol_open > =C2=A0 status =3D U_INVALID_FORMAT_ERROR Okay, at least not a problem with Postgres. I wonder if libicudata is corr= upt or simply not compatible even though it's the same version according to the filenames. Whats the hash of your libicu files? =09find /usr/lib/x86_64-linux-gnu -name 'libicu*.so*' | xargs sha256sum | s= ort -k2 I get: =09daecc24ce07ac15b77833042bd07fa5c62e8b82f5d2c38361b45fe76658b0e45 /usr/l= ib/x86_64-linux-gnu/libicudata.so =09daecc24ce07ac15b77833042bd07fa5c62e8b82f5d2c38361b45fe76658b0e45 /usr/l= ib/x86_64-linux-gnu/libicudata.so.67 =09daecc24ce07ac15b77833042bd07fa5c62e8b82f5d2c38361b45fe76658b0e45 /usr/l= ib/x86_64-linux-gnu/libicudata.so.67.1 =090dd9fd815ec02f5052cb666433d380cb372f6016213c83b13bbf4a402b09f198 /usr/l= ib/x86_64-linux-gnu/libicui18n.so =090dd9fd815ec02f5052cb666433d380cb372f6016213c83b13bbf4a402b09f198 /usr/l= ib/x86_64-linux-gnu/libicui18n.so.67 =090dd9fd815ec02f5052cb666433d380cb372f6016213c83b13bbf4a402b09f198 /usr/l= ib/x86_64-linux-gnu/libicui18n.so.67.1 =091702a12144088442b222fcbef1de64f319656c7b58001fdfd639b8689d6721c5 /usr/l= ib/x86_64-linux-gnu/libicuio.so =091702a12144088442b222fcbef1de64f319656c7b58001fdfd639b8689d6721c5 /usr/l= ib/x86_64-linux-gnu/libicuio.so.67 =091702a12144088442b222fcbef1de64f319656c7b58001fdfd639b8689d6721c5 /usr/l= ib/x86_64-linux-gnu/libicuio.so.67.1 =09fc098d6df6825c1e46ac31d984a0c1839a514eef018b1f835b7610b00e008b92 /usr/l= ib/x86_64-linux-gnu/libicutest.so =09fc098d6df6825c1e46ac31d984a0c1839a514eef018b1f835b7610b00e008b92 /usr/l= ib/x86_64-linux-gnu/libicutest.so.67 =09fc098d6df6825c1e46ac31d984a0c1839a514eef018b1f835b7610b00e008b92 /usr/l= ib/x86_64-linux-gnu/libicutest.so.67.1 =09742eedc54a2b6b12003fbb5a71105fae1ed3062b5c2765083d5310738fc2b2b6 /usr/l= ib/x86_64-linux-gnu/libicutu.so =09742eedc54a2b6b12003fbb5a71105fae1ed3062b5c2765083d5310738fc2b2b6 /usr/l= ib/x86_64-linux-gnu/libicutu.so.67 =09742eedc54a2b6b12003fbb5a71105fae1ed3062b5c2765083d5310738fc2b2b6 /usr/l= ib/x86_64-linux-gnu/libicutu.so.67.1 =09650d19e2164b13dbcac1f1cd493dbc01f0e3d873086e3a718d9ca09ddd59f2fd /usr/l= ib/x86_64-linux-gnu/libicuuc.so =09650d19e2164b13dbcac1f1cd493dbc01f0e3d873086e3a718d9ca09ddd59f2fd /usr/l= ib/x86_64-linux-gnu/libicuuc.so.67 =09650d19e2164b13dbcac1f1cd493dbc01f0e3d873086e3a718d9ca09ddd59f2fd /usr/l= ib/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 Debia= n or the ICU mailing list: https://bugs.debian.org/cgi-bin/pkgreport.cgi?package=3Dlibicu67 https://sourceforge.net/p/icu/mailman/ -- Erik