Re: Postgres 12: backend crashes when creating non-deterministiccollation

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