You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by Bahubali Jain <ba...@gmail.com> on 2015/07/15 16:14:27 UTC
StaleRegionBoundaryCacheException
Hi,
I am running into the below exception while running a count(*) query on a
hbase table (created a view in phoenix)
java.lang.RuntimeException:
org.apache.phoenix.schema.StaleRegionBoundaryCacheException: ERROR 1108
(XCL08): Cache of region boundaries are out of date.
at sqlline.IncrementalRows.hasNext(IncrementalRows.java:73)
at sqlline.TableOutputFormat.print(TableOutputFormat.java:33)
at sqlline.SqlLine.print(SqlLine.java:1653)
at sqlline.Commands.execute(Commands.java:833)
at sqlline.Commands.sql(Commands.java:732)
at sqlline.SqlLine.dispatch(SqlLine.java:808)
at sqlline.SqlLine.begin(SqlLine.java:681)
at sqlline.SqlLine.start(SqlLine.java:398)
at sqlline.SqlLine.main(SqlLine.java:292)
Can you please provide some inputs on this.
Thanks,
Baahu
Re: StaleRegionBoundaryCacheException
Posted by James Taylor <ja...@apache.org>.
Baahu,
Yes, definitely file a JIRA with all the information you have. It's more
likely to get attention if you can write a unit test or script that
reproduces the problem.
Thanks,
James
On Thu, Jul 23, 2015 at 7:20 AM, Bahubali Jain <ba...@gmail.com> wrote:
> James,
> I have faced this issue with views, I created a view with around 260
> columns in it, wonder if this has anything to do with the issue.
> I was able to access the data thru the view for few hours and then ran
> into the staleregionboundarycache exception.
> I observed this behavior twice.
> Would this info suffice in the JIRA?
>
> Thanks,
> Baahu
>
> On Tue, Jul 21, 2015 at 3:33 AM, James Taylor <ja...@apache.org>
> wrote:
>
>> Thanks for the information, Baahu. If you could figure out how to
>> reproduce this and file a JIRA, that would be much appreciated.
>>
>> James
>>
>> On Mon, Jul 20, 2015 at 1:34 AM, Bahubali Jain <ba...@gmail.com>
>> wrote:
>>
>>> James,
>>> I am using Phoenix 4.4 and HBase 1.0 (CDH 5.4.2).
>>> I am always seeing this error.This table not being written to during
>>> count(*) execution.
>>>
>>> Thanks,
>>> Baahu
>>>
>>> On Fri, Jul 17, 2015 at 10:27 PM, James Taylor <ja...@apache.org>
>>> wrote:
>>>
>>>> This exception means that the region boundary cache kept on the client
>>>> is out of sync with the actual region boundaries on the HBase table. When
>>>> this occurs, the query is retried once (after invalidating the cache). If
>>>> it happens a second time, the exception is thrown to the client.
>>>>
>>>> What version of Phoenix and HBase are you using? If you run the query a
>>>> second time, do you continue to see this error? Is the table being heavily
>>>> written to you when you execute the count(*) query?
>>>>
>>>> Thanks,
>>>> James
>>>>
>>>> On Wed, Jul 15, 2015 at 7:14 AM, Bahubali Jain <ba...@gmail.com>
>>>> wrote:
>>>>
>>>>> Hi,
>>>>> I am running into the below exception while running a count(*) query
>>>>> on a hbase table (created a view in phoenix)
>>>>> java.lang.RuntimeException:
>>>>> org.apache.phoenix.schema.StaleRegionBoundaryCacheException: ERROR 1108
>>>>> (XCL08): Cache of region boundaries are out of date.
>>>>> at sqlline.IncrementalRows.hasNext(IncrementalRows.java:73)
>>>>> at sqlline.TableOutputFormat.print(TableOutputFormat.java:33)
>>>>> at sqlline.SqlLine.print(SqlLine.java:1653)
>>>>> at sqlline.Commands.execute(Commands.java:833)
>>>>> at sqlline.Commands.sql(Commands.java:732)
>>>>> at sqlline.SqlLine.dispatch(SqlLine.java:808)
>>>>> at sqlline.SqlLine.begin(SqlLine.java:681)
>>>>> at sqlline.SqlLine.start(SqlLine.java:398)
>>>>> at sqlline.SqlLine.main(SqlLine.java:292)
>>>>>
>>>>> Can you please provide some inputs on this.
>>>>>
>>>>> Thanks,
>>>>> Baahu
>>>>>
>>>>>
>>>>>
>>>>
>>>
>>>
>>> --
>>> Twitter:http://twitter.com/Baahu
>>>
>>>
>>
>
>
> --
> Twitter:http://twitter.com/Baahu
>
>
Re: StaleRegionBoundaryCacheException
Posted by Bahubali Jain <ba...@gmail.com>.
James,
I have faced this issue with views, I created a view with around 260
columns in it, wonder if this has anything to do with the issue.
I was able to access the data thru the view for few hours and then ran into
the staleregionboundarycache exception.
I observed this behavior twice.
Would this info suffice in the JIRA?
Thanks,
Baahu
On Tue, Jul 21, 2015 at 3:33 AM, James Taylor <ja...@apache.org>
wrote:
> Thanks for the information, Baahu. If you could figure out how to
> reproduce this and file a JIRA, that would be much appreciated.
>
> James
>
> On Mon, Jul 20, 2015 at 1:34 AM, Bahubali Jain <ba...@gmail.com> wrote:
>
>> James,
>> I am using Phoenix 4.4 and HBase 1.0 (CDH 5.4.2).
>> I am always seeing this error.This table not being written to during
>> count(*) execution.
>>
>> Thanks,
>> Baahu
>>
>> On Fri, Jul 17, 2015 at 10:27 PM, James Taylor <ja...@apache.org>
>> wrote:
>>
>>> This exception means that the region boundary cache kept on the client
>>> is out of sync with the actual region boundaries on the HBase table. When
>>> this occurs, the query is retried once (after invalidating the cache). If
>>> it happens a second time, the exception is thrown to the client.
>>>
>>> What version of Phoenix and HBase are you using? If you run the query a
>>> second time, do you continue to see this error? Is the table being heavily
>>> written to you when you execute the count(*) query?
>>>
>>> Thanks,
>>> James
>>>
>>> On Wed, Jul 15, 2015 at 7:14 AM, Bahubali Jain <ba...@gmail.com>
>>> wrote:
>>>
>>>> Hi,
>>>> I am running into the below exception while running a count(*) query on
>>>> a hbase table (created a view in phoenix)
>>>> java.lang.RuntimeException:
>>>> org.apache.phoenix.schema.StaleRegionBoundaryCacheException: ERROR 1108
>>>> (XCL08): Cache of region boundaries are out of date.
>>>> at sqlline.IncrementalRows.hasNext(IncrementalRows.java:73)
>>>> at sqlline.TableOutputFormat.print(TableOutputFormat.java:33)
>>>> at sqlline.SqlLine.print(SqlLine.java:1653)
>>>> at sqlline.Commands.execute(Commands.java:833)
>>>> at sqlline.Commands.sql(Commands.java:732)
>>>> at sqlline.SqlLine.dispatch(SqlLine.java:808)
>>>> at sqlline.SqlLine.begin(SqlLine.java:681)
>>>> at sqlline.SqlLine.start(SqlLine.java:398)
>>>> at sqlline.SqlLine.main(SqlLine.java:292)
>>>>
>>>> Can you please provide some inputs on this.
>>>>
>>>> Thanks,
>>>> Baahu
>>>>
>>>>
>>>>
>>>
>>
>>
>> --
>> Twitter:http://twitter.com/Baahu
>>
>>
>
--
Twitter:http://twitter.com/Baahu
Re: StaleRegionBoundaryCacheException
Posted by James Taylor <ja...@apache.org>.
Thanks for the information, Baahu. If you could figure out how to reproduce
this and file a JIRA, that would be much appreciated.
James
On Mon, Jul 20, 2015 at 1:34 AM, Bahubali Jain <ba...@gmail.com> wrote:
> James,
> I am using Phoenix 4.4 and HBase 1.0 (CDH 5.4.2).
> I am always seeing this error.This table not being written to during
> count(*) execution.
>
> Thanks,
> Baahu
>
> On Fri, Jul 17, 2015 at 10:27 PM, James Taylor <ja...@apache.org>
> wrote:
>
>> This exception means that the region boundary cache kept on the client is
>> out of sync with the actual region boundaries on the HBase table. When this
>> occurs, the query is retried once (after invalidating the cache). If it
>> happens a second time, the exception is thrown to the client.
>>
>> What version of Phoenix and HBase are you using? If you run the query a
>> second time, do you continue to see this error? Is the table being heavily
>> written to you when you execute the count(*) query?
>>
>> Thanks,
>> James
>>
>> On Wed, Jul 15, 2015 at 7:14 AM, Bahubali Jain <ba...@gmail.com>
>> wrote:
>>
>>> Hi,
>>> I am running into the below exception while running a count(*) query on
>>> a hbase table (created a view in phoenix)
>>> java.lang.RuntimeException:
>>> org.apache.phoenix.schema.StaleRegionBoundaryCacheException: ERROR 1108
>>> (XCL08): Cache of region boundaries are out of date.
>>> at sqlline.IncrementalRows.hasNext(IncrementalRows.java:73)
>>> at sqlline.TableOutputFormat.print(TableOutputFormat.java:33)
>>> at sqlline.SqlLine.print(SqlLine.java:1653)
>>> at sqlline.Commands.execute(Commands.java:833)
>>> at sqlline.Commands.sql(Commands.java:732)
>>> at sqlline.SqlLine.dispatch(SqlLine.java:808)
>>> at sqlline.SqlLine.begin(SqlLine.java:681)
>>> at sqlline.SqlLine.start(SqlLine.java:398)
>>> at sqlline.SqlLine.main(SqlLine.java:292)
>>>
>>> Can you please provide some inputs on this.
>>>
>>> Thanks,
>>> Baahu
>>>
>>>
>>>
>>
>
>
> --
> Twitter:http://twitter.com/Baahu
>
>
Re: StaleRegionBoundaryCacheException
Posted by Bahubali Jain <ba...@gmail.com>.
James,
I am using Phoenix 4.4 and HBase 1.0 (CDH 5.4.2).
I am always seeing this error.This table not being written to during
count(*) execution.
Thanks,
Baahu
On Fri, Jul 17, 2015 at 10:27 PM, James Taylor <ja...@apache.org>
wrote:
> This exception means that the region boundary cache kept on the client is
> out of sync with the actual region boundaries on the HBase table. When this
> occurs, the query is retried once (after invalidating the cache). If it
> happens a second time, the exception is thrown to the client.
>
> What version of Phoenix and HBase are you using? If you run the query a
> second time, do you continue to see this error? Is the table being heavily
> written to you when you execute the count(*) query?
>
> Thanks,
> James
>
> On Wed, Jul 15, 2015 at 7:14 AM, Bahubali Jain <ba...@gmail.com> wrote:
>
>> Hi,
>> I am running into the below exception while running a count(*) query on a
>> hbase table (created a view in phoenix)
>> java.lang.RuntimeException:
>> org.apache.phoenix.schema.StaleRegionBoundaryCacheException: ERROR 1108
>> (XCL08): Cache of region boundaries are out of date.
>> at sqlline.IncrementalRows.hasNext(IncrementalRows.java:73)
>> at sqlline.TableOutputFormat.print(TableOutputFormat.java:33)
>> at sqlline.SqlLine.print(SqlLine.java:1653)
>> at sqlline.Commands.execute(Commands.java:833)
>> at sqlline.Commands.sql(Commands.java:732)
>> at sqlline.SqlLine.dispatch(SqlLine.java:808)
>> at sqlline.SqlLine.begin(SqlLine.java:681)
>> at sqlline.SqlLine.start(SqlLine.java:398)
>> at sqlline.SqlLine.main(SqlLine.java:292)
>>
>> Can you please provide some inputs on this.
>>
>> Thanks,
>> Baahu
>>
>>
>>
>
--
Twitter:http://twitter.com/Baahu
Re: StaleRegionBoundaryCacheException
Posted by James Taylor <ja...@apache.org>.
This exception means that the region boundary cache kept on the client is
out of sync with the actual region boundaries on the HBase table. When this
occurs, the query is retried once (after invalidating the cache). If it
happens a second time, the exception is thrown to the client.
What version of Phoenix and HBase are you using? If you run the query a
second time, do you continue to see this error? Is the table being heavily
written to you when you execute the count(*) query?
Thanks,
James
On Wed, Jul 15, 2015 at 7:14 AM, Bahubali Jain <ba...@gmail.com> wrote:
> Hi,
> I am running into the below exception while running a count(*) query on a
> hbase table (created a view in phoenix)
> java.lang.RuntimeException:
> org.apache.phoenix.schema.StaleRegionBoundaryCacheException: ERROR 1108
> (XCL08): Cache of region boundaries are out of date.
> at sqlline.IncrementalRows.hasNext(IncrementalRows.java:73)
> at sqlline.TableOutputFormat.print(TableOutputFormat.java:33)
> at sqlline.SqlLine.print(SqlLine.java:1653)
> at sqlline.Commands.execute(Commands.java:833)
> at sqlline.Commands.sql(Commands.java:732)
> at sqlline.SqlLine.dispatch(SqlLine.java:808)
> at sqlline.SqlLine.begin(SqlLine.java:681)
> at sqlline.SqlLine.start(SqlLine.java:398)
> at sqlline.SqlLine.main(SqlLine.java:292)
>
> Can you please provide some inputs on this.
>
> Thanks,
> Baahu
>
>
>