[ https://issues.apache.org/jira/browse/HAWQ-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15327176#comment-15327176 ]
ASF GitHub Bot commented on HAWQ-759: ------------------------------------- Github user jiny2 commented on the issue: https://github.com/apache/incubator-hawq/pull/706 +1 > 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)