[
https://issues.apache.org/jira/browse/HAWQ-759?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Lin Wen reassigned HAWQ-759:
----------------------------
Assignee: Lin Wen (was: Lei Chang)
> 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: Lin Wen
>
> 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)
