Re: Postgres 12: backend crashes when creating non-deterministic collation

Am 04.10.19 um 12:13 schrieb Thomas Kellerer:
> I was trying to learn how the new non-deterministic collations in v12
> work, but the following makes the backend crash:
>
> CREATE COLLATION de_ci (provider = icu, locale = 'de-x-icu',
> deterministic = false);
>
> Which leads to:
>
> 2019-10-04 11:54:23 CEST   LOG:  server process (PID 7540) was
> terminated by exception 0xC0000005
> 2019-10-04 11:54:23 CEST   DETAIL:  Failed process was running:
>     CREATE COLLATION de_ci (provider = icu, locale = 'de-x-icu',
> deterministic = false)
> 2019-10-04 11:54:23 CEST   HINT:  See C include file "ntstatus.h" for
> a description of the hexadecimal value.
> 2019-10-04 11:54:23 CEST   LOG:  terminating any other active server
> processes
> 2019-10-04 11:54:23 CEST   WARNING:  terminating connection because of
> crash of another server process
> 2019-10-04 11:54:23 CEST   DETAIL:  The postmaster has commanded this
> server process to roll back the current transaction and exit, because
> another server process exited abnormally and possibly corrupted shared
> memory.
>
> This is on Windows 10 with the Postgres 12 binaries from EDB.
> Exact Postgres version is: PostgreSQL 12.0, compiled by Visual C++
> build 1914, 64-bit
> The database was pg_upgraded if that makes any difference
>
>

works for me, with:

psql (12rc1 (Ubuntu 12~rc1-1.pgdg18.04+1))
Type "help" for help.

test=# CREATE COLLATION de_ci (provider = icu, locale = 'de-x-icu',
deterministic = false);
CREATE COLLATION
test=*# commit;
COMMIT
test=#

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com