[PHOENIX-2291] Error: Could not find hash cache for joinId

• Type: Improvement
• Status: Resolved
• Priority: Minor
• Resolution: Duplicate
• Affects Version/s: 4.5.0

Environment

Centos7 cluster, HBase 1.1, Phoenix 4.5.0

• Assignee: Wei Xue
• Reporter: Dan Meany
• Created: 24/Sep/15 19:22
• Updated: 06/Nov/15 13:29
• Resolved: 06/Nov/15 13:29

Description

Intermittently get error below when joining two tables (~10k rows each). May be load-related.

java.lang.RuntimeException: org.apache.phoenix.exception.PhoenixIOException: org.apache.phoenix.exception.PhoenixIOException: org.apache.hadoop.hbase.DoNotRetryIOException: Could not find hash cache for joinId: �X�w��ZY. The cache might have expired and have been removed.
at org.apache.phoenix.coprocessor.HashJoinRegionScanner.<init>(HashJoinRegionScanner.java:96)
at org.apache.phoenix.coprocessor.ScanRegionObserver.doPostScannerOpen(ScanRegionObserver.java:213)
at org.apache.phoenix.coprocessor.BaseScannerRegionObserver.postScannerOpen(BaseScannerRegionObserver.java:179)
at org.apache.hadoop.hbase.regionserver.RegionCoprocessorHost$52.call(RegionCoprocessorHost.java:1316)

Query plan looks like:

CLIENT 40-CHUNK PARALLEL 40-WAY FULL SCAN OVER TABLE1_IDX

SERVER FILTER BY FIRST KEY ONLY

PARALLEL LEFT-JOIN TABLE 0

CLIENT 40-CHUNK PARALLEL 40-WAY FULL SCAN OVER TABLE2_IDX

AFTER-JOIN SERVER FILTER BY "MP.:ID" IS NULL

Issue Links

• duplicates: PHOENIX-2381 Inner Join with any table or view with Multi_Tenant=true causes "could not find hash cache for joinId" error