[jira] [Created] (DRILL-5500) Query hung in CANCELLATION_REQUESTED state

[Rahul Challapalli (JIRA)]

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


git.commit.id.abbrev=1e0a14c

I cancelled the below query after ~17 minutes and the profiles indicated that 
the cancellation did not complete
{code}
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';
{code}

~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
(v6.3.15#6346)