CODEWITHSUNDEEP
apache-drill
Smruti Ranjan
Smruti Ranjan

Reputation: 99

Not able to join postgres table through apache drill

Not able to join multiple tables of postgres database through apache drill. When trying the same below error is coming.

org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: IllegalStateException: Memory was leaked by query. Memory leaked: (40960) Allocator(op:0:0:6:JdbcSubScan) 1000000/40960/2228224/10000000000 (res/actual/peak/limit) Fragment 0:0 [Error Id: b05fe30e-cc3a-4e7f-b81e-46ecfd1a9466 on INBBRDSSVM300.india.tcs.com:31010] (java.lang.IllegalStateException) Memory was leaked by query. Memory leaked: (40960) Allocator(op:0:0:6:JdbcSubScan) 1000000/40960/2228224/10000000000 (res/actual/peak/limit) org.apache.drill.exec.memory.BaseAllocator.close():492 org.apache.drill.exec.ops.OperatorContextImpl.close():124 org.apache.drill.exec.ops.FragmentContext.suppressingClose():416 org.apache.drill.exec.ops.FragmentContext.close():405 org.apache.drill.exec.work.fragment.FragmentExecutor.closeOutResources():346 org.apache.drill.exec.work.fragment.FragmentExecutor.cleanup():179 org.apache.drill.exec.work.fragment.FragmentExecutor.run():290 org.apache.drill.common.SelfCleaningRunnable.run():38 java.util.concurrent.ThreadPoolExecutor.runWorker():1145 java.util.concurrent.ThreadPoolExecutor$Worker.run():615 java.lang.Thread.run():745

Upvotes: 1

Views: 230

Answers (1)

Vasilis Dimakopoulos
Vasilis Dimakopoulos

Reputation: 11

Try increasing DRILLBIT_MAX_PROC_MEM which should be higher than DRILL_MAX_DIRECT_MEMORY+DRILL_HEAP

Upvotes: 0

Related Questions