A server crash with a SQL procedure returning a user-defined type on 14.8

Поиск
Список
Период
Сортировка
От Yahor Yuzefovich
Тема A server crash with a SQL procedure returning a user-defined type on 14.8
Дата
Msg-id CABz5gWHSjj2df6uG0NRiDhZ_Uz=Y8t0FJP-_SVSsRsnrQT76Gg@mail.gmail.com
обсуждение исходный текст
Ответы Re: A server crash with a SQL procedure returning a user-defined type on 14.8  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
Hello there,

I believe I encountered a bug with the following reproduction steps:

CREATE TYPE typ AS (a INT, b INT); CREATE PROCEDURE p_udt(OUT typ) AS $$ SELECT (1, 2); $$ LANGUAGE SQL; CALL p_udt(NULL);

which results in a server crash on version 14.8:

server closed the connection unexpectedly

This probably means the server terminated abnormally

before or while processing the request.

The connection to the server was lost. Attempting reset: WARNING:  terminating connection because of crash of another server process

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.

HINT:  In a moment you should be able to reconnect to the database and repeat your command.

Failed.


Best,

Yahor Yuzefovich

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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #18388: Server freezes after AuthenticationSASLFinal message
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: BUG #18387: Erroneous permission checks and/or misleading error messages with refresh materialized view