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 <[email protected]> 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 <[email protected]> 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
