Hello everyone, while creating an index on my Phoenix table:
CREATE LOCAL INDEX idx_media_next_update_at ON media (next_metadata_update_at); I'm getting an exception every time the command is run, after it's been running for a while: *Error: ERROR 1108 (XCL08): Cache of region boundaries are out of date. (state=XCL08,code=1108)* org.apache.phoenix.schema.StaleRegionBoundaryCacheException: ERROR 1108 (XCL08): Cache of region boundaries are out of date. at org.apache.phoenix.exception.SQLExceptionCode$13.newException(SQLExceptionCode.java:312) at org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145) at org.apache.phoenix.util.ServerUtil.parseRemoteException(ServerUtil.java:131) at org.apache.phoenix.util.ServerUtil.parseServerExceptionOrNull(ServerUtil.java:115) at org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:104) at org.apache.phoenix.iterate.BaseResultIterators.getIterators(BaseResultIterators.java:611) at org.apache.phoenix.iterate.ConcatResultIterator.getIterators(ConcatResultIterator.java:50) at org.apache.phoenix.iterate.ConcatResultIterator.currentIterator(ConcatResultIterator.java:97) at org.apache.phoenix.iterate.ConcatResultIterator.next(ConcatResultIterator.java:117) at org.apache.phoenix.iterate.BaseGroupedAggregatingResultIterator.next(BaseGroupedAggregatingResultIterator.java:64) at org.apache.phoenix.iterate.UngroupedAggregatingResultIterator.next(UngroupedAggregatingResultIterator.java:39) at org.apache.phoenix.schema.MetaDataClient$2.execute(MetaDataClient.java:1034) at org.apache.phoenix.query.ConnectionQueryServicesImpl.updateData(ConnectionQueryServicesImpl.java:2132) at org.apache.phoenix.schema.MetaDataClient.buildIndex(MetaDataClient.java:1059) at org.apache.phoenix.schema.MetaDataClient.createIndex(MetaDataClient.java:1348) at org.apache.phoenix.compile.CreateIndexCompiler$1.execute(CreateIndexCompiler.java:95) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:322) at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:314) at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:313) at org.apache.phoenix.jdbc.PhoenixStatement.execute(PhoenixStatement.java:1435) at sqlline.Commands.execute(Commands.java:822) Any suggestions why this is happening? When the command is running, nothing else is accessing HBase, so there should be no reason for splitting regions. I'm using Phoenix 4.6.0-HBase-1.1. Creating a global index (i.e., removing the LOCAL keyword) leads to the same result. Actually, we're getting this error on many other queries that use scans and run for some longer period of time (i.e., more that a few seconds). Can this be an indication that there is something wrong with the underlying HBase cluster? Some corruption or misconfiguration? hbck reports the tables as healthy and there is no other indication that something might be wrong. Jarda Snajdr
