[
https://issues.apache.org/jira/browse/DRILL-1982?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Abhishek Girish resolved DRILL-1982.
------------------------------------
Resolution: Fixed
> Querying a hive table with a 'limit' clause throws exceptions (intermittent)
> ----------------------------------------------------------------------------
>
> Key: DRILL-1982
> URL: https://issues.apache.org/jira/browse/DRILL-1982
> Project: Apache Drill
> Issue Type: Bug
> Components: Storage - Hive
> Affects Versions: 0.8.0
> Reporter: Abhishek Girish
> Assignee: Venki Korukanti
> Fix For: 0.9.0
>
>
> Executing a simple hive query with a limit clause throws exceptions after
> displaying results. The issue is intermittent.
> > select * from hive.orders limit 1;
> +------------+------------+---------------+--------------+-------------+-----------------+------------+----------------+------------+
> | o_orderkey | o_custkey | o_orderstatus | o_totalprice | o_orderdate |
> o_orderpriority | o_clerk | o_shippriority | o_comment |
> +------------+------------+---------------+--------------+-------------+-----------------+------------+----------------+------------+
> | 540000001 | 5426912 | O | 140554.94 | 1996-05-19 |
> 3-MEDIUM | Clerk#000050378 | 0 | accounts cajole fur |
> Query failed: Query failed: Failure while running fragment., refCnt: 0,
> decrement: 1 [ 4d7a92d6-5895-4cec-8312-97894b31124e on abhi5.qa.lab:31010 ]
> [ 4d7a92d6-5895-4cec-8312-97894b31124e on abhi5.qa.lab:31010 ]
> java.lang.RuntimeException: java.sql.SQLException: Failure while executing
> query.
> at sqlline.SqlLine$IncrementalRows.hasNext(SqlLine.java:2514)
> at sqlline.SqlLine$TableOutputFormat.print(SqlLine.java:2148)
> at sqlline.SqlLine.print(SqlLine.java:1809)
> at sqlline.SqlLine$Commands.execute(SqlLine.java:3766)
> at sqlline.SqlLine$Commands.sql(SqlLine.java:3663)
> at sqlline.SqlLine.dispatch(SqlLine.java:889)
> at sqlline.SqlLine.begin(SqlLine.java:763)
> at sqlline.SqlLine.start(SqlLine.java:498)
> at sqlline.SqlLine.main(SqlLine.java:460)
> LOG snippet:
> 2015-01-12 12:01:58,619 [BitServer-1] INFO
> o.a.drill.exec.rpc.data.DataServer - Channel closed between local
> /10.10.103.32:31012 and remote /10.10.103.32:60138
> 2015-01-12 12:01:58,620 [BitServer-1] INFO
> o.a.d.exec.rpc.ProtobufLengthDecoder - Channel is closed, discarding
> remaining 43410 byte(s) in buffer.
> 2015-01-12 12:01:58,620 [BitClient-1] WARN
> o.a.d.exec.rpc.RpcExceptionHandler - Exception with closed channel
> java.io.IOException: Connection reset by peer
> at sun.nio.ch.FileDispatcherImpl.read0(Native Method) ~[na:1.7.0_65]
> at sun.nio.ch.SocketDispatcher.read(SocketDispatcher.java:39)
> ~[na:1.7.0_65]
> at sun.nio.ch.IOUtil.readIntoNativeBuffer(IOUtil.java:223)
> ~[na:1.7.0_65]
> at sun.nio.ch.IOUtil.read(IOUtil.java:192) ~[na:1.7.0_65]
> at sun.nio.ch.SocketChannelImpl.read(SocketChannelImpl.java:379)
> ~[na:1.7.0_65]
> at
> io.netty.buffer.PooledUnsafeDirectByteBuf.setBytes(PooledUnsafeDirectByteBuf.java:311)
> ~[netty-buffer-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.buffer.AbstractByteBuf.writeBytes(AbstractByteBuf.java:881)
> ~[netty-buffer-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.buffer.WrappedByteBuf.writeBytes(WrappedByteBuf.java:641)
> ~[netty-buffer-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.buffer.UnsafeDirectLittleEndian.writeBytes(UnsafeDirectLittleEndian.java:25)
> ~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:4.0.24.Final]
> at
> io.netty.channel.socket.nio.NioSocketChannel.doReadBytes(NioSocketChannel.java:225)
> ~[netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:119)
> ~[netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:116)
> [netty-common-4.0.24.Final.jar:4.0.24.Final]
> at java.lang.Thread.run(Thread.java:745) [na:1.7.0_65]
> 2015-01-12 12:01:58,620 [BitClient-1] INFO
> o.a.drill.exec.rpc.data.DataClient - Channel closed between local
> 0.0.0.0/0.0.0.0:60138 and remote abhi5.qa.lab/10.10.103.32:31012
> 2015-01-12 12:01:58,621 [BitClient-1] WARN
> o.a.d.exec.rpc.RpcExceptionHandler - Exception with closed channel
> java.nio.channels.ClosedChannelException: null
> 2015-01-12 12:01:58,621 [BitClient-1] WARN
> o.a.d.exec.rpc.RpcExceptionHandler - Exception with closed channel
> java.nio.channels.ClosedChannelException: null
> 2015-01-12 12:01:58,628 [BitServer-9] INFO
> o.a.d.exec.rpc.control.ControlClient - Channel closed between local
> 0.0.0.0/0.0.0.0:34457 and remote abhi8.qa.lab/10.10.103.35:31011
> 2015-01-12 12:01:58,629 [BitServer-9] WARN
> o.a.d.e.p.i.u.UnorderedReceiverBatch - Failed to inform upstream that
> receiver is finished
> 2015-01-12 12:01:58,629 [BitServer-9] WARN
> o.a.d.e.p.i.u.UnorderedReceiverBatch - Failed to inform upstream that
> receiver is finished
> 2015-01-12 12:01:58,629 [BitServer-9] WARN
> o.a.d.e.p.i.u.UnorderedReceiverBatch - Failed to inform upstream that
> receiver is finished
> 2015-01-12 12:01:58,629 [BitServer-9] WARN
> o.a.d.e.p.i.u.UnorderedReceiverBatch - *Failed to inform upstream that
> receiver is finished*
> 2015-01-12 12:01:58,630 [BitServer-3] ERROR
> o.a.d.exec.rpc.RpcExceptionHandler - Exception in pipeline. Closing channel
> between local /10.10.103.32:31012 and remote /10.10.103.32:60139
> *io.netty.handler.codec.DecoderException:
> io.netty.util.IllegalReferenceCountException: refCnt: 0, decrement: 1*
> at
> io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:99)
> [netty-codec-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:319)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103)
> [netty-codec-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:319)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:161)
> [netty-codec-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:319)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:333)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:319)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:787)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:130)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:511)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:468)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:382)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:354)
> [netty-transport-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:116)
> [netty-common-4.0.24.Final.jar:4.0.24.Final]
> at java.lang.Thread.run(Thread.java:745) [na:1.7.0_65]
> Caused by: io.netty.util.IllegalReferenceCountException: refCnt: 0,
> decrement: 1
> at
> io.netty.buffer.AbstractReferenceCountedByteBuf.release(AbstractReferenceCountedByteBuf.java:101)
> ~[netty-buffer-4.0.24.Final.jar:4.0.24.Final]
> at io.netty.buffer.WrappedByteBuf.release(WrappedByteBuf.java:820)
> ~[netty-buffer-4.0.24.Final.jar:4.0.24.Final]
> at
> io.netty.buffer.UnsafeDirectLittleEndian.release(UnsafeDirectLittleEndian.java:25)
> ~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:4.0.24.Final]
> at io.netty.buffer.DrillBuf.release(DrillBuf.java:206)
> ~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:4.0.24.Final]
> at io.netty.buffer.DrillBuf.release(DrillBuf.java:206)
> ~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:4.0.24.Final]
> at
> org.apache.drill.exec.rpc.InboundRpcMessage.release(InboundRpcMessage.java:52)
> ~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at
> org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:203)
> ~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at
> org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:173)
> ~[drill-java-exec-0.8.0-SNAPSHOT-rebuffed.jar:0.8.0-SNAPSHOT]
> at
> io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89)
> [netty-codec-4.0.24.Final.jar:4.0.24.Final]
> ... 19 common frames omitted
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
