phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ankit Singhal <ankitsingha...@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:49:09 GMT
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
>

Mime
View raw message