From: | PetSerAl <petseral(at)gmail(dot)com> |
---|---|
To: | pgsql-bugs(at)lists(dot)postgresql(dot)org |
Subject: | Server crash when selecting from pg_cursors |
Date: | 2024-10-06 16:15:10 |
Message-ID: | CAKygsHTBXLXjwV43kpZa+Cs+XTiaeeJiZdL4cPBm9f4MTdw7wg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
postgres=# SELECT version();
version
-------------------------------------------------------------------------
PostgreSQL 17.0 on x86_64-windows, compiled by msvc-19.41.34120, 64-bit
(1 row)
postgres=# CREATE TABLE t (a integer, b integer);
CREATE TABLE
postgres=# CREATE FUNCTION f() RETURNS integer
postgres-# STABLE STRICT LANGUAGE plpgsql
postgres-# AS $$
postgres$# BEGIN
postgres$# PERFORM FROM pg_cursors;
postgres$# RETURN null;
postgres$# END
postgres$# $$;
CREATE FUNCTION
postgres=# DO $$
postgres$# DECLARE
postgres$# a integer;
postgres$# BEGIN
postgres$# FOR a IN SELECT t.a FROM t WHERE t.b = f() LOOP
postgres$# END LOOP;
postgres$# END
postgres$# $$;
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
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: Failed.
The connection to the server was lost. Attempting reset: Failed.
!?>
Server log:
[21932] LOG: server process (PID 22552) was terminated by exception 0xC0000005
[21932] DETAIL: Failed process was running: DO $$
DECLARE
a integer;
BEGIN
FOR a IN SELECT t.a FROM t WHERE t.b = f() LOOP
END LOOP;
END
$$;
[21932] HINT: See C include file "ntstatus.h" for a description of
the hexadecimal value.
[21932] LOG: terminating any other active server processes
[21932] LOG: all server processes terminated; reinitializing
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2024-10-06 18:08:25 | Re: Server crash when selecting from pg_cursors |
Previous Message | Erik Wienhold | 2024-10-06 14:49:49 | Re: Error when setting default_text_search_config |