You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@hawq.apache.org by "Xiang Sheng (JIRA)" <ji...@apache.org> on 2016/01/21 09:07:39 UTC
[jira] [Comment Edited] (HAWQ-37) Abort transaction didn't rollback
while 1 QE was terminated.
[ https://issues.apache.org/jira/browse/HAWQ-37?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15110253#comment-15110253 ]
Xiang Sheng edited comment on HAWQ-37 at 1/21/16 8:07 AM:
----------------------------------------------------------
I follow the steps to reproduce this problem and found the error out.
If I kill the process earlier, then get the error below:
ERROR: Query Executor Error in seg83 bcn-w4:5532 pid=523809: server closed the connection unexpectedly
DETAIL:
This probably means the server terminated abnormally
before or while processing the request.
Then "select count(\*) from orders_x;"
Found :
select count(\*) from orders_x ;
count
-------
0
(1 row)
If I kill the process just before the insert finished, I got this error :
WARNING: skipping "orders_x" --- error returned: Query Executor Error in seg80 bcn-w4:5532 pid=522448: server closed the connection unexpectedly
DETAIL:
This probably means the server terminated abnormally
before or while processing the request.
INFO: ANALYZE completed. Success: 0, Failure: 1 (orders_x)
INSERT 0 240000000
and select count(\*) from orders_x:
NOTICE: One or more columns in the following table(s) do not have statistics: orders_x
HINT: For non-partitioned tables, run analyze <table_name>(<column_list>). For partitioned tables, run analyze rootpartition <table_name>(<column_list>). See log for columns missing statistics.
count
-----------
240000000
(1 row).
was (Author: xsheng):
I follow the steps to reproduce this problem and found the error out.
If I kill the process earlier, then get the error below:
ERROR: Query Executor Error in seg83 bcn-w4:5532 pid=523809: server closed the connection unexpectedly
DETAIL:
This probably means the server terminated abnormally
before or while processing the request.
Then "select count(*) from orders_x;"
Found :
select count(*) from orders_x ;
count
-------
0
(1 row)
If I kill the process just before the insert finished, I got this error :
WARNING: skipping "orders_x" --- error returned: Query Executor Error in seg80 bcn-w4:5532 pid=522448: server closed the connection unexpectedly
DETAIL:
This probably means the server terminated abnormally
before or while processing the request.
INFO: ANALYZE completed. Success: 0, Failure: 1 (orders_x)
INSERT 0 240000000
and select count(*) from orders_x:
NOTICE: One or more columns in the following table(s) do not have statistics: orders_x
HINT: For non-partitioned tables, run analyze <table_name>(<column_list>). For partitioned tables, run analyze rootpartition <table_name>(<column_list>). See log for columns missing statistics.
count
-----------
240000000
(1 row).
> Abort transaction didn't rollback while 1 QE was terminated.
> ------------------------------------------------------------
>
> Key: HAWQ-37
> URL: https://issues.apache.org/jira/browse/HAWQ-37
> Project: Apache HAWQ
> Issue Type: Bug
> Components: Dispatcher
> Reporter: Xiang Sheng
> Assignee: Lirong Jian
> Priority: Critical
>
> Run workload tpch_parq10snp, 1 QE was terminated due to disk failure. And returned error "the relation already exists" while insert into the same relation.
> Steps to repeat the problem:
> 1, create table orders_x (like orders);
> 2, insert into orders_x select * from e_orders ;
> 3, kill 1 MPPEXEC process on segment to simulate the interrupted.
> 4, then "error returned: Query Executor Error in seg432 sfo-w163.ic:40000 pid=278795: server closed the connection unexpectedly "
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)