[jira] [Updated] (DRILL-7120) Query fails with ChannelClosedException when Statistics is disabled.
[ https://issues.apache.org/jira/browse/DRILL-7120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-7120: -- Summary: Query fails with ChannelClosedException when Statistics is disabled. (was: Query fails with ChannelClosedException) > Query fails with ChannelClosedException when Statistics is disabled. > > > Key: DRILL-7120 > URL: https://issues.apache.org/jira/browse/DRILL-7120 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning Optimization >Affects Versions: 1.16.0 >Reporter: Robert Hou >Assignee: Gautam Parai >Priority: Blocker > Fix For: 1.16.0 > > > TPCH query 5 fails at sf100 when Statistics is disabled. Here is the query: > {noformat} > select > n.n_name, > sum(l.l_extendedprice * (1 - l.l_discount)) as revenue > from > customer c, > orders o, > lineitem l, > supplier s, > nation n, > region r > where > c.c_custkey = o.o_custkey > and l.l_orderkey = o.o_orderkey > and l.l_suppkey = s.s_suppkey > and c.c_nationkey = s.s_nationkey > and s.s_nationkey = n.n_nationkey > and n.n_regionkey = r.r_regionkey > and r.r_name = 'EUROPE' > and o.o_orderdate >= date '1997-01-01' > and o.o_orderdate < date '1997-01-01' + interval '1' year > group by > n.n_name > order by > revenue desc; > {noformat} > This is the error from drillbit.log: > {noformat} > 2019-03-04 17:46:38,684 [23822b0a-b7bd-0b79-b905-1438f5b1d039:frag:6:64] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 23822b0a-b7bd-0b79-b905-1438f5b1d039:6:64: State change requested RUNNING --> > FINISHED > 2019-03-04 17:46:38,684 [23822b0a-b7bd-0b79-b905-1438f5b1d039:frag:6:64] INFO > o.a.d.e.w.f.FragmentStatusReporter - > 23822b0a-b7bd-0b79-b905-1438f5b1d039:6:64: State to report: FINISHED > 2019-03-04 18:17:51,454 [BitServer-13] WARN > o.a.d.exec.rpc.ProtobufLengthDecoder - Failure allocating buffer on incoming > stream due to memory limits. Current Allocation: 262144. > 2019-03-04 18:17:51,454 [BitServer-13] ERROR > o.a.drill.exec.rpc.data.DataServer - Out of memory in RPC layer. > 2019-03-04 18:17:51,463 [BitServer-13] ERROR > o.a.d.exec.rpc.RpcExceptionHandler - Exception in RPC communication. > Connection: /10.10.120.104:31012 <--> /10.10.120.106:53048 (data server). > Closing connection. > io.netty.handler.codec.DecoderException: > org.apache.drill.exec.exception.OutOfMemoryException: Failure allocating > buffer. > at > io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:271) > ~[netty-codec-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1294) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:911) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:645) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at >
[jira] [Updated] (DRILL-7120) Query fails with ChannelClosedException when Statistics is disabled
[ https://issues.apache.org/jira/browse/DRILL-7120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ] Robert Hou updated DRILL-7120: -- Summary: Query fails with ChannelClosedException when Statistics is disabled (was: Query fails with ChannelClosedException when Statistics is disabled.) > Query fails with ChannelClosedException when Statistics is disabled > --- > > Key: DRILL-7120 > URL: https://issues.apache.org/jira/browse/DRILL-7120 > Project: Apache Drill > Issue Type: Bug > Components: Query Planning Optimization >Affects Versions: 1.16.0 >Reporter: Robert Hou >Assignee: Gautam Parai >Priority: Blocker > Fix For: 1.16.0 > > > TPCH query 5 fails at sf100 when Statistics is disabled. Here is the query: > {noformat} > select > n.n_name, > sum(l.l_extendedprice * (1 - l.l_discount)) as revenue > from > customer c, > orders o, > lineitem l, > supplier s, > nation n, > region r > where > c.c_custkey = o.o_custkey > and l.l_orderkey = o.o_orderkey > and l.l_suppkey = s.s_suppkey > and c.c_nationkey = s.s_nationkey > and s.s_nationkey = n.n_nationkey > and n.n_regionkey = r.r_regionkey > and r.r_name = 'EUROPE' > and o.o_orderdate >= date '1997-01-01' > and o.o_orderdate < date '1997-01-01' + interval '1' year > group by > n.n_name > order by > revenue desc; > {noformat} > This is the error from drillbit.log: > {noformat} > 2019-03-04 17:46:38,684 [23822b0a-b7bd-0b79-b905-1438f5b1d039:frag:6:64] INFO > o.a.d.e.w.fragment.FragmentExecutor - > 23822b0a-b7bd-0b79-b905-1438f5b1d039:6:64: State change requested RUNNING --> > FINISHED > 2019-03-04 17:46:38,684 [23822b0a-b7bd-0b79-b905-1438f5b1d039:frag:6:64] INFO > o.a.d.e.w.f.FragmentStatusReporter - > 23822b0a-b7bd-0b79-b905-1438f5b1d039:6:64: State to report: FINISHED > 2019-03-04 18:17:51,454 [BitServer-13] WARN > o.a.d.exec.rpc.ProtobufLengthDecoder - Failure allocating buffer on incoming > stream due to memory limits. Current Allocation: 262144. > 2019-03-04 18:17:51,454 [BitServer-13] ERROR > o.a.drill.exec.rpc.data.DataServer - Out of memory in RPC layer. > 2019-03-04 18:17:51,463 [BitServer-13] ERROR > o.a.d.exec.rpc.RpcExceptionHandler - Exception in RPC communication. > Connection: /10.10.120.104:31012 <--> /10.10.120.106:53048 (data server). > Closing connection. > io.netty.handler.codec.DecoderException: > org.apache.drill.exec.exception.OutOfMemoryException: Failure allocating > buffer. > at > io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:271) > ~[netty-codec-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1294) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:911) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131) > [netty-transport-4.0.48.Final.jar:4.0.48.Final] > at > io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:645) > [netty-transport-4.0.48.Final.jar:4.0.48.Final]