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