You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@phoenix.apache.org by vishnu rao <ja...@gmail.com> on 2016/05/09 05:26:50 UTC
[while doing select] getting exception - ERROR 1108 (XCL08): Cache of
region boundaries are out of date.
hi guys need help !
i was getting this exception while doing a select. hbase 1.1 with phoenix
4.6.
* SELECT * FROM EVENTS_PROD WHERE id = 100 AND ts IS NOT NULL AND ts
BETWEEN 1462492800000 AND 1462536000000 ORDER BY ts DESC;*
*------*
*7 days retention*
*150 regions*
*got this error suddenly - no code changes.*
*one solution is to truncate SYSTEM_STATS ? should i try it*
*------*
*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.SeparatedValuesOutputFormat.print(SeparatedValuesOutputFormat.java:31)*
*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)*
--
with regards,
ch Vishnu
mash213.wordpress.com
doodle-vishnu.blogspot.in
Re: [while doing select] getting exception - ERROR 1108 (XCL08):
Cache of region boundaries are out of date.
Posted by vishnu rao <ja...@gmail.com>.
Thanks Ankit.
i deleted stats for EVENTS_PROD and stats for any local indexes for that
table and it worked.
i.e. 'delete from system_stats'
On Mon, May 9, 2016 at 2:49 PM, Ankit Singhal <an...@gmail.com>
wrote:
> Yes Vishnu , you may be hitting
> https://issues.apache.org/jira/browse/PHOENIX-2249 so you can try
> deleting stats for the table "*EVENTS_PROD*'.
>
> On Mon, May 9, 2016 at 10:56 AM, vishnu rao <ja...@gmail.com> wrote:
>
>> hi guys need help !
>>
>> i was getting this exception while doing a select. hbase 1.1 with phoenix
>> 4.6.
>>
>> * SELECT * FROM EVENTS_PROD WHERE id = 100 AND ts IS NOT NULL AND ts
>> BETWEEN 1462492800000 AND 1462536000000 ORDER BY ts DESC;*
>>
>> *------*
>>
>> *7 days retention*
>>
>> *150 regions*
>>
>> *got this error suddenly - no code changes.*
>>
>> *one solution is to truncate SYSTEM_STATS ? should i try it*
>>
>> *------*
>>
>> *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.SeparatedValuesOutputFormat.print(SeparatedValuesOutputFormat.java:31)*
>>
>> *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)*
>>
>> --
>> with regards,
>> ch Vishnu
>> mash213.wordpress.com
>> doodle-vishnu.blogspot.in
>>
>
>
--
with regards,
ch Vishnu
mash213.wordpress.com
doodle-vishnu.blogspot.in
Re: [while doing select] getting exception - ERROR 1108 (XCL08):
Cache of region boundaries are out of date.
Posted by Ankit Singhal <an...@gmail.com>.
Yes Vishnu , you may be hitting
https://issues.apache.org/jira/browse/PHOENIX-2249 so you can try deleting
stats for the table "*EVENTS_PROD*'.
On Mon, May 9, 2016 at 10:56 AM, vishnu rao <ja...@gmail.com> wrote:
> hi guys need help !
>
> i was getting this exception while doing a select. hbase 1.1 with phoenix
> 4.6.
>
> * SELECT * FROM EVENTS_PROD WHERE id = 100 AND ts IS NOT NULL AND ts
> BETWEEN 1462492800000 AND 1462536000000 ORDER BY ts DESC;*
>
> *------*
>
> *7 days retention*
>
> *150 regions*
>
> *got this error suddenly - no code changes.*
>
> *one solution is to truncate SYSTEM_STATS ? should i try it*
>
> *------*
>
> *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.SeparatedValuesOutputFormat.print(SeparatedValuesOutputFormat.java:31)*
>
> *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)*
>
> --
> with regards,
> ch Vishnu
> mash213.wordpress.com
> doodle-vishnu.blogspot.in
>