[DRILL-1205] group by causes access to DeadBuf

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 1.0.0
• Fix Version/s: 0.5.0
• Component/s: Execution - Relational Operators
• Assignee: DrillCommitter
• Reporter: Jim Scott
• Due: 12/Aug/14
• Created: 28/Jul/14 15:18
• Updated: 18/Aug/14 16:26
• Resolved: 18/Aug/14 16:26

Description

Might be related to drill-922

This runs just fine:
select count as incidents from dfs.`/tmp/Downloads/Crimes_-_2001_to_present.csv` where columns[3] in (SELECT columns[2] FROM dfs.`/tmp/Downloads/Sex_Offenders.csv`);

This fails:
select count as incidents, columns[5] as type, columns[6] as subtype from dfs.`/tmp/Downloads/Crimes_-_2001_to_present.csv`
where columns[3] in (SELECT columns[2] FROM dfs.`/tmp/Downloads/Sex_Offenders.csv`)
group by columns[6], columns[5]
order by incidents desc limit 10;

Error:
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "26218e5d-5748-43b9-bc77-ab82d9a1c509"
endpoint {
address: "myserver"
user_port: 31010
control_port: 31011
data_port: 31012
}
error_type: 0
message: "Failure while running fragment. < IndexOutOfBoundsException:[ index: 28388, length: 4 (expected: range(0, 28388)) ]"
]
Error: exception while executing query (state=,code=0)
0: jdbc:drill:zk=local> Exception in thread "e5e6763f-6d42-42b8-9a75-e972c9cf90c2:frag:0:0 - Producer Thread" java.lang.UnsupportedOperationException: Attemped to access a DeadBuf. This would happen if you attempted to interact with a buffer that has been moved or not yet initialized.
at org.apache.drill.exec.record.DeadBuf.capacity(DeadBuf.java:70)
at org.apache.drill.exec.vector.UInt4Vector.getValueCapacity(UInt4Vector.java:106)
at org.apache.drill.exec.vector.VarCharVector.getValueCapacity(VarCharVector.java:120)
at org.apache.drill.exec.vector.RepeatedVarCharVector.getValueCapacity(RepeatedVarCharVector.java:113)
at org.apache.drill.exec.vector.RepeatedVarCharVector$Mutator.startNewGroup(RepeatedVarCharVector.java:379)
at org.apache.drill.exec.store.text.DrillTextRecordReader.next(DrillTextRecordReader.java:123)
at org.apache.drill.exec.physical.impl.ScanBatch.next(ScanBatch.java:138)
at org.apache.drill.exec.physical.impl.producer.ProducerConsumerBatch$Producer.run(ProducerConsumerBatch.java:122)
at java.lang.Thread.run(Thread.java:745)