drill-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Abhishek Girish (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (DRILL-1982) Querying a hive table with a 'limit' clause throws exceptions (intermittent)
Date Fri, 13 Feb 2015 02:55:13 GMT

    [ https://issues.apache.org/jira/browse/DRILL-1982?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14319496#comment-14319496
] 

Abhishek Girish commented on DRILL-1982:
----------------------------------------

I see that too. Marking it as resolved. 

> 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)

Mime
View raw message