You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@drill.apache.org by "Abhishek Girish (JIRA)" <ji...@apache.org> on 2015/01/12 21:10:35 UTC
[jira] [Created] (DRILL-1982) Querying a hive table with a 'limit'
clause throws exceptions (intermittent)
Abhishek Girish created DRILL-1982:
--------------------------------------
Summary: 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: Jacques Nadeau
Priority: Minor
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)