[PHOENIX-1551] Upgrading from Phoenix 4.0.x to 4.2.2 and throw can't find SYSTEM.STATS

• Type: Bug
• Status: Closed
• Priority: Blocker
• Resolution: Fixed
• Affects Version/s: 4.2.2
• Fix Version/s: 4.3.0, 4.2.3
• Labels: Upgrading

Environment

hbase 0.96.1.1 cdh5.0.2

• Assignee: Jeffrey Zhong
• Reporter: Feng
• Created: 23/Dec/14 02:06
• Updated: 21/Nov/15 02:15
• Resolved: 12/Jan/15 23:14

Description

I download phoenix-4.2.2-bin.tar.gz and put phoenix-4.2.2-server.jar into the HBase lib directory and remove any phoenix-4.0.jar,restart hbase
When I used bin/sqlline.py to connection phoenix throw

Error: org.apache.hadoop.hbase.DoNotRetryIOException: SYSTEM.CATALOG: org.apache.hadoop.hbase.TableNotFoundException: SYSTEM.STATS
at org.apache.phoenix.util.ServerUtil.createIOException(ServerUtil.java:84)
at org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:794)
at org.apache.phoenix.coprocessor.generated.MetaDataProtos$MetaDataService.callMethod(MetaDataProtos.java:7763)
at org.apache.hadoop.hbase.regionserver.HRegion.execService(HRegion.java:5296)
at org.apache.hadoop.hbase.regionserver.HRegionServer.execService(HRegionServer.java:3205)
at org.apache.hadoop.hbase.protobuf.generated.ClientProtos$ClientService$2.callBlockingMethod(ClientProtos.java:26933)
at org.apache.hadoop.hbase.ipc.RpcServer.call(RpcServer.java:2175)
at org.apache.hadoop.hbase.ipc.RpcServer$Handler.run(RpcServer.java:1879)
Caused by: java.lang.RuntimeException: org.apache.hadoop.hbase.TableNotFoundException: SYSTEM.STATS
at org.apache.hadoop.hbase.client.HTableFactory.createHTableInterface(HTableFactory.java:41)
at org.apache.hadoop.hbase.client.HTablePool.createHTable(HTablePool.java:271)
at org.apache.hadoop.hbase.client.HTablePool.findOrCreateTable(HTablePool.java:201)
at org.apache.hadoop.hbase.client.HTablePool.getTable(HTablePool.java:180)
at org.apache.hadoop.hbase.client.HTablePool.getTable(HTablePool.java:219)
at org.apache.phoenix.util.ServerUtil.getTableFromSingletonPool(ServerUtil.java:151)
at org.apache.phoenix.util.ServerUtil.getHTableForCoprocessorScan(ServerUtil.java:165)
at org.apache.phoenix.coprocessor.MetaDataEndpointImpl.getTable(MetaDataEndpointImpl.java:609)
at org.apache.phoenix.coprocessor.MetaDataEndpointImpl.buildTable(MetaDataEndpointImpl.java:359)
at org.apache.phoenix.coprocessor.MetaDataEndpointImpl.loadTable(MetaDataEndpointImpl.java:665)
at org.apache.phoenix.coprocessor.MetaDataEndpointImpl.createTable(MetaDataEndpointImpl.java:743)
... 6 more
Caused by: org.apache.hadoop.hbase.TableNotFoundException: SYSTEM.STATS
at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegionInMeta(HConnectionManager.java:1181)
at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegion(HConnectionManager.java:1054)
at org.apache.hadoop.hbase.client.HConnectionManager$HConnectionImplementation.locateRegion(HConnectionManager.java:1011)
at org.apache.hadoop.hbase.client.HTable.finishSetup(HTable.java:326)
at org.apache.hadoop.hbase.client.HTable.<init>(HTable.java:192)
at org.apache.hadoop.hbase.client.HTable.<init>(HTable.java:165)
at org.apache.hadoop.hbase.client.HTableFactory.createHTableInterface(HTableFactory.java:39)
... 16 more (state=08000,code=101)