BUG #13671: pg_terminate_backend(pid) does not work
От | oktogen@mail.ru |
---|---|
Тема | BUG #13671: pg_terminate_backend(pid) does not work |
Дата | |
Msg-id | 20151009074334.1217.18732@wrigleys.postgresql.org обсуждение исходный текст |
Ответы |
Re: BUG #13671: pg_terminate_backend(pid) does not work
|
Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 13671 Logged by: alex Email address: oktogen@mail.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; | +-----+--------+---------------------------------------------------------+
В списке pgsql-bugs по дате отправления: