[
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)
