Alok Singh created PHOENIX-3786:
-----------------------------------
Summary: Hash Join Queries fail unpredictibly
Key: PHOENIX-3786
URL: https://issues.apache.org/jira/browse/PHOENIX-3786
Project: Phoenix
Issue Type: Bug
Affects Versions: 4.10.0
Reporter: Alok Singh
When doing queries with hash joins, the queries seem to fail randomly with the
following stacktrace:
{code}
java.util.concurrent.ExecutionException: java.sql.SQLException:
java.lang.IllegalArgumentException: fromIndex(4) > toIndex(1)
at java.util.concurrent.FutureTask.report(FutureTask.java:122)
at java.util.concurrent.FutureTask.get(FutureTask.java:192)
at
org.apache.phoenix.execute.HashJoinPlan.iterator(HashJoinPlan.java:179)
at
org.apache.phoenix.execute.DelegateQueryPlan.iterator(DelegateQueryPlan.java:138)
at
org.apache.phoenix.execute.DelegateQueryPlan.iterator(DelegateQueryPlan.java:133)
at
org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:290)
at
org.apache.phoenix.jdbc.PhoenixStatement$1.call(PhoenixStatement.java:270)
at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
at
org.apache.phoenix.jdbc.PhoenixStatement.executeQuery(PhoenixStatement.java:269)
at
org.apache.phoenix.jdbc.PhoenixPreparedStatement.executeQuery(PhoenixPreparedStatement.java:186)
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:347)
at org.apache.commons.dbutils.QueryRunner.query(QueryRunner.java:289)
at
com.cloudability.ankeny.db.PhoenixReportDAO.runReportImpl(PhoenixReportDAO.java:283)
at
com.cloudability.ankeny.db.PhoenixReportDAO.lambda$queueRequest$72(PhoenixReportDAO.java:172)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)
at
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)
at java.lang.Thread.run(Thread.java:745)
Caused by: java.sql.SQLException: java.lang.IllegalArgumentException:
fromIndex(4) > toIndex(1)
at
org.apache.phoenix.cache.ServerCacheClient.addServerCache(ServerCacheClient.java:272)
at
org.apache.phoenix.join.HashCacheClient.addHashCache(HashCacheClient.java:84)
at
org.apache.phoenix.execute.HashJoinPlan$HashSubPlan.execute(HashJoinPlan.java:378)
at org.apache.phoenix.execute.HashJoinPlan$1.call(HashJoinPlan.java:160)
at org.apache.phoenix.execute.HashJoinPlan$1.call(HashJoinPlan.java:156)
at java.util.concurrent.FutureTask.run(FutureTask.java:266)
at
org.apache.phoenix.job.JobManager$InstrumentedJobFutureTask.run(JobManager.java:183)
... 3 more
Caused by: java.lang.IllegalArgumentException: fromIndex(4) > toIndex(1)
at java.util.ArrayList.subListRangeCheck(ArrayList.java:1006)
at java.util.ArrayList.subList(ArrayList.java:996)
at
org.apache.phoenix.filter.SkipScanFilter.intersect(SkipScanFilter.java:308)
at
org.apache.phoenix.filter.SkipScanFilter.hasIntersect(SkipScanFilter.java:182)
at
org.apache.phoenix.compile.ScanRanges.intersectScan(ScanRanges.java:334)
at
org.apache.phoenix.compile.ScanRanges.intersectRegion(ScanRanges.java:425)
at
org.apache.phoenix.cache.ServerCacheClient.addServerCache(ServerCacheClient.java:177)
{code}
--
This message was sent by Atlassian JIRA
(v6.3.15#6346)
