Re: Could not find hash cache for joinId

[Maryann Xue]

Hi Alex,

Most likely what happened was as suggested by the error message: the cache
might have expired. Could you please check if there are any Phoenix
warnings in the client log and share your query?



Thanks,
Maryann

On Fri, Jul 3, 2015 at 4:01 PM, Alex Kamil <alex.ka...@gmail.com> wrote:

> getting this error with phoenix 3.3.0/hbase 0.94.15, any ideas?
>
>
> org.apache.phoenix.exception.PhoenixIOException: 
> org.apache.phoenix.exception.PhoenixIOException: 
> org.apache.hadoop.hbase.DoNotRetryIOException: Could not find hash cache for 
> joinId: ???Z
> ^XI??. The cache might have expired
>
> and have been removed.
>
>         at 
> org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:96)
>
>         at 
> org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:511)
>
>         at 
> org.apache.phoenix.iterate.MergeSortResultIterator.getIterators(MergeSortResultIterator.java:48)
>
>         at 
> org.apache.phoenix.iterate.MergeSortResultIterator.minIterator(MergeSortResultIterator.java:84)
>
>         at 
> org.apache.phoenix.iterate.MergeSortResultIterator.next(MergeSortResultIterator.java:111)
>
>         at 
> org.apache.phoenix.iterate.DelegateResultIterator.next(DelegateResultIterator.java:44)
>
>         at 
> org.apache.phoenix.iterate.LimitingResultIterator.next(LimitingResultIterator.java:47)
>
>         at 
> org.apache.phoenix.iterate.DelegateResultIterator.next(DelegateResultIterator.java:44)
>
>         at 
> org.apache.phoenix.jdbc.PhoenixResultSet.next(PhoenixResultSet.java:739)
>
>         at 
> org.apache.commons.dbcp.DelegatingResultSet.next(DelegatingResultSet.java:207)
>
> thanks
> Alex
>