phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Josh Elser <els...@apache.org>
Subject Re: Error at starting Phoenix shell with HBase
Date Mon, 16 Jan 2017 16:52:27 GMT
Did you check the RegionServers logs I asked in the last message?

Chetan Khatri wrote:
> Any updates for the above error guys ?
>
>
> On Fri, Jan 13, 2017 at 9:35 PM, Josh Elser <elserj@apache.org
> <mailto:elserj@apache.org>> wrote:
>
>     (-cc dev@phoenix)
>
>     phoenix-4.8.2-HBase-1.2-server.jar in the top-level binary tarball
>     of Apache Phoenix 4.8.0 is the jar which is meant to be deployed to
>     all HBase's classpath.
>
>     I would check the RegionServer logs -- I'm guessing that it never
>     started correctly or failed. The error message is saying that
>     certain regions in the system were never assigned to a RegionServer
>     which only happens in exceptional cases.
>
>     Chetan Khatri wrote:
>
>         Hello Community,
>
>         I have installed and configured Apache Phoenix on Single Node
>         Ubuntu 16.04
>         machine:
>         - Hadoop 2.7
>         - HBase 1.2.4
>         - Phoenix -4.8.2-HBase-1.2
>
>         Copied phoenix-core-4.8.2-HBase-1.2.jar to hbase/lib and confirmed
>         with bin/hbase classpath | grep 'phoenix' and I am using embedded
>         zookeeper, so my hbase-site.xml looks like below:
>
>         <configuration>
>         <property>
>         <name>hbase.rootdir</name>
>         <value>file:///home/hduser/hbase</value>
>         </property>
>         </configuration>
>
>         I am able to read / write to HBase from shell and Apache Spark.
>
>         *Errors while accessing with **sqlline**:*
>
>
>         1) bin/sqlline.py localhost:2181
>
>         Error:
>
>         1. Command made process hang.
>         2.
>         Error: ERROR 1102 (XCL02): Cannot get all table regions.
>         (state=XCL02,code=1102)
>         java.sql.SQLException: ERROR 1102 (XCL02): Cannot get all table
>         regions.
>         at
>         org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:455)
>         at
>         org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
>         at
>         org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllTableRegions(ConnectionQueryServicesImpl.java:546)
>         at
>         org.apache.phoenix.query.ConnectionQueryServicesImpl.checkClientServerCompatibility(ConnectionQueryServicesImpl.java:1162)
>         at
>         org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureTableCreated(ConnectionQueryServicesImpl.java:1068)
>         at
>         org.apache.phoenix.query.ConnectionQueryServicesImpl.createTable(ConnectionQueryServicesImpl.java:1388)
>         at
>         org.apache.phoenix.schema.MetaDataClient.createTableInternal(MetaDataClient.java:2298)
>         at
>         org.apache.phoenix.schema.MetaDataClient.createTable(MetaDataClient.java:940)
>         at
>         org.apache.phoenix.compile.CreateTableCompiler$2.execute(CreateTableCompiler.java:193)
>         at
>         org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:344)
>         at
>         org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixStatement.java:332)
>         at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>         at
>         org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(PhoenixStatement.java:331)
>         at
>         org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(PhoenixStatement.java:1423)
>         at
>         org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2352)
>         at
>         org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2291)
>         at
>         org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:76)
>         at
>         org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2291)
>         at
>         org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:232)
>         at
>         org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:147)
>         at
>         org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:202)
>         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:498)
>         at
>         sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHandler.java:36)
>         at sqlline.SqlLine.dispatch(SqlLine.java:803)
>         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.client.NoServerForRegionException: No
>         server address listed in hbase:meta for region
>         SYSTEM.CATALOG,,1484293041241.0b74311f417f83abe84ae1be4e823de8.
>         containing
>         row
>         at
>         org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegionInMeta(ConnectionManager.java:1318)
>         at
>         org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.locateRegion(ConnectionManager.java:1181)
>         at
>         org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.relocateRegion(ConnectionManager.java:1152)
>         at
>         org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.relocateRegion(ConnectionManager.java:1136)
>         at
>         org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.getRegionLocation(ConnectionManager.java:957)
>         at
>         org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllTableRegions(ConnectionQueryServicesImpl.java:531)
>         ... 32 more
>         sqlline version 1.1.9
>
>         Kindly let me know how to fix this error.
>
>         Thanks,
>
>

Mime
View raw message