Details
-
Bug
-
Status: Resolved
-
Major
-
Resolution: Cannot Reproduce
-
None
-
None
-
None
-
centos 6.2 VM
Description
getting this error while running query on some dataset using tsv engine:
>SELECT columns[6] from `/user/root/cust-header.tsv` limit 2;
Query failed: org.apache.drill.exec.rpc.RpcException: Remote failure while running query.[error_id: "dedf1821-eb00-47dc-b794-0266e84606a9"
endpoint {
address: "mfs101.qa.lab"
user_port: 31010
control_port: 31011
data_port: 31012
}
error_type: 0
message: "Failure while running fragment. < IndexOutOfBoundsException:[ index: 76080, length: 556 (expected: range(0, 76250)) ]"
]
Error: exception while executing query (state=,code=0)
But if I run SELECT * FROM the same table, it doesn't throw that error :
> SELECT * from `/user/root/cust-header.tsv` limit 2;
------------
| columns |
------------
| [c0, c1, c2-pattern_id, c3, c4, c5, c6, c7, c8, c9, c10, c11, c12, c13, c14-title, c15, c16, c17, c18, c19, c0, c21, c22, c23, c24-uid, c25-recorded, c26, c27, c28, c29, c30-country, c31, c32] |
| [T, 401932827, 1000213, 27, 644297049, 55, /r?c2=1000004&d.c=txt&d.o=nbculimdivisionprod&d.x=195385085&d.t=media&d.m=Afternoon%20Weather%20Video%3A%20Monday%2C%20September%2024%2C%202012&cs_domain_id=6433039443649550087&cs_metro_code=803&cs_ec=US&cs_boc=1346867748, 0, 1000004, , nbculimdivisionprod, , , , Afternoon Weather Video: Monday, September 24, 2012, , OMTR, , , , , , , 0, 937021026, 2816d925-6902-2014-8017-113468677480, 2012-09-25 00:00:27.132, 20120906.02, 60f2761d0e6192a88305054eb06877cb, 1, -8, US, 90189, 1001] |
------------
2 rows selected (0.112 seconds)
Debugging info from Lilith:
java.lang.IndexOutOfBoundsException: index: 76080, length: 556 (expected: range(0, 76250))
at io.netty.buffer.AbstractByteBuf.checkIndex(AbstractByteBuf.java:1130) ~[netty-buffer-4.0.7.Final.jar:na]
at io.netty.buffer.PooledUnsafeDirectByteBufL.setBytes(PooledUnsafeDirectByteBufL.java:216) ~[drill-buffers-1.0.0-m2-incubating-SNAPSHOT.jar:na]
at org.apache.drill.exec.memory.AccountingByteBuf.setBytes(AccountingByteBuf.java:415) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at org.apache.drill.exec.vector.VarCharVector$Mutator.set(VarCharVector.java:412) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at org.apache.drill.exec.test.generated.ProjectorGen116.doEval(ProjectorTemplate.java:39) ~[na:na]
at org.apache.drill.exec.test.generated.ProjectorGen116.projectRecords(ProjectorTemplate.java:64) ~[na:na]
at org.apache.drill.exec.physical.impl.project.ProjectRecordBatch.doWork(ProjectRecordBatch.java:78) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at org.apache.drill.exec.record.AbstractSingleRecordBatch.next(AbstractSingleRecordBatch.java:62) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at org.apache.drill.exec.record.AbstractSingleRecordBatch.next(AbstractSingleRecordBatch.java:42) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at org.apache.drill.exec.physical.impl.limit.LimitRecordBatch.next(LimitRecordBatch.java:87) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at org.apache.drill.exec.physical.impl.ScreenCreator$ScreenRoot.next(ScreenCreator.java:85) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at org.apache.drill.exec.work.fragment.FragmentExecutor.run(FragmentExecutor.java:83) ~[drill-java-exec-1.0.0-m2-incubating-SNAPSHOT-rebuffed.jar:1.0.0-m2-incubating-SNAPSHOT]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145) [na:1.7.0_45]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615) [na:1.7.0_45]
at java.lang.Thread.run(Thread.java:744) [na:1.7.0_45]