This exception means that the region boundary cache kept on the client is out of sync with the actual region boundaries on the HBase table. When this occurs, the query is retried once (after invalidating the cache). If it happens a second time, the exception is thrown to the client.
What version of Phoenix and HBase are you using? If you run the query a second time, do you continue to see this error? Is the table being heavily written to you when you execute the count(*) query? Thanks, James On Wed, Jul 15, 2015 at 7:14 AM, Bahubali Jain <[email protected]> wrote: > Hi, > I am running into the below exception while running a count(*) query on a > hbase table (created a view in phoenix) > 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.TableOutputFormat.print(TableOutputFormat.java:33) > 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) > > Can you please provide some inputs on this. > > Thanks, > Baahu > > >
