[jira] [Created] (DRILL-5621) IllegalStateException: Memory was leaked by query. Memory leaked: (73728)

[N Campbell (JIRA)]

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)