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)