From: | oktogen(at)mail(dot)ru |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #13671: pg_terminate_backend(pid) does not work |
Date: | 2015-10-09 07:43:34 |
Message-ID: | 20151009074334.1217.18732@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 13671
Logged by: alex
Email address: oktogen(at)mail(dot)ru
PostgreSQL version: 9.4.5
Operating system: ubuntu
Description:
The command pg_terminate_backend(pid) does not terminate sql session
in case incorrect formed COPY command(without terminate-symbol)
Example
--SESSION #1
CREATE TABLE public.comments (
user_id INTEGER NOT NULL,
description TEXT NOT NULL,
path public.ltree NOT NULL,
CONSTRAINT comments_idx PRIMARY KEY(user_id, description, path)
)WITHOUT OIDS;
COPY comments (user_id, description, path) FROM stdin;
1 efbb974bcf5af8f2ba8f352225ecff63 0001
2 8dcdb42684773f413b40d63f5ef0722e 0001.0001.0001
--
--SESSION #2
-- Now SESSION # 1 can not be forced to complete the outside.
-- learn pid process which need terminate
SELECT a.pid,
a.usename,
a.application_name,
a.client_addr,
clock_timestamp() - a.query_start AS duration,
a.state,
a.query,
a.waiting
FROM pg_stat_activity a;
--attempt to finish the session with incorrect COPY command
SELECT pg_terminate_backend(6476) AS output;
-- output
-------------
-- TRUE
SELECT
a.pid,
a.state,
a.query
FROM pg_stat_activity a
WHERE a.pid = 6476;
-- output(failed attempt)
+-----+--------+---------------------------------------------------------+
| pid | state | query |
+-----+--------+---------------------------------------------------------+
|6476 | active | COPY comments (user_id, description, path) FROM stdin; |
+-----+--------+---------------------------------------------------------+
From | Date | Subject | |
---|---|---|---|
Next Message | Haribabu Kommi | 2015-10-09 07:53:55 | Re: BUG #13670: DST discrepancy between age() and subtraction for timestamptz arguments |
Previous Message | Noah Misch | 2015-10-09 03:26:49 | Re: [BUGS] BUG #13611: test_postmaster_connection failed (Windows, listen_addresses = '0.0.0.0' or '::') |