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

From: Yahor Yuzefovich <yahor(at)cockroachlabs(dot)com>
To: pgsql-bugs(at)lists(dot)postgresql(dot)org
Subject: A server crash with a SQL procedure returning a user-defined type on 14.8
Date: 2024-03-11 22:19:37
Message-ID: CABz5gWHSjj2df6uG0NRiDhZ_Uz=Y8t0FJP-_SVSsRsnrQT76Gg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2024-03-11 23:02:16 Re: BUG #18387: Erroneous permission checks and/or misleading error messages with refresh materialized view
Previous Message PG Bug reporting form 2024-03-11 22:13:56 BUG #18388: Server freezes after AuthenticationSASLFinal message