[
https://issues.apache.org/jira/browse/DRILL-2792?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14494980#comment-14494980
]
Ramana Inukonda Nagaraj edited comment on DRILL-2792 at 4/14/15 9:53 PM:
-------------------------------------------------------------------------
In the case where foreman is killed direct memory use looks like this:
Before cancellation:
{code}
1/6 select * from sys.memory;
+------------+------------+--------------+------------+----------------+------------+
| hostname | user_port | heap_current | heap_max | direct_current |
direct_max |
+------------+------------+--------------+------------+----------------+------------+
| atsqa6c64.qa.lab | 31010 | 184728000 | 4151836672 | 2000000 |
34359738368 |
| atsqa6c58.qa.lab | 31010 | 179768952 | 4151836672 | 2000000 |
34359738368 |
| atsqa6c62.qa.lab | 31010 | 228472528 | 4151836672 | 2000000 |
34359738368 |
| atsqa6c63.qa.lab | 31010 | 325782456 | 4151836672 | 2000000 |
34359738368 |
| atsqa6c61.qa.lab | 31010 | 133183360 | 4151836672 | 6048768 |
34359738368 |
| atsqa6c57.qa.lab | 31010 | 323590544 | 4151836672 | 2000000 |
34359738368 |
| atsqa6c60.qa.lab | 31010 | 179155280 | 4151836672 | 2000000 |
34359738368 |
| atsqa6c59.qa.lab | 31010 | 187145648 | 4151836672 | 2000000 |
34359738368 |
+------------+------------+--------------+------------+----------------+------------+
8 rows selected (2.327 seconds)
{code}
After cancellation:
{code}
0: jdbc:drill:> select * from sys.memory;
+------------+------------+--------------+------------+----------------+------------+
| hostname | user_port | heap_current | heap_max | direct_current |
direct_max |
+------------+------------+--------------+------------+----------------+------------+
| atsqa6c63.qa.lab | 31010 | 514486248 | 4151836672 | 1839362458 |
34359738368 |
| atsqa6c57.qa.lab | 31010 | 382623688 | 4151836672 | 1849218886 |
34359738368 |
| atsqa6c60.qa.lab | 31010 | 381417200 | 4151836672 | 1850727912 |
34359738368 |
| atsqa6c64.qa.lab | 31010 | 488955320 | 4151836672 | 1855641859 |
34359738368 |
| atsqa6c59.qa.lab | 31010 | 426557624 | 4151836672 | 1822002015 |
34359738368 |
| atsqa6c62.qa.lab | 31010 | 532419120 | 4151836672 | 1876725045 |
34359738368 |
| atsqa6c58.qa.lab | 31010 | 333926896 | 4151836672 | 1848092666 |
34359738368 |
+------------+------------+--------------+------------+----------------+------------+
7 rows selected (0.151 seconds)
{code}
was (Author: inramana):
In the case where foreman is killed direct memory use looks like this:
Before cancellation:
{code}
1/6 select * from sys.memory;
+------------+------------+--------------+------------+----------------+------------+
| hostname | user_port | heap_current | heap_max | direct_current |
direct_max |
+------------+------------+--------------+------------+----------------+------------+
| atsqa6c64.qa.lab | 31010 | 184728000 | 4151836672 | 2000000 |
34359738368 |
| atsqa6c58.qa.lab | 31010 | 179768952 | 4151836672 | 2000000 |
34359738368 |
| atsqa6c62.qa.lab | 31010 | 228472528 | 4151836672 | 2000000 |
34359738368 |
| atsqa6c63.qa.lab | 31010 | 325782456 | 4151836672 | 2000000 |
34359738368 |
| atsqa6c61.qa.lab | 31010 | 133183360 | 4151836672 | 6048768 |
34359738368 |
| atsqa6c57.qa.lab | 31010 | 323590544 | 4151836672 | 2000000 |
34359738368 |
| atsqa6c60.qa.lab | 31010 | 179155280 | 4151836672 | 2000000 |
34359738368 |
| atsqa6c59.qa.lab | 31010 | 187145648 | 4151836672 | 2000000 |
34359738368 |
+------------+------------+--------------+------------+----------------+------------+
8 rows selected (2.327 seconds)
{code}
After cancellation:
0: jdbc:drill:> select * from sys.memory;
+------------+------------+--------------+------------+----------------+------------+
| hostname | user_port | heap_current | heap_max | direct_current |
direct_max |
+------------+------------+--------------+------------+----------------+------------+
| atsqa6c63.qa.lab | 31010 | 514486248 | 4151836672 | 1839362458 |
34359738368 |
| atsqa6c57.qa.lab | 31010 | 382623688 | 4151836672 | 1849218886 |
34359738368 |
| atsqa6c60.qa.lab | 31010 | 381417200 | 4151836672 | 1850727912 |
34359738368 |
| atsqa6c64.qa.lab | 31010 | 488955320 | 4151836672 | 1855641859 |
34359738368 |
| atsqa6c59.qa.lab | 31010 | 426557624 | 4151836672 | 1822002015 |
34359738368 |
| atsqa6c62.qa.lab | 31010 | 532419120 | 4151836672 | 1876725045 |
34359738368 |
| atsqa6c58.qa.lab | 31010 | 333926896 | 4151836672 | 1848092666 |
34359738368 |
+------------+------------+--------------+------------+----------------+------------+
7 rows selected (0.151 seconds)
> 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)
