[DRILL-1010] Query throws exception after displaying result

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Storage - Parquet
• Labels: no_verified_test
• Assignee: Unassigned
• Reporter: Abhishek Girish
• Created: 18/Jun/14 16:03
• Updated: 08/May/15 19:27
• Resolved: 15/Jul/14 18:54

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.