Mailing-List: contact issues-help@drill.apache.org; run by ezmlm
Precedence: bulk
Reply-To: dev@drill.apache.org
Date: Thu, 29 Jun 2017 12:14:00 +0000 (UTC)
From: "N Campbell (JIRA)" <jira@apache.org>
To: issues@drill.apache.org
Message-ID: <JIRA.13083447.1498738423000.134202.1498738440246@Atlassian.JIRA>
In-Reply-To: <JIRA.13083447.1498738423000@Atlassian.JIRA>
References: <JIRA.13083447.1498738423000@Atlassian.JIRA> <JIRA.13083447.1498738423829@jira-lw-us.apache.org>
Subject: [jira] [Created] (DRILL-5621) IllegalStateException: Memory was
 leaked by query. Memory leaked: (73728)
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
archived-at: Thu, 29 Jun 2017 12:14:05 -0000

N Campbell created DRILL-5621:
---------------------------------

             Summary: IllegalStateException: Memory was leaked by query. Memory leaked: (73728)
                 Key: DRILL-5621
                 URL: https://issues.apache.org/jira/browse/DRILL-5621
             Project: Apache Drill
          Issue Type: Bug
          Components:  Server
    Affects Versions: 1.10.0
         Environment: Drill 1.10 
            Reporter: N Campbell


A JDBC plug in is defined to access ORACLE 12 via JDBC.

The following SQL statement is executed in Drill and throws the following error

SYSTEM ERROR: IllegalStateException: Memory was leaked by query. Memory leaked: (73728)
Allocator(op:0:0:3:JdbcSubScan) 1000000/73728/200704/10000000000 (res/actual/peak/limit)


select TJOIN1.RNUM, TJOIN1.C1, TJOIN2.C1 as C1J2, TJOIN2.C2 from certora.DBCERT.TJOIN1, LATERAL ( select TJOIN2.C1, TJOIN2.C2 from certora.DBCERT.TJOIN2 where TJOIN1.C1=TJOIN2.C1) TJOIN2


ORACLE DDL

  CREATE TABLE "DBCERT"."TJOIN1" 
   (	"RNUM" NUMBER(*,0), 
	"C1" NUMBER(*,0), 
	"C2" NUMBER(*,0)
   ) ;
  GRANT SELECT ON "DBCERT"."TJOIN1" TO PUBLIC;
--------------------------------------------------------
--  DDL for Table TJOIN2
--------------------------------------------------------

  CREATE TABLE "DBCERT"."TJOIN2" 
   (	"RNUM" NUMBER(*,0), 
	"C1" NUMBER(*,0), 
	"C2" CHAR(2 BYTE)
   ) ;
  GRANT SELECT ON "DBCERT"."TJOIN2" TO PUBLIC;
--------------------------------------------------------
--  DDL for Table TJOIN3
--------------------------------------------------------

  CREATE TABLE "DBCERT"."TJOIN3" 
   (	"RNUM" NUMBER(*,0), 
	"C1" NUMBER(*,0), 
	"C2" CHAR(2 BYTE)
   ) ;
  GRANT SELECT ON "DBCERT"."TJOIN3" TO PUBLIC;
--------------------------------------------------------
--  DDL for Table TJOIN4
--------------------------------------------------------

  CREATE TABLE "DBCERT"."TJOIN4" 
   (	"RNUM" NUMBER(*,0), 
	"C1" NUMBER(*,0), 
	"C2" CHAR(2 BYTE)
   ) ;
  GRANT SELECT ON "DBCERT"."TJOIN4" TO PUBLIC;


Insert into DBCERT.TJOIN1 (RNUM,C1,C2) values (0,10,15);
Insert into DBCERT.TJOIN1 (RNUM,C1,C2) values (1,20,25);
Insert into DBCERT.TJOIN1 (RNUM,C1,C2) values (2,null,50);

Insert into DBCERT.TJOIN2 (RNUM,C1,C2) values (0,10,'BB');
Insert into DBCERT.TJOIN2 (RNUM,C1,C2) values (1,15,'DD');
Insert into DBCERT.TJOIN2 (RNUM,C1,C2) values (2,null,'EE');
Insert into DBCERT.TJOIN2 (RNUM,C1,C2) values (3,10,'FF');

Insert into DBCERT.TJOIN3 (RNUM,C1,C2) values (0,10,'XX');
Insert into DBCERT.TJOIN3 (RNUM,C1,C2) values (1,15,'YY');

Insert into DBCERT.TJOIN4 (RNUM,C1,C2) values (0,20,'ZZ');


--
This message was sent by Atlassian JIRA
(v6.4.14#64029)