drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rahul Challapalli (JIRA)" <j...@apache.org>
Subject [jira] [Created] (DRILL-5500) Query hung in CANCELLATION_REQUESTED state
Date Wed, 10 May 2017 20:35:04 GMT
Rahul Challapalli created DRILL-5500:

             Summary: Query hung in CANCELLATION_REQUESTED state
                 Key: DRILL-5500
                 URL: https://issues.apache.org/jira/browse/DRILL-5500
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Flow
    Affects Versions: 1.10.0
            Reporter: Rahul Challapalli


I cancelled the below query after ~17 minutes and the profiles indicated that the cancellation
did not complete
alter session set `planner.enable_decimal_data_type` = true;
alter session set `planner.slice_target` = 300;
ALTER SESSION SET `exec.sort.disable_managed` = false;
alter session set `planner.width.max_per_node` = 17;
alter session set `planner.width.max_per_query` = 17;
alter session set `planner.memory.max_query_memory_per_node` = 11926000000;
select count(*) from (select * from dfs.`/drill/testdata/resource-manager/5kwidecolumns_500k.tbl`
order by columns[0]) d where d.columns[0] = '4041054511';

~1 minute after the cancellation has been issued, I took the jstack output and it indicated
that some fragments are running. The sort operator in the query did not yet start any spilling
by the time I issued the cancel request.

I attached the query profile, log files and the jstack output

This message was sent by Atlassian JIRA

View raw message