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)