Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-7027

TPCH Queries hit IOB when planner.enable_demux_exchange = true

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: Execution - Flow
    • Labels:
      None

      Description

      Runing TPCH queries on SF100 dataset, a few queries (13, 14, and 19) hit IOB exception:

       java.sql.SQLException: SYSTEM ERROR: IndexOutOfBoundsException: index 154
      
      Fragment 7:0
      
      Please, refer to logs for more information.
      
      [Error Id: e312dc77-0cad-4bc0-b90e-fb0d477ef272 on ucs-node2.perf.lab:31010]
              at org.apache.drill.jdbc.impl.DrillCursor.nextRowInternally(DrillCursor.java:528)
              at org.apache.drill.jdbc.impl.DrillCursor.next(DrillCursor.java:632)
              at org.apache.calcite.avatica.AvaticaResultSet.next(AvaticaResultSet.java:217)
              at org.apache.drill.jdbc.impl.DrillResultSetImpl.next(DrillResultSetImpl.java:151)
              at PipSQueak.fetchRows(PipSQueak.java:346)
              at PipSQueak.runTest(PipSQueak.java:113)
              at PipSQueak.main(PipSQueak.java:477)
      Caused by: org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: IndexOutOfBoundsException: index 154
      
      Fragment 7:0
      
      Please, refer to logs for more information.
      
      [Error Id: e312dc77-0cad-4bc0-b90e-fb0d477ef272 on ucs-node2.perf.lab:31010]
              at org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:123)
              at org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:422)
              at org.apache.drill.exec.rpc.user.UserClient.handle(UserClient.java:96)
              at org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:273)
              at org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:243)
              at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:88)
              at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356)
              at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)
              at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335)
              at io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:287)
              at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356)
              at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)
              at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335)
              at io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:102)
              at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356)
              at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)
              at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335)
              at io.netty.handler.codec.ByteToMessageDecoder.fireChannelRead(ByteToMessageDecoder.java:312)
              at io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:286)
              at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356)
              at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)
              at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335)
              at io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86)
              at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356)
              at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)
              at io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:335)
              at io.netty.channel.DefaultChannelPipeline$HeadContext.channelRead(DefaultChannelPipeline.java:1294)
              at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:356)
              at io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:342)
              at io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:911)
              at io.netty.channel.nio.AbstractNioByteChannel$NioByteUnsafe.read(AbstractNioByteChannel.java:131)
              at io.netty.channel.nio.NioEventLoop.processSelectedKey(NioEventLoop.java:645)
              at io.netty.channel.nio.NioEventLoop.processSelectedKeysOptimized(NioEventLoop.java:580)
              at io.netty.channel.nio.NioEventLoop.processSelectedKeys(NioEventLoop.java:497)
              at io.netty.channel.nio.NioEventLoop.run(NioEventLoop.java:459)
              at io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:131)
              at java.lang.Thread.run(Thread.java:748)
      [ERROR] Unable to fetch all rows (got only 0) org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: IndexOutOfBoundsException: index 154
      
      

      All the queries executed successfully when the option is set to false (default)
       

        Attachments

          Activity

            People

            • Assignee:
              karthikm Karthikeyan Manivannan
              Reporter:
              karthikm Karthikeyan Manivannan
            • Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

              • Created:
                Updated: