[ 
https://issues.apache.org/jira/browse/DRILL-2792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14494978#comment-14494978
 ] 

Ramana Inukonda Nagaraj commented on DRILL-2792:
------------------------------------------------

Same query allowed to run to completion results in expected behavior i.e. 
direct memory goes back to initial state:
{code}
1/6          select * from sys.memory;
+------------+------------+--------------+------------+----------------+------------+
|  hostname  | user_port  | heap_current |  heap_max  | direct_current | 
direct_max |
+------------+------------+--------------+------------+----------------+------------+
| atsqa6c62.qa.lab | 31010      | 259825600    | 4151836672 | 2000000        | 
34359738368 |
| atsqa6c60.qa.lab | 31010      | 187566320    | 4151836672 | 2000000        | 
34359738368 |
| atsqa6c59.qa.lab | 31010      | 228632408    | 4151836672 | 2000000        | 
34359738368 |
| atsqa6c58.qa.lab | 31010      | 218370456    | 4151836672 | 2000000        | 
34359738368 |
| atsqa6c64.qa.lab | 31010      | 268129240    | 4151836672 | 6048768        | 
34359738368 |
| atsqa6c57.qa.lab | 31010      | 313951424    | 4151836672 | 2000000        | 
34359738368 |
| atsqa6c61.qa.lab | 31010      | 314443744    | 4151836672 | 2000000        | 
34359738368 |
| atsqa6c63.qa.lab | 31010      | 328434688    | 4151836672 | 2000000        | 
34359738368 |
+------------+------------+--------------+------------+----------------+------------+
8 rows selected (2.197 seconds)

EXECUTE QUERY SUCCESSFULLY TO COMPLETION

5/6          select * from sys.memory;
+------------+------------+--------------+------------+----------------+------------+
|  hostname  | user_port  | heap_current |  heap_max  | direct_current | 
direct_max |
+------------+------------+--------------+------------+----------------+------------+
| atsqa6c64.qa.lab | 31010      | 798570448    | 4151836672 | 6048877        | 
34359738368 |
| atsqa6c60.qa.lab | 31010      | 636962176    | 4151836672 | 2000000        | 
34359738368 |
| atsqa6c58.qa.lab | 31010      | 609723504    | 4151836672 | 2000000        | 
34359738368 |
| atsqa6c63.qa.lab | 31010      | 771235968    | 4151836672 | 2000013        | 
34359738368 |
| atsqa6c61.qa.lab | 31010      | 600302376    | 4151836672 | 2000000        | 
34359738368 |
| atsqa6c62.qa.lab | 31010      | 781592336    | 4151836672 | 2000000        | 
34359738368 |
| atsqa6c59.qa.lab | 31010      | 767777568    | 4151836672 | 2000000        | 
34359738368 |
| atsqa6c57.qa.lab | 31010      | 692368464    | 4151836672 | 2000000        | 
34359738368 |
+------------+------------+--------------+------------+----------------+------------+
{code}


> Killing the drillbit which is the foreman results in direct memory being held 
> on
> --------------------------------------------------------------------------------
>
>                 Key: DRILL-2792
>                 URL: https://issues.apache.org/jira/browse/DRILL-2792
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Execution - Flow
>            Reporter: Ramana Inukonda Nagaraj
>            Assignee: Chris Westin
>
> Killed one of the drillbits which is the foreman for the query- 
> Profiles page reports that query has cancelled.
> Due to bug Drill-2778 sqlline hangs. However after killing sqlline the 
> current direct memory used does not go down to pre query levels.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

Reply via email to