Major changes in sorting method of glibc on Ubuntu 18.04 after upgrading to Ubuntu 18.04.5

[Christian Ehrhardt]

On Thu, Feb 25, 2021 at 6:47 PM Ганиев Ильяс <family-gan at yandex.ru> wrote:
>
> I had an Ubuntu 18.04.0 with Postgres 9.6.
>
> Before Ubuntu upgrade following command result was:
>
> vodka at ubuntu140:~$  ( echo "1-1"; echo "11" ) | LC_COLLATE=en_US.UTF-8 sort
> 1-1
> 11
>
> But after upgrading Ubuntu 18.04 to latest release via apt upgrade (18.04.5) result of the command above totally changed:
>
> vodka at ubuntu140:~$ ( echo "1-1"; echo "11" ) | LC_COLLATE=en_US.UTF-8 sort
> 11
> 1-1
>
> Due to this our production Postgres database started work very slowly and we had a long downtime for REINDEX. Sorting method is very important for Postgres database: https://wiki.postgresql.org/wiki/Locale_data_changes
>
> Please, read "Testing collation" part.
>
> Is it normal behavior for Ubuntu? Why glibc totally changed within LTS release without 'major upgrade'? I did not expect this...

Hi,
this has been filed and discussed here:
https://bugs.launchpad.net/ubuntu/+source/base-files/+bug/1916935
I'd ask you to read (and write if you have more to add) there for
further progress on this.

> --
> Ubuntu-devel-discuss mailing list
> Ubuntu-devel-discuss at lists.ubuntu.com
> Modify settings or unsubscribe at: https://lists.ubuntu.com/mailman/listinfo/ubuntu-devel-discuss



-- 
Christian Ehrhardt
Staff Engineer, Ubuntu Server
Canonical Ltd