Hi Abhishek,
It is probably due to OOM. Here is the log :
[Error Id: b58b4918-3ed7-465b-8a16-1bdff8e0fc7f ]
org.apache.drill.common.exceptions.UserException: SYSTEM
ERROR:ChannelClosedException
[Error Id: b58b4918-3ed7-465b-8a16-1bdff8e0fc7f ]
atorg.apache.drill.common.exceptions.UserException$Builder.build(UserException.java:523)~[drill-common-1.1.0.jar:1.1.0]
atorg.apache.drill.exec.rpc.user.QueryResultHandler$SubmissionListener.failed(QueryResultHandler.java:312)[drill-java-exec-1.1.0.jar:1.1.0]
atorg.apache.drill.exec.rpc.CoordinationQueue$RpcListener.setException(CoordinationQueue.java:103)[drill-java-exec-1.1.0.jar:1.1.0]
at
org.apache.drill.exec.rpc.CoordinationQueue$RpcListener.operationComplete(CoordinationQueue.java:89)[drill-java-exec-1.1.0.jar:1.1.0]
atorg.apache.drill.exec.rpc.CoordinationQueue$RpcListener.operationComplete(CoordinationQueue.java:67)[drill-java-exec-1.1.0.jar:1.1.0]
at
io.netty.util.concurrent.DefaultPromise.notifyListener0(DefaultPromise.java:680)[netty-common-4.0.27.Final.jar:4.0.27.Final]
atio.netty.util.concurrent.DefaultPromise.notifyListeners0(DefaultPromise.java:603)[netty-common-4.0.27.Final.jar:4.0.27.Final]
at
io.netty.util.concurrent.DefaultPromise.notifyListeners(DefaultPromise.java:563)[netty-common-4.0.27.Final.jar:4.0.27.Final]
atio.netty.util.concurrent.DefaultPromise.tryFailure(DefaultPromise.java:424)[netty-common-4.0.27.Final.jar:4.0.27.Final]
at
io.netty.channel.AbstractChannel$AbstractUnsafe.safeSetFailure(AbstractChannel.java:788)[netty-transport-4.0.27.Final.jar:4.0.27.Final]
atio.netty.channel.AbstractChannel$AbstractUnsafe.write(AbstractChannel.java:689)[netty-transport-4.0.27.Final.jar:4.0.27.Final]
atio.netty.channel.DefaultChannelPipeline$HeadContext.write(DefaultChannelPipeline.java:1114)[netty-transport-4.0.27.Final.jar:4.0.27.Final]
atio.netty.channel.AbstractChannelHandlerContext.invokeWrite(AbstractChannelHandlerContext.java:705)[netty-transport-4.0.27.Final.jar:4.0.27.Final]
atio.netty.channel.AbstractChannelHandlerContext.access$1900(AbstractChannelHandlerContext.java:32)[netty-transport-4.0.27.Final.jar:4.0.27.Final]
at
io.netty.channel.AbstractChannelHandlerContext$AbstractWriteTask.write(AbstractChannelHandlerContext.java:980)[netty-transport-4.0.27.Final.jar:4.0.27.Final]
atio.netty.channel.AbstractChannelHandlerContext$WriteAndFlushTask.write(AbstractChannelHandlerContext.java:1032)[netty-transport-4.0.27.Final.jar:4.0.27.Final]
atio.netty.channel.AbstractChannelHandlerContext$AbstractWriteTask.run(AbstractChannelHandlerContext.java:965)[netty-transport-4.0.27.Final.jar:4.0.27.Final]
atio.netty.util.concurrent.SingleThreadEventExecutor.runAllTasks(SingleThreadEventExecutor.java:357)[netty-common-4.0.27.Final.jar:4.0.27.Final]
atio.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:357)[netty-transport-4.0.27.Final.jar:4.0.27.Final]
at
io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)[netty-common-4.0.27.Final.jar:4.0.27.Final]
at java.lang.Thread.run(Thread.java:745) [na:1.7.0_79]
Caused by: org.apache.drill.exec.rpc.ChannelClosedException: null
... 18 common frames omitted
Le Mercredi 16 septembre 2015 19h43, Abhishek Girish
<[email protected]> a écrit :
Hi Boris,
Can you share relevant logs? The exception you shared is not the actual
cause of failure - rather an after effect. You can ignore those.
If I could suspect, I'd say it could be due to OOM (given it being a
complex query).
Regards,
Abhishek
On Wed, Sep 16, 2015 at 9:59 AM, Boris Chmiel <
[email protected]> wrote:
> Hi everyone,While running a huge query with many joins, Drill reach SYSTEM
> ERROR : ChannelclosedExceptionDoes anyone experience the same error and
> have a clue about how to solve it? Thanks
