phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chetan Khatri <chetan.opensou...@gmail.com>
Subject Re: Error at starting Phoenix shell with HBase
Date Fri, 13 Jan 2017 14:51:36 GMT
Still I am getting Same Error

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


On Fri, Jan 13, 2017 at 8:06 PM, Chetan Khatri <chetan.opensource@gmail.com>
wrote:

> Mark, Thank you for reply. But command takes 20 mins to get response ?
>
> On Fri, Jan 13, 2017 at 7:40 PM, Mark Heppner <heppner.mark@gmail.com>
> wrote:
>
>> I think you need to start it with either of these:
>>     ./bin/sqlline.py localhost:2181:/hbase
>>     ./bin/sqlline.py localhost:2181:/hbase-unsecure
>>
>> On Fri, Jan 13, 2017 at 8:49 AM, Chetan Khatri <
>> chetan.opensource@gmail.com> 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.newE
>>> xception(SQLExceptionCode.java:455)
>>> at org.apache.phoenix.exception.SQLExceptionInfo.buildException
>>> (SQLExceptionInfo.java:145)
>>> at org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllT
>>> ableRegions(ConnectionQueryServicesImpl.java:546)
>>> at org.apache.phoenix.query.ConnectionQueryServicesImpl.checkCl
>>> ientServerCompatibility(ConnectionQueryServicesImpl.java:1162)
>>> at org.apache.phoenix.query.ConnectionQueryServicesImpl.ensureT
>>> ableCreated(ConnectionQueryServicesImpl.java:1068)
>>> at org.apache.phoenix.query.ConnectionQueryServicesImpl.createT
>>> able(ConnectionQueryServicesImpl.java:1388)
>>> at org.apache.phoenix.schema.MetaDataClient.createTableInternal
>>> (MetaDataClient.java:2298)
>>> at org.apache.phoenix.schema.MetaDataClient.createTable(MetaDat
>>> aClient.java:940)
>>> at org.apache.phoenix.compile.CreateTableCompiler$2.execute(Cre
>>> ateTableCompiler.java:193)
>>> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixState
>>> ment.java:344)
>>> at org.apache.phoenix.jdbc.PhoenixStatement$2.call(PhoenixState
>>> ment.java:332)
>>> at org.apache.phoenix.call.CallRunner.run(CallRunner.java:53)
>>> at org.apache.phoenix.jdbc.PhoenixStatement.executeMutation(Pho
>>> enixStatement.java:331)
>>> at org.apache.phoenix.jdbc.PhoenixStatement.executeUpdate(Phoen
>>> ixStatement.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(PhoenixC
>>> ontextExecutor.java:76)
>>> at org.apache.phoenix.query.ConnectionQueryServicesImpl.init(Co
>>> nnectionQueryServicesImpl.java:2291)
>>> at org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServ
>>> ices(PhoenixDriver.java:232)
>>> at org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnecti
>>> on(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(NativeMethodAcce
>>> ssorImpl.java:62)
>>> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMe
>>> thodAccessorImpl.java:43)
>>> at java.lang.reflect.Method.invoke(Method.java:498)
>>> at sqlline.ReflectiveCommandHandler.execute(ReflectiveCommandHa
>>> ndler.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$HConnection
>>> Implementation.locateRegionInMeta(ConnectionManager.java:1318)
>>> at org.apache.hadoop.hbase.client.ConnectionManager$HConnection
>>> Implementation.locateRegion(ConnectionManager.java:1181)
>>> at org.apache.hadoop.hbase.client.ConnectionManager$HConnection
>>> Implementation.relocateRegion(ConnectionManager.java:1152)
>>> at org.apache.hadoop.hbase.client.ConnectionManager$HConnection
>>> Implementation.relocateRegion(ConnectionManager.java:1136)
>>> at org.apache.hadoop.hbase.client.ConnectionManager$HConnection
>>> Implementation.getRegionLocation(ConnectionManager.java:957)
>>> at org.apache.phoenix.query.ConnectionQueryServicesImpl.getAllT
>>> ableRegions(ConnectionQueryServicesImpl.java:531)
>>> ... 32 more
>>> sqlline version 1.1.9
>>>
>>> Kindly let me know how to fix this error.
>>>
>>> Thanks,
>>>
>>>
>>>
>>
>>
>> --
>> Mark Heppner
>>
>
>

Mime
View raw message