You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2015/04/25 00:41:38 UTC
[jira] [Closed] (DRILL-1982) Querying a hive table with a 'limit'
clause throws exceptions (intermittent)
[ https://issues.apache.org/jira/browse/DRILL-1982?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Abhishek Girish closed DRILL-1982.
----------------------------------
Was identified to be related to DRILL-1859. Closing.
> 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)