[DRILL-3691] CTAS Memory Leak : IllegalStateException

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 1.2.0
• Component/s: Storage - Parquet
• Assignee: Rahul Kumar Challapalli
• Reporter: Rahul Kumar Challapalli
• Created: 23/Aug/15 01:34
• Updated: 23/Sep/15 22:24
• Resolved: 23/Sep/15 22:24

Description

git.commit.id.abbrev=55dfd0e

The below CTAS statement fails with a memory leak. The query runs on top of Tpch SF100 data.

create table lineitem as select * from dfs.`/drill/testdata/tpch100/lineitem`;
java.sql.SQLException: SYSTEM ERROR: IllegalStateException: Failure while closing accountor.  Expected private and shared pools to be set to initial values.  However, one or more were not.  Stats are
        zone    init    allocated       delta 
        private 1000000 1000000 0 
        shared  9999000000      9998410176      589824.

Fragment 1:19

[Error Id: ba8fedf2-be40-4488-af2e-b6034527c943 on qa-node191.qa.lab:31010]
Aborting command set because "force" is false and command failed: "create table lineitem as select * from dfs.`/drill/testdata/tpch100/lineitem`;"

I attached the log file. I am not uploading the data as it is too large

Issue Links

• is related to: DRILL-3684 CTAS : Memory Leak when using CTAS with tpch sf100