java.sql.SQLException: RESOURCE ERROR: One or more nodes ran out of memory while executing the query. Fragment 0:0 [Error Id: 3323fd1c-4b78-42a7-b311-23ee73c7d550 on atsqa4-193.qa.lab:31010]

drill-dev | Khurram Faraaz (JIRA) | 11 months ago
  1. 0

    [jira] [Created] (DRILL-4243) CTAS with partition by, results in Out Of Memory

    drill-dev | 11 months ago | Khurram Faraaz (JIRA)
    java.sql.SQLException: RESOURCE ERROR: One or more nodes ran out of memory while executing the query. Fragment 0:0 [Error Id: 3323fd1c-4b78-42a7-b311-23ee73c7d550 on atsqa4-193.qa.lab:31010]
  2. 0

    How to omit the header when reading a CSV file using Apache Drill 1.3.0 but without installing Apache Drill?

    Stack Overflow | 12 months ago | Ashish Pancholi
    org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: NumberFormatException: A Fragment 0:0 [Error Id: 72dec3db-8f28-462d-838d-dcb60663e389 on ashish:31010]
  3. 0

    How to specify `delimiter` when reading a CSV file using Apache Drill?

    Stack Overflow | 12 months ago | Ashish Pancholi
    org.apache.drill.common.exceptions.UserRemoteException: SYSTEM ERROR: NumberFormatException: 100"^"100 Fragment 0:0 [Error Id: 5c3ac2d7-fe66-4799-92cc-3efdc642c9dd on ashish:31010]
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0
    Enable union types and disable BSON reader ALTER SYSTEM SET `exec.enable_union_type` = true; ALTER SYSTEM SET `store.mongo.bson.record.reader` = false;

  1. rp 2 times, last 9 months ago

Root Cause Analysis

  1. org.apache.drill.common.exceptions.UserRemoteException

    RESOURCE ERROR: One or more nodes ran out of memory while executing the query. Fragment 0:0 [Error Id: 3323fd1c-4b78-42a7-b311-23ee73c7d550 on atsqa4-193.qa.lab:31010]

    at org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived()
  2. org.apache.drill
    RpcBus$InboundHandler.decode
    1. org.apache.drill.exec.rpc.user.QueryResultHandler.resultArrived(QueryResultHandler.java:119)
    2. org.apache.drill.exec.rpc.user.UserClient.handleReponse(UserClient.java:113)
    3. org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:46)
    4. org.apache.drill.exec.rpc.BasicClientWithConnection.handle(BasicClientWithConnection.java:31)
    5. org.apache.drill.exec.rpc.RpcBus.handle(RpcBus.java:69)
    6. org.apache.drill.exec.rpc.RpcBus$RequestEvent.run(RpcBus.java:400)
    7. org.apache.drill.common.SerializedExecutor$RunnableProcessor.run(SerializedExecutor.java:105)
    8. org.apache.drill.exec.rpc.RpcBus$SameExecutor.execute(RpcBus.java:264)
    9. org.apache.drill.common.SerializedExecutor.execute(SerializedExecutor.java:142)
    10. org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:298)
    11. org.apache.drill.exec.rpc.RpcBus$InboundHandler.decode(RpcBus.java:269)
    11 frames
  3. Netty
    SingleThreadEventExecutor$2.run
    1. io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:89)
    2. io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)
    3. io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)
    4. io.netty.handler.timeout.IdleStateHandler.channelRead(IdleStateHandler.java:254)
    5. io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)
    6. io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)
    7. io.netty.handler.codec.MessageToMessageDecoder.channelRead(MessageToMessageDecoder.java:103)
    8. io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)
    9. io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)
    10. io.netty.handler.codec.ByteToMessageDecoder.channelRead(ByteToMessageDecoder.java:242)
    11. io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)
    12. io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)
    13. io.netty.channel.ChannelInboundHandlerAdapter.channelRead(ChannelInboundHandlerAdapter.java:86)
    14. io.netty.channel.AbstractChannelHandlerContext.invokeChannelRead(AbstractChannelHandlerContext.java:339)
    15. io.netty.channel.AbstractChannelHandlerContext.fireChannelRead(AbstractChannelHandlerContext.java:324)
    16. io.netty.channel.DefaultChannelPipeline.fireChannelRead(DefaultChannelPipeline.java:847)
    17. io.netty.channel.epoll.AbstractEpollStreamChannel$EpollStreamUnsafe.epollInReady(AbstractEpollStreamChannel.java:618)
    18. io.netty.channel.epoll.EpollEventLoop.processReady(EpollEventLoop.java:329)
    19. io.netty.channel.epoll.EpollEventLoop.run(EpollEventLoop.java:250)
    20. io.netty.util.concurrent.SingleThreadEventExecutor$2.run(SingleThreadEventExecutor.java:111)
    20 frames
  4. Java RT
    Thread.run
    1. java.lang.Thread.run(Thread.java:744)
    1 frame