Lin Wen created HAWQ-759:
----------------------------
Summary: Query cannot be terminated by pg_cancel_backend or
pg_terminate_backend
Key: HAWQ-759
URL: https://issues.apache.org/jira/browse/HAWQ-759
Project: Apache HAWQ
Issue Type: Bug
Reporter: Lin Wen
Assignee: Lei Chang
Query cannot be terminated by pg_cancel_backend or pg_terminate_backend.
Reproduce procedure
1. create a pipe
[gpadmin@mdw tmp]$ mkfifo /tmp/test.dat
2.create test table and run copy command.
gpadmin=# create table public.test(id int) distributed randomly;
CREATE TABLE
Time: 306.431 ms
gpadmin=# copy public.test to '/tmp/test.dat';
3. open a new psql session. try to terminate this session but fails.
Time: 2.327 ms
gpadmin=# select pg_cancel_backend(19210);
pg_cancel_backend
-------------------
t
(1 row)
Time: 0.452 ms
gpadmin=# select pg_terminate_backend(19210);
pg_terminate_backend
----------------------
t
(1 row)
Time: 0.368 ms
gpadmin=# select * from pg_stat_activity ;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
