James, I have faced this issue with views, I created a view with around 260 columns in it, wonder if this has anything to do with the issue. I was able to access the data thru the view for few hours and then ran into the staleregionboundarycache exception. I observed this behavior twice. Would this info suffice in the JIRA?
Thanks, Baahu On Tue, Jul 21, 2015 at 3:33 AM, James Taylor <[email protected]> wrote: > Thanks for the information, Baahu. If you could figure out how to > reproduce this and file a JIRA, that would be much appreciated. > > James > > On Mon, Jul 20, 2015 at 1:34 AM, Bahubali Jain <[email protected]> wrote: > >> 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 >> >> > -- Twitter:http://twitter.com/Baahu
