Dremio SYSTEM ERROR: IllegalStateException: Memory was leaked by query


#1

We have a view that runs as expected in Oracle. When I recreate this view in Dremio, using VDSs that use reflections and reference the underlying Oracle tables, we’re getting the following error:

SYSTEM ERROR: IllegalStateException: Memory was leaked by query. Memory leaked: (99328) Allocator(op:14:0:5:JdbcSubScan) 1000000/99328/47661312/9223372036854775807 (res/actual/peak/limit) Fragment 14:0 [Error Id: 0f7b3cc8-f74c-4ed3-9cf7-722dd13059f2 on XXX.XXX.XXX:31010] (java.lang.IllegalStateException) Memory was leaked by query. Memory leaked: (99328) Allocator(op:14:0:5:JdbcSubScan) 1000000/99328/47661312/9223372036854775807 (res/actual/peak/limit) org.apache.arrow.memory.BaseAllocator.close():426 com.dremio.common.AutoCloseables.close():92 com.dremio.common.AutoCloseables.close():71 com.dremio.sabot.exec.context.OperatorContextImpl.close():214 com.dremio.common.AutoCloseables.close():92 com.dremio.sabot.exec.fragment.OperatorContextCreator.close():146 com.dremio.common.DeferredException.suppressingClose():181 com.dremio.sabot.exec.fragment.FragmentExecutor.retire():424 com.dremio.sabot.exec.fragment.FragmentExecutor.finishRun():376 com.dremio.sabot.exec.fragment.FragmentExecutor.run():284 com.dremio.sabot.exec.fragment.FragmentExecutor.access$1000():93 com.dremio.sabot.exec.fragment.FragmentExecutor$AsyncTaskImpl.run():619 com.dremio.sabot.task.AsyncTaskWrapper.run():103 com.dremio.sabot.task.slicing.SlicingThread.mainExecutionLoop():123 com.dremio.sabot.task.slicing.SlicingThread.run():68

How can we troubleshoot this?


#2

Hi @summersmd

What version of Dremio are you running? This is something we fixed in 3.1.1

Dremio 3.1.1

Thanks
@balaji.ramaswamy


#4

Thanks. That fixed it!