[ https://issues.apache.org/jira/browse/HAWQ-759?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15326972#comment-15326972 ]
ASF GitHub Bot commented on HAWQ-759: ------------------------------------- GitHub user linwen opened a pull request: https://github.com/apache/incubator-hawq/pull/706 HAWQ-759. Fix query cannot be terminated by pg_cancel_backend or pg_t… Please review, Thanks! You can merge this pull request into a Git repository by running: $ git pull https://github.com/linwen/incubator-hawq hawq-759 Alternatively you can review and apply these changes as the patch at: https://github.com/apache/incubator-hawq/pull/706.patch To close this pull request, make a commit to your master/trunk branch with (at least) the following in the commit message: This closes #706 ---- commit 8b6d9b9efed1aa7a8ca29748a650bd97a13b69d2 Author: Wen Lin <w...@pivotal.io> Date: 2016-06-13T08:07:51Z HAWQ-759. Fix query cannot be terminated by pg_cancel_backend or pg_terminate_backend ---- > 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)