You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@drill.apache.org by Boris Chmiel <bo...@yahoo.com.INVALID> on 2015/09/16 18:59:17 UTC
ChannelclosedException
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
Re: ChannelclosedException
Posted by Abhishek Girish <ab...@gmail.com>.
For the said error ID, are there more messages in the log, which could give
out more information?
Could you also share the query & profile (full JSON) for the query? May be
you put it up on gist and share a link. Someone here could take a look.
Try and increase the value for DRILL_MAX_DIRECT_MEMORY and see if that
helps. Refer to https://drill.apache.org/docs/configuring-drill-memory/ for
instructions.
Also, to improve query performance, please see
https://drill.apache.org/docs/performance-tuning-introduction/
On Wed, Sep 23, 2015 at 9:10 AM, Boris Chmiel <
boris.chmiel@yahoo.com.invalid> wrote:
> 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
>
Re: ChannelclosedException
Posted by Boris Chmiel <bo...@yahoo.com.INVALID>.
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 <ab...@gmail.com> 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 <
boris.chmiel@yahoo.com.invalid> 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
Re: ChannelclosedException
Posted by Abhishek Girish <ab...@gmail.com>.
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 <
boris.chmiel@yahoo.com.invalid> 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