phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From vishnu rao <jaihind...@gmail.com>
Subject Re: [while doing select] getting exception - ERROR 1108 (XCL08): Cache of region boundaries are out of date.
Date Mon, 09 May 2016 06:57:36 GMT
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 <ankitsinghal59@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 <jaihind213@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

Mime
View raw message