You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "N Campbell (JIRA)" <ji...@apache.org> on 2017/06/29 12:14:00 UTC
[jira] [Created] (DRILL-5621) IllegalStateException: Memory was
leaked by query. Memory leaked: (73728)
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)