phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Konstantinos Kougios <kostas.koug...@googlemail.com>
Subject Re: org.apache.hadoop.hbase.TableNotFoundException: SYSTEM.CATALOG
Date Mon, 21 Sep 2015 13:48:23 GMT
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)


Mime
View raw message