Feedback-ID: i6d194797:Fastmail
Content-Type: multipart/alternative;
 boundary="------------AKQ43HQn1CNiWrm00fAYIJvW"
Message-ID: <d6e581b0-8103-3bf2-0c86-2dbcfd977115@fastmail.com.au>
Date: Sun, 26 Mar 2023 22:41:24 +1100
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101
 Thunderbird/102.9.0
Subject: Re: Debian PostgreSQL 15 pg_createcluster - could not open collator
 for locale
Content-Language: en-AU
To: Erik Wienhold <ewie@ewie.name>
Cc: pgsql-admin@lists.postgresql.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>
From: Matt Gibbins <matt_gibbins@fastmail.com.au>
In-Reply-To: <1158764658.329568.1679823463195@office.mailbox.org>
Archived-At: 
 <https://www.postgresql.org/message-id/d6e581b0-8103-3bf2-0c86-2dbcfd977115%40fastmail.com.au>
Precedence: bulk

This is a multi-part message in MIME format.
--------------AKQ43HQn1CNiWrm00fAYIJvW
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

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.


--------------AKQ43HQn1CNiWrm00fAYIJvW
Content-Type: text/html; charset=UTF-8
Content-Transfer-Encoding: 8bit

<html>
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <div class="moz-cite-prefix">On 26/3/23 20:37, Erik Wienhold wrote:<br>
    </div>
    <blockquote type="cite"
      cite="mid:1158764658.329568.1679823463195@office.mailbox.org">
      <blockquote type="cite">
        <pre class="moz-quote-pre" wrap="">On 26/03/2023 10:26 CEST Matt Gibbins <a class="moz-txt-link-rfc2396E" href="mailto:matt_gibbins@fastmail.com.au">&lt;matt_gibbins@fastmail.com.au&gt;</a> wrote:

On 26/3/23 15:30, Erik Wienhold wrote:
</pre>
        <blockquote type="cite">
          <pre class="moz-quote-pre" wrap="">./icu-test yue-Hans
</pre>
        </blockquote>
        <pre class="moz-quote-pre" wrap="">
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
</pre>
      </blockquote>
      <pre class="moz-quote-pre" wrap="">
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:

<a class="moz-txt-link-freetext" href="https://bugs.debian.org/cgi-bin/pkgreport.cgi?package=libicu67">https://bugs.debian.org/cgi-bin/pkgreport.cgi?package=libicu67</a>
<a class="moz-txt-link-freetext" href="https://sourceforge.net/p/icu/mailman/">https://sourceforge.net/p/icu/mailman/</a>

--
Erik
</pre>
    </blockquote>
    <p>Erik <br>
    </p>
    <p>Thank you for your assistance.</p>
    <p>The offending library was libicudata.so.67.1.</p>
    <p>Reinstalling  libicu67 has resolved the issue. </p>
    <p>Not sure why it wasn't upgraded as I have been doing several
      upgrades on the system. <br>
    </p>
    <p>Matt.<br>
    </p>
    <p><br>
    </p>
    <p>
      <style type="text/css">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;  }</style></p>
  </body>
</html>

--------------AKQ43HQn1CNiWrm00fAYIJvW--