James, I am using Phoenix 4.4 and HBase 1.0 (CDH 5.4.2). I am always seeing this error.This table not being written to during count(*) execution.
Thanks, Baahu On Fri, Jul 17, 2015 at 10:27 PM, James Taylor <[email protected]> wrote: > 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 >> >> >> > -- Twitter:http://twitter.com/Baahu
