[DRILL-782] ArrayIndexOutOfBoundsException encountered in a sequence of query executions

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 0.4.0
• Component/s: Execution - Flow
• Assignee: Zhiyong Liu
• Reporter: Zhiyong Liu
• Created: 19/May/14 22:37
• Updated: 10/Jun/14 17:36
• Resolved: 10/Jun/14 17:36

Description

Datasources: TPCH (10MB), three-way split parquet files
git.commit.id.abbrev=70fab8c
git.commit.id=70fab8c968a6dc05471aa1f32009cd15945d4f3d

Follow the steps in exactly this order:
1. Restart drillbit

2. 0: jdbc:drill:schema=dfs.TpcHMulti> select c_custkey from customer1 order by c_custkey;
------------

c_custkey

------------

1

2

3

4

...

------------

1500

------------
1,500 rows selected (2.781 seconds)

3. Repeat the above query:

0: jdbc:drill:schema=dfs.TpcHMulti> select c_custkey from customer1 order by c_custkey;
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "604a3e93-0eaf-4697-8367-d1d193624413"
endpoint {
address: "perfnode104.perf.lab"
user_port: 31010
control_port: 31011
data_port: 31012
}
error_type: 0
message: "Failure while running fragment. < IndexOutOfBoundsException:[ index: 640, length: 8 (expected: range(0, 640)) ]"
]
Error: exception while executing query (state=,code=0)

4. Now, add limit:

0: jdbc:drill:schema=dfs.TpcHMulti> select c_custkey from customer1 order by c_custkey limit 5;
------------

c_custkey

------------

1

2

3

4

5

------------
5 rows selected (0.465 seconds)