Hi , Since you have just reset HBase, see if the table name 'SYSTEM.CATALOG' exists as a znode in zookeeper path /hbase/tables/ . If so, you can do a rmr from the zookeeper shell.
Hope it helps. Regards On Mon, Sep 21, 2015 at 8:48 AM, Konstantinos Kougios < [email protected]> wrote: > in the hbase master log I notice: > > 2015-09-21 14:45:49,569 WARN [ProcedureExecutorThread-10] > procedure.CreateTableProcedure: The table SYSTEM.CATALOG does not exist in > meta but has a znode. run hbck to fix inconsistencies. > > I run > > hbase hbck -fix > > but still getting the same error when running sqlline.py > > > > On 21/09/15 14:29, Konstantinos Kougios wrote: > > Hi all, I got an installation of hbase-1.1.2 + phoenix-4.5.1. I reset > hbase by removing the /hbase folder from hdfs (hadoop fs -rm -r -f /hbase) > and restarted hbase. Now hbase works fine but for phoenix I am getting the > exception below. I suppose this is due to the system catalog table been > removed along with the hbase folder. But phoenix didn't recreate it during > hbase startup. How can I force the recreation of phoenix schema tables? > > Thanks > > > sqlline.py nn.lan > Setting property: [isolation, TRANSACTION_READ_COMMITTED] > issuing: !connect jdbc:phoenix:nn.lan none none > org.apache.phoenix.jdbc.PhoenixDriver > Connecting to jdbc:phoenix:nn.lan > 15/09/21 14:18:59 WARN util.NativeCodeLoader: Unable to load native-hadoop > library for your platform... using builtin-java classes where applicable > 15/09/21 14:19:00 WARN impl.MetricsConfig: Cannot locate configuration: > tried hadoop-metrics2-phoenix.properties,hadoop-metrics2.properties > Error: SYSTEM.CATALOG (state=08000,code=101) > *org.apache.phoenix.exception.PhoenixIOException: SYSTEM.CATALOG* > at > org.apache.phoenix.util.ServerUtil.parseServerException(ServerUtil.java:108) > at > org.apache.phoenix.query.ConnectionQueryServicesImpl.metaDataCoprocessorExec(ConnectionQueryServicesImpl.java:1051) > at > org.apache.phoenix.query.ConnectionQueryServicesImpl.metaDataCoprocessorExec(ConnectionQueryServicesImpl.java:1014) > at > org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1259) > at > org.apache.phoenix.query.DelegateConnectionQueryServices.createTable(DelegateConnectionQueryServices.java:113) > at > org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:1937) > at > org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:751) > at > org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:186) > at > org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:319) > at > org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:311) > at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53) > at > org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:309) > at > org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1421) > at > org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1927) > at > org.apache.phoenix.query.ConnectionQueryServicesImpl$12.call(ConnectionQueryServicesImpl.java:1896) > at > org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:77) > at > org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:1896) > at > org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:180) > at > org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.connect(PhoenixEmbeddedDriver.java:132) > at > org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:151) > at sqlline.DatabaseConnection.connect(DatabaseConnection.java:157) > at > sqlline.DatabaseConnection.getConnection(DatabaseConnection.java:203) > at sqlline.Commands.connect(Commands.java:1064) > at sqlline.Commands.connect(Commands.java:996) > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > at > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.lang.reflect.Method.invoke(Method.java:497) > at > sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36) > at sqlline.SqlLine.dispatch(SqlLine.java:804) > at sqlline.SqlLine.initArgs(SqlLine.java:588) > at sqlline.SqlLine.begin(SqlLine.java:656) > at sqlline.SqlLine.start(SqlLine.java:398) > at sqlline.SqlLine.main(SqlLine.java:292) > Caused by: org.apache.hadoop.hbase.TableNotFoundException: SYSTEM.CATALOG > at > org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegionInMeta(ConnectionManager.java:1257) > at > org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegion(ConnectionManager.java:1155) > at > org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegion(ConnectionManager.java:1139) > at > org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegion(ConnectionManager.java:1096) > at > org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.getRegionLocation(ConnectionManager.java:931) > at > org.apache.hadoop.hbase.client.HRegionLocator.getRegionLocation(HRegionLocator.java:83) > at > org.apache.hadoop.hbase.client.HTable.getRegionLocation(HTable.java:496) > at > org.apache.hadoop.hbase.client.HTable.getKeysAndRegionsInRange(HTable.java:736) > at > org.apache.hadoop.hbase.client.HTable.getKeysAndRegionsInRange(HTable.java:706) > at > org.apache.hadoop.hbase.client.HTable.getStartKeysInRange(HTable.java:1760) > at > org.apache.hadoop.hbase.client.HTable.coprocessorService(HTable.java:1715) > at > org.apache.hadoop.hbase.client.HTable.coprocessorService(HTable.java:1695) > at > org.apache.phoenix.query.ConnectionQueryServicesImpl.metaDataCoprocessorExec(ConnectionQueryServicesImpl.java:1034) > > >
