phoenix-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From F21 <f21.gro...@gmail.com>
Subject Re: Can query server run with hadoop ha mode?
Date Thu, 08 Sep 2016 03:58:10 GMT
I have a test cluster running HDFS in HA mode with HBase + Phoenix on 
docker running successfully.

Can you check if you have a properly configured hbase-site.xml that is 
available to your phoenix query server? Make sure hbase.zookeeper.quorum 
and zookeeper.znode.parent is present. If zookeeper does not run on 
2181, you will also need hbase.zookeeper.property.clientPort.

As a quick test, can you wget or curl http://your-phoenix-server:8765 to 
see if it has any response? Finally, if you could post the logs from the 
query server, that would be great too.

Cheers,
Francis


On 8/09/2016 12:55 PM, zengbaitang wrote:
> I have a hadoop ha cluster and hbase, and  have installed phoenix.
>
> I try to use query server today , I start the queryserver and then I 
> exec the following command
>
> ./sqlline-thin.py http://tnode02:8765 sel.sql
>
> the terminal responds the following error , and the *stage-cluster*  
> is the value of  hadoop dfs.nameservices ,
> how to solve this error?
>
> AvaticaClientRuntimeException: Remote driver error: RuntimeException: 
> java.sql.SQLException: ERROR 103 (08004): Unable to establish 
> connection. -> SQLException: ERROR 103 (08004): Unable to establish 
> connection. -> IOException: 
> java.lang.reflect.InvocationTargetException -> 
> InvocationTargetException: (null exception message) -> 
> ExceptionInInitializerError: (null exception message) -> 
> IllegalArgumentException: java.net.UnknownHostException: stage-cluster 
> -> UnknownHostException: stage-cluster. Error -1 (00000) null
>
> java.lang.RuntimeException: java.sql.SQLException: ERROR 103 (08004): 
> Unable to establish connection.
>         at 
> org.apache.calcite.avatica.jdbc.JdbcMeta.openConnection(JdbcMeta.java:619)
>         at 
> org.apache.calcite.avatica.remote.LocalService.apply(LocalService.java:299)
>         at 
> org.apache.calcite.avatica.remote.Service$OpenConnectionRequest.accept(Service.java:1748)
>         at 
> org.apache.calcite.avatica.remote.Service$OpenConnectionRequest.accept(Service.java:1728)
>         at 
> org.apache.calcite.avatica.remote.AbstractHandler.apply(AbstractHandler.java:95)
>         at 
> org.apache.calcite.avatica.remote.ProtobufHandler.apply(ProtobufHandler.java:46)
>         at 
> org.apache.calcite.avatica.server.AvaticaProtobufHandler.handle(AvaticaProtobufHandler.java:124)
>         at 
> org.apache.phoenix.shaded.org.eclipse.jetty.server.handler.HandlerList.handle(HandlerList.java:52)
>         at 
> org.apache.phoenix.shaded.org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:97)
>         at 
> org.apache.phoenix.shaded.org.eclipse.jetty.server.Server.handle(Server.java:499)
>         at 
> org.apache.phoenix.shaded.org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:311)
>         at 
> org.apache.phoenix.shaded.org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:257)
>         at 
> org.apache.phoenix.shaded.org.eclipse.jetty.io.AbstractConnection$2.run(AbstractConnection.java:544)
>         at 
> org.apache.phoenix.shaded.org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:635)
>         at 
> org.apache.phoenix.shaded.org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:555)
>         at java.lang.Thread.run(Thread.java:745)
> Caused by: java.sql.SQLException: ERROR 103 (08004): Unable to 
> establish connection.
>         at 
> org.apache.phoenix.exception.SQLExceptionCode$Factory$1.newException(SQLExceptionCode.java:454)
>         at 
> org.apache.phoenix.exception.SQLExceptionInfo.buildException(SQLExceptionInfo.java:145)
>         at 
> org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:393)
>         at 
> org.apache.phoenix.query.ConnectionQueryServicesImpl.access$300(ConnectionQueryServicesImpl.java:219)
>         at 
> org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2321)
>         at 
> org.apache.phoenix.query.ConnectionQueryServicesImpl$13.call(ConnectionQueryServicesImpl.java:2300)
>         at 
> org.apache.phoenix.util.PhoenixContextExecutor.call(PhoenixContextExecutor.java:78)
>         at 
> org.apache.phoenix.query.ConnectionQueryServicesImpl.init(ConnectionQueryServicesImpl.java:2300)
>         at 
> org.apache.phoenix.jdbc.PhoenixDriver.getConnectionQueryServices(PhoenixDriver.java:231)
>         at 
> org.apache.phoenix.jdbc.PhoenixEmbeddedDriver.createConnection(PhoenixEmbeddedDriver.java:144)
>         at 
> org.apache.phoenix.jdbc.PhoenixDriver.connect(PhoenixDriver.java:202)
>         at java.sql.DriverManager.getConnection(DriverManager.java:664)
>         at java.sql.DriverManager.getConnection(DriverManager.java:208)
>         at 
> org.apache.calcite.avatica.jdbc.JdbcMeta.openConnection(JdbcMeta.java:616)
>         ... 15 more
> Caused by: java.io.IOException: 
> java.lang.reflect.InvocationTargetException
>         at 
> org.apache.hadoop.hbase.client.ConnectionFactory.createConnection(ConnectionFactory.java:240)
>         at 
> org.apache.hadoop.hbase.client.ConnectionManager.createConnection(ConnectionManager.java:421)
>         at 
> org.apache.hadoop.hbase.client.ConnectionManager.createConnectionInternal(ConnectionManager.java:330)
>         at 
> org.apache.hadoop.hbase.client.HConnectionManager.createConnection(HConnectionManager.java:144)
>         at 
> org.apache.phoenix.query.HConnectionFactory$HConnectionFactoryImpl.createConnection(HConnectionFactory.java:47)
>         at 
> org.apache.phoenix.query.ConnectionQueryServicesImpl.openConnection(ConnectionQueryServicesImpl.java:391)
>         ... 26 more
> Caused by: java.lang.reflect.InvocationTargetException
>         at 
> sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
>         at 
> sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
>         at 
> sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
>         at java.lang.reflect.Constructor.newInstance(Constructor.java:422)
>         at 
> org.apache.hadoop.hbase.client.ConnectionFactory.createConnection(ConnectionFactory.java:238)
>         ... 31 more
> Caused by: java.lang.ExceptionInInitializerError
>         at org.apache.hadoop.hbase.ClusterId.parseFrom(ClusterId.java:64)
>         at 
> org.apache.hadoop.hbase.zookeeper.ZKClusterId.readClusterIdZNode(ZKClusterId.java:75)
>         at 
> org.apache.hadoop.hbase.client.ZooKeeperRegistry.getClusterId(ZooKeeperRegistry.java:105)
>         at 
> org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.retrieveClusterId(ConnectionManager.java:880)
>         at 
> org.apache.hadoop.hbase.client.ConnectionManager$HConnectionImplementation.<init>(ConnectionManager.java:636)
>         ... 36 more
> Caused by: java.lang.IllegalArgumentException: 
> java.net.UnknownHostException: stage-cluster
>         at 
> org.apache.hadoop.security.SecurityUtil.buildTokenService(SecurityUtil.java:378)
>         at 
> org.apache.hadoop.hdfs.NameNodeProxies.createNonHAProxy(NameNodeProxies.java:310)
>         at 
> org.apache.hadoop.hdfs.NameNodeProxies.createProxy(NameNodeProxies.java:176)
>         at org.apache.hadoop.hdfs.DFSClient.<init>(DFSClient.java:678)
>         at org.apache.hadoop.hdfs.DFSClient.<init>(DFSClient.java:619)
>         at 
> org.apache.hadoop.hdfs.DistributedFileSystem.initialize(DistributedFileSystem.java:149)
>         at 
> org.apache.hadoop.fs.FileSystem.createFileSystem(FileSystem.java:2653)
>         at org.apache.hadoop.fs.FileSystem.access$200(FileSystem.java:92)
>         at 
> org.apache.hadoop.fs.FileSystem$Cache.getInternal(FileSystem.java:2687)
>         at org.apache.hadoop.fs.FileSystem$Cache.get(FileSystem.java:2669)
>         at org.apache.hadoop.fs.FileSystem.get(FileSystem.java:371)
>         at org.apache.hadoop.fs.Path.getFileSystem(Path.java:295)
>         at 
> org.apache.hadoop.hbase.util.DynamicClassLoader.initTempDir(DynamicClassLoader.java:118)
>         at 
> org.apache.hadoop.hbase.util.DynamicClassLoader.<init>(DynamicClassLoader.java:98)
>         at 
> org.apache.hadoop.hbase.protobuf.ProtobufUtil.<clinit>(ProtobufUtil.java:241)
>         ... 41 more
> Caused by: java.net.UnknownHostException: *stage-cluster*
>         ... 56 more
>
>
>         at 
> org.apache.calcite.avatica.remote.Service$ErrorResponse.toException(Service.java:2453)
>         at 
> org.apache.calcite.avatica.remote.RemoteProtobufService._apply(RemoteProtobufService.java:61)
>         at 
> org.apache.calcite.avatica.remote.ProtobufService.apply(ProtobufService.java:81)
>         at 
> org.apache.calcite.avatica.remote.Driver.connect(Driver.java:175)
>         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: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)
>         at 
> org.apache.phoenix.queryserver.client.SqllineWrapper.main(SqllineWrapper.java:83)
>
>


Mime
View raw message