You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Noa Horn (JIRA)" <ji...@apache.org> on 2016/02/02 00:18:39 UTC
[jira] [Updated] (HAWQ-381) Fatal error when canceling qeury
[ https://issues.apache.org/jira/browse/HAWQ-381?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Noa Horn updated HAWQ-381:
--------------------------
Description:
This issue was revealed by using SimEx on a debug build, with gp_simex_class set to 1 (cancel query).
The second time a query is run in simex mode, this error is seen:
{noformat}
FATAL: terminating connection due to administrator command
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
{noformat}
Repro:
Setup:
{noformat}
compile with configure parameter --enable-testutils
hawq config -c gp_simex_init -v on
hawq config -c gp_simex_class -v 1
hawq restart cluster
{noformat}
Run the attached inject script with the attached prepare_simple.sql and test_simple.sql files.
{noformat}
~/simex/inject.py ~/simex/prepare_simple.sql ~/simex/test_simple.sql &> ~/simex/simple_cancelquery.out
{noformat}
Also attached output of this run (there are a few cores as well)
was:
This issue was revealed by using SimEx on a debug build, with gp_simex_class set to 1 (cancel query).
The second time a query is run in simex mode, this error is seen:
{noformat}
FATAL: terminating connection due to administrator command
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
{noformat}
Repro:
Setup:
{noformat}
compile with configure parameter --enable-testutils
hawq config -c gp_simex_init -v on
hawq config -c gp_simex_class -v 1
hawq restart cluster
{noformat}
Run the attached inject script with the attached prepare_simple.sql and test_simple.sql files.
{noformat}
~/simex/inject.py ~/simex/prepare_simple.sql ~/simex/test_simple.sql &> ~/simex/simple_cancelquery.out
{noformat}
> Fatal error when canceling qeury
> --------------------------------
>
> Key: HAWQ-381
> URL: https://issues.apache.org/jira/browse/HAWQ-381
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Core
> Reporter: Noa Horn
> Assignee: Lei Chang
>
> This issue was revealed by using SimEx on a debug build, with gp_simex_class set to 1 (cancel query).
> The second time a query is run in simex mode, this error is seen:
> {noformat}
> FATAL: terminating connection due to administrator command
> server closed the connection unexpectedly
> This probably means the server terminated abnormally
> before or while processing the request.
> {noformat}
> Repro:
> Setup:
> {noformat}
> compile with configure parameter --enable-testutils
> hawq config -c gp_simex_init -v on
> hawq config -c gp_simex_class -v 1
> hawq restart cluster
> {noformat}
> Run the attached inject script with the attached prepare_simple.sql and test_simple.sql files.
> {noformat}
> ~/simex/inject.py ~/simex/prepare_simple.sql ~/simex/test_simple.sql &> ~/simex/simple_cancelquery.out
> {noformat}
> Also attached output of this run (there are a few cores as well)
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)