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
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 |