[jira] [Commented] (DRILL-5153) RESOURCE ERROR: Waited for 15000ms, but tasks for 'Get block maps' are not complete

[ https://issues.apache.org/jira/browse/DRILL-5153?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16167416#comment-16167416 ] Robert Hou commented on DRILL-5153: --- We do not have this table any more, so we cannot reproduce the

[jira] [Commented] (DRILL-5478) Spill file size parameter is not honored by the managed external sort

[ https://issues.apache.org/jira/browse/DRILL-5478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16167463#comment-16167463 ] Robert Hou commented on DRILL-5478: --- How is the config option set? I checked the sys.boot values:

[jira] [Assigned] (DRILL-5493) Managed External Sort + CTAS creates batches too large for sort

[ https://issues.apache.org/jira/browse/DRILL-5493?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou reassigned DRILL-5493: - Assignee: Paul Rogers > Managed External Sort + CTAS creates batches too large for sort >

[jira] [Updated] (DRILL-5786) External Sort encounters Exception in RPC communication during Sort

[ https://issues.apache.org/jira/browse/DRILL-5786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5786: -- Summary: External Sort encounters Exception in RPC communication during Sort (was: Query encounters

[jira] [Updated] (DRILL-5805) External Sort runs out of memory

[ https://issues.apache.org/jira/browse/DRILL-5805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5805: -- Attachment: 2645d135-4222-d752-2609-c95568ff6e93.sys.drill > External Sort runs out of memory >

[jira] [Created] (DRILL-5804) Query times out, may be infinite loop

Robert Hou created DRILL-5804: - Summary: Query times out, may be infinite loop Key: DRILL-5804 URL: https://issues.apache.org/jira/browse/DRILL-5804 Project: Apache Drill Issue Type: Bug

[jira] [Updated] (DRILL-5804) External Sort times out, may be infinite loop

[ https://issues.apache.org/jira/browse/DRILL-5804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5804: -- Description: Query is: {noformat} ALTER SESSION SET `exec.sort.disable_managed` = false; select

[jira] [Created] (DRILL-5805) External Sort runs out of memory

Robert Hou created DRILL-5805: - Summary: External Sort runs out of memory Key: DRILL-5805 URL: https://issues.apache.org/jira/browse/DRILL-5805 Project: Apache Drill Issue Type: Bug

[jira] [Commented] (DRILL-5804) External Sort times out, may be infinite loop

[ https://issues.apache.org/jira/browse/DRILL-5804?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16172274#comment-16172274 ] Robert Hou commented on DRILL-5804: --- The profile is missing. I suspect it was not created. > External

[jira] [Updated] (DRILL-5804) External Sort times out, may be infinite loop

[ https://issues.apache.org/jira/browse/DRILL-5804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5804: -- Attachment: drillbit.log > External Sort times out, may be infinite loop >

[jira] [Commented] (DRILL-5786) A query that includes sort encounters Exception in RPC communication

[ https://issues.apache.org/jira/browse/DRILL-5786?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16172375#comment-16172375 ] Robert Hou commented on DRILL-5786: --- Updated title. > A query that includes sort encounters Exception

[jira] [Updated] (DRILL-5804) External Sort times out, may be infinite loop

[ https://issues.apache.org/jira/browse/DRILL-5804?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5804: -- Summary: External Sort times out, may be infinite loop (was: Query times out, may be infinite loop) >

[jira] [Updated] (DRILL-5786) A query that includes sort encounters Exception in RPC communication

[ https://issues.apache.org/jira/browse/DRILL-5786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5786: -- Summary: A query that includes sort encounters Exception in RPC communication (was: External Sort

[jira] [Updated] (DRILL-5805) External Sort runs out of memory

[ https://issues.apache.org/jira/browse/DRILL-5805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5805: -- Attachment: drillbit.log.gz > External Sort runs out of memory > > >

[jira] [Commented] (DRILL-5478) Spill file size parameter is not honored by the managed external sort

[ https://issues.apache.org/jira/browse/DRILL-5478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16172380#comment-16172380 ] Robert Hou commented on DRILL-5478: --- If this is exposed to Support, then it would be good to have some

[jira] [Created] (DRILL-5813) A query that includes sort encounters Exception occurred with closed channel

Robert Hou created DRILL-5813: - Summary: A query that includes sort encounters Exception occurred with closed channel Key: DRILL-5813 URL: https://issues.apache.org/jira/browse/DRILL-5813 Project: Apache

[jira] [Updated] (DRILL-5805) External Sort runs out of memory

[ https://issues.apache.org/jira/browse/DRILL-5805?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5805: -- Description: Query is: {noformat} ALTER SESSION SET `exec.sort.disable_managed` = false; alter session

[jira] [Updated] (DRILL-5813) A query that includes sort loses Drill connection. Drill sometimes crashes.

[ https://issues.apache.org/jira/browse/DRILL-5813?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5813: -- Attachment: drillbit.log > A query that includes sort loses Drill connection. Drill sometimes crashes.

[jira] [Commented] (DRILL-5813) A query that includes sort loses Drill connection. Drill sometimes crashes.

[ https://issues.apache.org/jira/browse/DRILL-5813?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16177685#comment-16177685 ] Robert Hou commented on DRILL-5813: --- I cannot find the profile for this query. I suspect it was not

[jira] [Updated] (DRILL-5813) A query that includes sort loses Drill connection. Drill sometimes crashes.

[ https://issues.apache.org/jira/browse/DRILL-5813?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5813: -- Description: Query is: {noformat} ALTER SESSION SET `exec.sort.disable_managed` = false; alter session

[jira] [Updated] (DRILL-5813) A query that includes sort loses Drill connection. Drill sometimes crashes.

[ https://issues.apache.org/jira/browse/DRILL-5813?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5813: -- Summary: A query that includes sort loses Drill connection. Drill sometimes crashes. (was: A query

[jira] [Commented] (DRILL-5478) Spill file size parameter is not honored by the managed external sort

[ https://issues.apache.org/jira/browse/DRILL-5478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16168488#comment-16168488 ] Robert Hou commented on DRILL-5478: --- I think the default memory setting is 10GB. The spill file size is

[jira] [Closed] (DRILL-5813) A query that includes sort loses Drill connection. Drill sometimes crashes.

[ https://issues.apache.org/jira/browse/DRILL-5813?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-5813. - I have verified this. > A query that includes sort loses Drill connection. Drill sometimes crashes. >

[jira] [Resolved] (DRILL-5840) A query that includes sort completes, and then loses Drill connection. Drill becomes unresponsive, and cannot restart because it cannot communicate with Zookeeper

[ https://issues.apache.org/jira/browse/DRILL-5840?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou resolved DRILL-5840. --- Resolution: Not A Problem > A query that includes sort completes, and then loses Drill connection.

[jira] [Commented] (DRILL-5840) A query that includes sort completes, and then loses Drill connection. Drill becomes unresponsive, and cannot restart because it cannot communicate with Zookeeper

[ https://issues.apache.org/jira/browse/DRILL-5840?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16197476#comment-16197476 ] Robert Hou commented on DRILL-5840: --- The cluster ran out of disk space and caused problems for

[jira] [Commented] (DRILL-5840) A query that includes sort completes, and then loses Drill connection. Drill becomes unresponsive, and cannot restart because it cannot communicate with Zookeeper

[ https://issues.apache.org/jira/browse/DRILL-5840?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16197477#comment-16197477 ] Robert Hou commented on DRILL-5840: --- Closing this as not a bug. > A query that includes sort completes,

[jira] [Commented] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16154349#comment-16154349 ] Robert Hou commented on DRILL-5670: --- Here is the plan. There is a StreamAgg. Can that affect things?

[jira] [Commented] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16154837#comment-16154837 ] Robert Hou commented on DRILL-5670: --- Sorry, found the "other" log. Here are the error messages and

[jira] [Updated] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5670: -- Attachment: drillbit.log > Varchar vector throws an assertion error when allocating a new vector >

[jira] [Created] (DRILL-5778) Drill seems to run out of memory but completes execution

Robert Hou created DRILL-5778: - Summary: Drill seems to run out of memory but completes execution Key: DRILL-5778 URL: https://issues.apache.org/jira/browse/DRILL-5778 Project: Apache Drill

[jira] [Updated] (DRILL-5778) Drill seems to run out of memory but completes execution

[ https://issues.apache.org/jira/browse/DRILL-5778?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5778: -- Attachment: 264d780f-41ac-2c4f-6bc8-bdbb5eeb3df0.sys.drill drillbit.log > Drill seems

[jira] [Reopened] (DRILL-5443) Managed External Sort fails with OOM while spilling to disk

[ https://issues.apache.org/jira/browse/DRILL-5443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou reopened DRILL-5443: --- > Managed External Sort fails with OOM while spilling to disk >

[jira] [Commented] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16147966#comment-16147966 ] Robert Hou commented on DRILL-5670: --- Here is the stack trace: {noformat} 2017-08-23 06:46:00,154

[jira] [Updated] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5670: -- Attachment: (was: drillbit.log) > Varchar vector throws an assertion error when allocating a new

[jira] [Updated] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5670: -- Attachment: (was: 266290f3-5fdc-5873-7372-e9ee053bf867.sys.drill) > Varchar vector throws an

[jira] [Closed] (DRILL-5234) External sort's spilling functionality does not work when the spilled columns contains a map type column

[ https://issues.apache.org/jira/browse/DRILL-5234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-5234. - This bug has been fixed and verified. > External sort's spilling functionality does not work when the

[jira] [Assigned] (DRILL-5234) External sort's spilling functionality does not work when the spilled columns contains a map type column

[ https://issues.apache.org/jira/browse/DRILL-5234?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou reassigned DRILL-5234: - Assignee: Robert Hou (was: Paul Rogers) > External sort's spilling functionality does not work

[jira] [Updated] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5670: -- Attachment: 266290f3-5fdc-5873-7372-e9ee053bf867.sys.drill drillbit.log > Varchar

[jira] [Commented] (DRILL-5754) Test framework does not enforce column orders

[ https://issues.apache.org/jira/browse/DRILL-5754?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16148305#comment-16148305 ] Robert Hou commented on DRILL-5754: --- The Drill QA test framework enforces column order. So an interim

[jira] [Assigned] (DRILL-5617) Spill file name collisions when spill file is on a shared file system

[ https://issues.apache.org/jira/browse/DRILL-5617?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou reassigned DRILL-5617: - Assignee: Chun Chang (was: Paul Rogers) > Spill file name collisions when spill file is on a

[jira] [Commented] (DRILL-5753) Managed External Sort: One or more nodes ran out of memory while executing the query.

[ https://issues.apache.org/jira/browse/DRILL-5753?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16148064#comment-16148064 ] Robert Hou commented on DRILL-5753: --- It is starting the consolidation phase. 2017-08-30 03:35:10,223

[jira] [Created] (DRILL-5753) Managed External Sort: One or more nodes ran out of memory while executing the query.

Robert Hou created DRILL-5753: - Summary: Managed External Sort: One or more nodes ran out of memory while executing the query. Key: DRILL-5753 URL: https://issues.apache.org/jira/browse/DRILL-5753

[jira] [Commented] (DRILL-5753) Managed External Sort: One or more nodes ran out of memory while executing the query.

[ https://issues.apache.org/jira/browse/DRILL-5753?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16148063#comment-16148063 ] Robert Hou commented on DRILL-5753: --- Note that multiple fragments are executing. > Managed External

[jira] [Commented] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16154347#comment-16154347 ] Robert Hou commented on DRILL-5670: --- Attached log and profile. > Varchar vector throws an assertion

[jira] [Updated] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5670: -- Attachment: drillbit.log 26555749-4d36-10d2-6faf-e403db40c370.sys.drill > Varchar

[jira] [Commented] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16154344#comment-16154344 ] Robert Hou commented on DRILL-5670: --- I still see a memory allocation problem, and I do not see warnings

[jira] [Commented] (DRILL-5447) Managed External Sort : Unable to allocate sv2 vector

[ https://issues.apache.org/jira/browse/DRILL-5447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16157560#comment-16157560 ] Robert Hou commented on DRILL-5447: --- I re-ran this case with the fix for DRILL-5443. I am getting the

[jira] [Commented] (DRILL-5447) Managed External Sort : Unable to allocate sv2 vector

[ https://issues.apache.org/jira/browse/DRILL-5447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16157563#comment-16157563 ] Robert Hou commented on DRILL-5447: --- Here is the plan: {noformat} | 00-00Screen 00-01

[jira] [Updated] (DRILL-5447) Managed External Sort : Unable to allocate sv2 vector

[ https://issues.apache.org/jira/browse/DRILL-5447?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5447: -- Attachment: 26550427-6adf-a52e-2ea8-dc52d8d8433f.sys.drill drillbit.log > Managed

[jira] [Commented] (DRILL-5774) Excessive memory allocation

[ https://issues.apache.org/jira/browse/DRILL-5774?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16157746#comment-16157746 ] Robert Hou commented on DRILL-5774: --- Here is the plan: {noformat} | 00-00Screen 00-01

[jira] [Updated] (DRILL-5786) Query encounters Exception in RPC communication during Sort

[ https://issues.apache.org/jira/browse/DRILL-5786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5786: -- Summary: Query encounters Exception in RPC communication during Sort (was: Query encounters Exception

[jira] [Commented] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16164244#comment-16164244 ] Robert Hou commented on DRILL-5670: --- attached drillbit.log.exchange and profile > Varchar vector throws

[jira] [Updated] (DRILL-5786) Query encounters Exception in RPC communication

[ https://issues.apache.org/jira/browse/DRILL-5786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5786: -- Attachment: 2647d2b0-69bf-5a2b-0e23-81e8d49e464e.sys.drill drillbit.log > Query

[jira] [Commented] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16164240#comment-16164240 ] Robert Hou commented on DRILL-5670: --- I tried with disabling exchanges, and got a different error. It

[jira] [Updated] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5670: -- Attachment: drillbit.log.exchange 26478262-f0a7-8fc1-1887-4f27071b9c0f.sys.drill >

[jira] [Commented] (DRILL-5785) Query Error on a large PCAP file

[ https://issues.apache.org/jira/browse/DRILL-5785?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16164029#comment-16164029 ] Robert Hou commented on DRILL-5785: --- Can you attach a sample of your PCAP file? Can you attach the

[jira] [Updated] (DRILL-5786) Query encounters Exception in RPC communication

[ https://issues.apache.org/jira/browse/DRILL-5786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5786: -- Description: Query is: {noformat} select count(*) from (select * from

[jira] [Comment Edited] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16164240#comment-16164240 ] Robert Hou edited comment on DRILL-5670 at 9/13/17 7:21 AM: I tried with

[jira] [Created] (DRILL-5786) Query enters Exception in RPC communication

Robert Hou created DRILL-5786: - Summary: Query enters Exception in RPC communication Key: DRILL-5786 URL: https://issues.apache.org/jira/browse/DRILL-5786 Project: Apache Drill Issue Type: Bug

[jira] [Updated] (DRILL-5786) Query encounters Exception in RPC communication

[ https://issues.apache.org/jira/browse/DRILL-5786?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5786: -- Summary: Query encounters Exception in RPC communication (was: Query enters Exception in RPC

[jira] [Resolved] (DRILL-5744) External sort fails with OOM error

[ https://issues.apache.org/jira/browse/DRILL-5744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou resolved DRILL-5744. --- Resolution: Fixed This has been verified. > External sort fails with OOM error >

[jira] [Closed] (DRILL-5744) External sort fails with OOM error

[ https://issues.apache.org/jira/browse/DRILL-5744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-5744. - > External sort fails with OOM error > -- > > Key: DRILL-5744

[jira] [Resolved] (DRILL-5753) Managed External Sort: One or more nodes ran out of memory while executing the query.

[ https://issues.apache.org/jira/browse/DRILL-5753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou resolved DRILL-5753. --- Resolution: Fixed > Managed External Sort: One or more nodes ran out of memory while executing > the

[jira] [Closed] (DRILL-5753) Managed External Sort: One or more nodes ran out of memory while executing the query.

[ https://issues.apache.org/jira/browse/DRILL-5753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-5753. - I have verified that this has been fixed. > Managed External Sort: One or more nodes ran out of memory while

[jira] [Commented] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16162228#comment-16162228 ] Robert Hou commented on DRILL-5670: --- I am getting a different error now: {noformat} 2017-09-11

[jira] [Updated] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5670: -- Attachment: drillbit.log 26498995-bbad-83bc-618f-914c37a84e1f.sys.drill > Varchar

[jira] [Commented] (DRILL-5732) Unable to allocate sv2 for 9039 records, and not enough batchGroups to spill.

[ https://issues.apache.org/jira/browse/DRILL-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16140973#comment-16140973 ] Robert Hou commented on DRILL-5732: --- Yes, there is a Hash Agg step. The plan is: {noformat} | 00-00

[jira] [Commented] (DRILL-5732) Unable to allocate sv2 for 9039 records, and not enough batchGroups to spill.

[ https://issues.apache.org/jira/browse/DRILL-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16142219#comment-16142219 ] Robert Hou commented on DRILL-5732: --- The new memory setting should be: new setting = (old setting / x)

[jira] [Commented] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16144160#comment-16144160 ] Robert Hou commented on DRILL-5670: --- This bug has been fixed. > Varchar vector throws an assertion

[jira] [Closed] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-5670. - This bug has been fixed and verified. > Varchar vector throws an assertion error when allocating a new

[jira] [Updated] (DRILL-5744) External sort fails with OOM error

[ https://issues.apache.org/jira/browse/DRILL-5744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5744: -- Attachment: 266275e5-ebdb-14ae-d52d-00fa3a154f6d.sys.drill drillbit.log > External sort

[jira] [Updated] (DRILL-5447) Managed External Sort : Unable to allocate sv2 vector

[ https://issues.apache.org/jira/browse/DRILL-5447?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5447: -- Attachment: 26617a7e-b953-7ac3-556d-43fd88e51b19.sys.drill drillbit.log > Managed

[jira] [Commented] (DRILL-5447) Managed External Sort : Unable to allocate sv2 vector

[ https://issues.apache.org/jira/browse/DRILL-5447?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16144229#comment-16144229 ] Robert Hou commented on DRILL-5447: --- The memory is not being constricted for this test. E.g.

[jira] [Created] (DRILL-5744) External sort fails with OOM error

Robert Hou created DRILL-5744: - Summary: External sort fails with OOM error Key: DRILL-5744 URL: https://issues.apache.org/jira/browse/DRILL-5744 Project: Apache Drill Issue Type: Bug

[jira] [Reopened] (DRILL-5447) Managed External Sort : Unable to allocate sv2 vector

[ https://issues.apache.org/jira/browse/DRILL-5447?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou reopened DRILL-5447: --- This is not passing on Jenkins. Here is the query: {noformat} ALTER SESSION SET

[jira] [Updated] (DRILL-5744) External sort fails with OOM error

[ https://issues.apache.org/jira/browse/DRILL-5744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5744: -- Description: Query is: {noformat} ALTER SESSION SET `exec.sort.disable_managed` = false; alter session

[jira] [Commented] (DRILL-5732) Unable to allocate sv2 for 9039 records, and not enough batchGroups to spill.

[ https://issues.apache.org/jira/browse/DRILL-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16139618#comment-16139618 ] Robert Hou commented on DRILL-5732: --- Sorry, I'm not sure why it is using the original version. Let's

[jira] [Updated] (DRILL-5732) Unable to allocate sv2 for 9039 records, and not enough batchGroups to spill.

[ https://issues.apache.org/jira/browse/DRILL-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5732: -- Attachment: (was: 2668b522-5833-8fd2-0b6d-e685197f0ae3.sys.drill) > Unable to allocate sv2 for 9039

[jira] [Updated] (DRILL-5732) Unable to allocate sv2 for 9039 records, and not enough batchGroups to spill.

[ https://issues.apache.org/jira/browse/DRILL-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5732: -- Attachment: (was: drillbit.log) > Unable to allocate sv2 for 9039 records, and not enough

[jira] [Updated] (DRILL-5732) Unable to allocate sv2 for 9039 records, and not enough batchGroups to spill.

[ https://issues.apache.org/jira/browse/DRILL-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5732: -- Attachment: 26621eb2-daec-cef9-efed-5986e72a750a.sys.drill drillbit.log.83 > Unable to

[jira] [Commented] (DRILL-5732) Unable to allocate sv2 for 9039 records, and not enough batchGroups to spill.

[ https://issues.apache.org/jira/browse/DRILL-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16139636#comment-16139636 ] Robert Hou commented on DRILL-5732: --- I am using the same commit ID as above: | 1.12.0-SNAPSHOT |

[jira] [Updated] (DRILL-5744) External sort fails with OOM error

[ https://issues.apache.org/jira/browse/DRILL-5744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5744: -- Attachment: (was: drillbit.log) > External sort fails with OOM error >

[jira] [Updated] (DRILL-5744) External sort fails with OOM error

[ https://issues.apache.org/jira/browse/DRILL-5744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5744: -- Description: Query is: {noformat} ALTER SESSION SET `exec.sort.disable_managed` = false; alter session

[jira] [Updated] (DRILL-5744) External sort fails with OOM error

[ https://issues.apache.org/jira/browse/DRILL-5744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5744: -- Attachment: (was: 266275e5-ebdb-14ae-d52d-00fa3a154f6d.sys.drill) > External sort fails with OOM

[jira] [Updated] (DRILL-5744) External sort fails with OOM error

[ https://issues.apache.org/jira/browse/DRILL-5744?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5744: -- Attachment: 265b163b-cf44-d2ff-2e70-4cd746b56611.sys.drill q34.drillbit.log > External

[jira] [Commented] (DRILL-5723) Support System/Session Internal Options

[ https://issues.apache.org/jira/browse/DRILL-5723?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16151254#comment-16151254 ] Robert Hou commented on DRILL-5723: --- We should be careful about making some options as system-only

[jira] [Commented] (DRILL-5443) Managed External Sort fails with OOM while spilling to disk

[ https://issues.apache.org/jira/browse/DRILL-5443?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16146377#comment-16146377 ] Robert Hou commented on DRILL-5443: --- The stack trace is: {noformat} 2017-08-29 16:55:26,610

[jira] [Commented] (DRILL-5732) Unable to allocate sv2 for 9039 records, and not enough batchGroups to spill.

[ https://issues.apache.org/jira/browse/DRILL-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16146479#comment-16146479 ] Robert Hou commented on DRILL-5732: --- This query now completes. > Unable to allocate sv2 for 9039

[jira] [Updated] (DRILL-5443) Managed External Sort fails with OOM while spilling to disk

[ https://issues.apache.org/jira/browse/DRILL-5443?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5443: -- Attachment: drill5443.drillbit.log 265a014b-8cae-30b5-adab-ff030b6c7086.sys.drill >

[jira] [Resolved] (DRILL-5732) Unable to allocate sv2 for 9039 records, and not enough batchGroups to spill.

[ https://issues.apache.org/jira/browse/DRILL-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou resolved DRILL-5732. --- Resolution: Not A Problem > Unable to allocate sv2 for 9039 records, and not enough batchGroups to

[jira] [Closed] (DRILL-5732) Unable to allocate sv2 for 9039 records, and not enough batchGroups to spill.

[ https://issues.apache.org/jira/browse/DRILL-5732?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou closed DRILL-5732. - I have verified that this query completes. > Unable to allocate sv2 for 9039 records, and not enough

[jira] [Updated] (DRILL-5753) Managed External Sort: One or more nodes ran out of memory while executing the query.

[ https://issues.apache.org/jira/browse/DRILL-5753?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5753: -- Attachment: 26596b4e-9883-7dc2-6275-37134f7d63be.sys.drill drillbit.log > Managed

[jira] [Commented] (DRILL-5753) Managed External Sort: One or more nodes ran out of memory while executing the query.

[ https://issues.apache.org/jira/browse/DRILL-5753?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16149641#comment-16149641 ] Robert Hou commented on DRILL-5753: --- Sorry, got interrupted mid-stream yesterday, and forgot to finish

[jira] [Comment Edited] (DRILL-5753) Managed External Sort: One or more nodes ran out of memory while executing the query.

[ https://issues.apache.org/jira/browse/DRILL-5753?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16149641#comment-16149641 ] Robert Hou edited comment on DRILL-5753 at 8/31/17 9:34 PM: Sorry, got

[jira] [Commented] (DRILL-5670) Varchar vector throws an assertion error when allocating a new vector

[ https://issues.apache.org/jira/browse/DRILL-5670?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16149648#comment-16149648 ] Robert Hou commented on DRILL-5670: --- Attached log file and profile. > Varchar vector throws an

[jira] [Created] (DRILL-5840) A query that includes sort completes, and then loses Drill connection. Drill becomes unresponsive, and cannot restart because it cannot communicate with Zookeeper

Robert Hou created DRILL-5840: - Summary: A query that includes sort completes, and then loses Drill connection. Drill becomes unresponsive, and cannot restart because it cannot communicate with Zookeeper Key: DRILL-5840

[jira] [Updated] (DRILL-5840) A query that includes sort completes, and then loses Drill connection. Drill becomes unresponsive, and cannot restart because it cannot communicate with Zookeeper

[ https://issues.apache.org/jira/browse/DRILL-5840?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5840: -- Description: Query is: {noformat} ALTER SESSION SET `exec.sort.disable_managed` = false; select

[jira] [Updated] (DRILL-5840) A query that includes sort completes, and then loses Drill connection. Drill becomes unresponsive, and cannot restart because it cannot communicate with Zookeeper

[ https://issues.apache.org/jira/browse/DRILL-5840?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-5840: -- Description: Query is: {noformat} ALTER SESSION SET `exec.sort.disable_managed` = false; select

[jira] [Commented] (DRILL-5889) sqlline loses RPC connection

[ https://issues.apache.org/jira/browse/DRILL-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16210318#comment-16210318 ] Robert Hou commented on DRILL-5889: --- I allocated 10GB to Drill. > sqlline loses RPC connection >

[jira] [Commented] (DRILL-5889) sqlline loses RPC connection

[ https://issues.apache.org/jira/browse/DRILL-5889?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel=16210315#comment-16210315 ] Robert Hou commented on DRILL-5889: --- It may take time to display all the contents in your web browser.

<    1   2   3   4   5   >