Postgres 12: backend crashes when creating non-deterministiccollation

Поиск
Список
Период
Сортировка
От Thomas Kellerer
Тема Postgres 12: backend crashes when creating non-deterministiccollation
Дата
Msg-id 58edf560-f277-8993-abe3-22d57dc11c50@gmx.net
обсуждение исходный текст
Ответы Re: Postgres 12: backend crashes when creating non-deterministiccollation  (Laurenz Albe <laurenz.albe@cybertec.at>)
Re: Postgres 12: backend crashes when creating non-deterministiccollation  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Список pgsql-general
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
transactionand 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

I might have misunderstood how to use deterministic to create a case-insensitive collation, but I don't think the
backendshould crash if I do something wrong ;) 

Regards
Thomas




В списке pgsql-general по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: BitmapAnd on correlated column?
Следующее
От: Marcelo Lacerda
Дата:
Сообщение: Clarification on the release notes of postgresql 12 regarding pg_upgrade