You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Rahul Challapalli (JIRA)" <ji...@apache.org> on 2017/05/10 23:33:04 UTC

[jira] [Created] (DRILL-5503) Disabling exchanges results in "Unable to allocate sv2 buffer" error within the managed external sort code

Rahul Challapalli created DRILL-5503:
----------------------------------------

             Summary: Disabling exchanges results in "Unable to allocate sv2 buffer" error within the managed external sort code
                 Key: DRILL-5503
                 URL: https://issues.apache.org/jira/browse/DRILL-5503
             Project: Apache Drill
          Issue Type: Bug
          Components: Execution - Flow
    Affects Versions: 1.10.0
            Reporter: Rahul Challapalli
            Assignee: Paul Rogers


Setup :
{code}
git.commit.id.abbrev=1e0a14c
No of drillbits : 1
DRILL_MAX_DIRECT_MEMORY="32G"
DRILL_MAX_HEAP="4G"
{code}

The below successfully completes
{code}
ALTER SESSION SET `exec.sort.disable_managed` = false;
alter session set `planner.width.max_per_node` = 1;
alter session set `planner.memory.max_query_memory_per_node` = 62600000;
alter session set `planner.width.max_per_query` = 17;
select count(*) from (select * from dfs.`/drill/testdata/resource-manager/5kwidecolumns_500k.tbl` order by columns[0]) d where d.columns[0] = '4041054511';
+---------+
| EXPR$0  |
+---------+
| 0       |
+---------+
1 row selected (814.104 seconds)
{code}

However if I disable exchanges, I get the following error
{code}
alter session set `planner.disable_exchanges` = false;
select count(*) from (select * from dfs.`/drill/testdata/resource-manager/5kwidecolumns_500k.tbl` order by columns[0]) d where d.columns[0] = '4041054511';
+---------+
| EXPR$0  |
+---------+
| 0       |
+---------+
1 row selected (814.104 seconds)
{code}

I attached the profile and the log file. The data set used is too large to attach here. 



--
This message was sent by Atlassian JIRA
(v6.3.15#6346)