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

Query throws exception after displaying result

    XMLWordPrintableJSON

Details

    Description

      This issue was observed with TPC-DS dataset. After displaying results, the query seems to fail with exceptions.

      Query:
      select * from item limit 10;

      Result:
      <Outputs 10 rows>
      Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "bf83170d-b644-4145-b99c-377d60e342e4"
      endpoint {
      address: "drillats2.qa.lab"
      user_port: 31010
      control_port: 31011
      data_port: 31012
      }
      error_type: 0
      message: "Failure while running fragment. < ArrayIndexOutOfBoundsException"
      ]
      java.lang.RuntimeException: java.sql.SQLException: Failure while trying to get next result batch.
      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:
      2014-06-12 00:38:14,654 [4aadf551-2bd6-42b5-a236-fa2e088c0af0:frag:0:0] DEBUG o.a.d.e.w.fragment.FragmentExecutor - Caught exception while running fragment
      java.lang.ArrayIndexOutOfBoundsException: null
      2014-06-12 00:38:14,655 [4aadf551-2bd6-42b5-a236-fa2e088c0af0:frag:0:0] ERROR o.a.d.e.w.f.AbstractStatusReporter - Error 67e30181-bcb9-4cde-bdcd-dcab2b44d28a: Failure while running fragment.
      java.lang.ArrayIndexOutOfBoundsException: null
      2014-06-12 00:38:14,656 [4aadf551-2bd6-42b5-a236-fa2e088c0af0:frag:0:0] DEBUG o.a.d.exec.work.foreman.QueryManager - New fragment status was provided to Foreman of profile {
      state: FAILED
      error {
      error_id: "67e30181-bcb9-4cde-bdcd-dcab2b44d28a"
      endpoint

      { address: "drillats2.qa.lab" user_port: 31010 control_port: 31011 data_port: 31012 }

      error_type: 0
      message: "Failure while running fragment. < ArrayIndexOutOfBoundsException"
      }
      operator_profile {
      input_profile

      { records: 0 batches: 0 schemas: 0 }

      operator_id: 3
      operator_type: 21
      setup_nanos: 0
      process_nanos: 0
      }
      operator_profile {
      input_profile

      { records: 8191 batches: 1 schemas: 1 }

      operator_id: 2
      operator_type: 7
      setup_nanos: 186912
      process_nanos: 176768368
      }
      operator_profile {
      input_profile

      { records: 10 batches: 1 schemas: 1 }

      operator_id: 1
      operator_type: 14
      setup_nanos: 110173355
      process_nanos: 182528775
      }
      start_time: 1402533494300
      end_time: 1402533494655
      memory_used: 53641636
      }
      handle {
      query_id

      { part1: 5381226858754228917 part2: -6757939115204015376 }

      major_fragment_id: 0
      minor_fragment_id: 0
      }

      2014-06-12 00:38:14,674 [WorkManager-8] WARN o.a.d.e.w.fragment.FragmentExecutor - Failure while closing context in failed state.

      Attachments

        Activity

          People

            Unassigned Unassigned
            agirish Abhishek Girish
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: