首页 文章

松鼠客户端连接到凤凰城 - 超时例外

提问于
浏览
5

我想通过Squirrel客户端连接到Phoenix . 我在Squirrel日志中收到以下日志 . 日志表明已 Build 到zooperkeeper的ClientConnection,但是当使用Timeout异常 Build SQLClient连接时,它会失败 .

我已将凤凰客户端jar复制到Squirrel的lib目录中,并且驱动程序已成功注册 . 此外,当我在localhost中运行SQLLine.py实用程序时,它会成功地将SQL命令行加载到Phoenix,我可以运行命令 . 还将凤凰核心jar添加到$ HBASE_HOME / lib文件夹中 .

2015-06-15 12:48:53,766 [pool-7-thread-1] INFO  org.apache.hadoop.hbase.zookeeper.RecoverableZooKeeper  - Process identifier=hconnection-0x776a1002 connecting to ZooKeeper ensemble=10.58.126.245:2181
2015-06-15 12:48:53,766 [pool-7-thread-1] INFO  org.apache.zookeeper.ZooKeeper  - Initiating client connection, connectString=10.58.126.245:2181 sessionTimeout=90000 watcher=hconnection-0x776a10020x0, quorum=10.58.126.245:2181, baseZNode=/hbase
2015-06-15 12:48:58,287 [pool-7-thread-1-SendThread(10.58.126.245:2181)] INFO  org.apache.zookeeper.ClientCnxn  - Opening socket connection to server 10.58.126.245/10.58.126.245:2181. Will not attempt to authenticate using SASL (unknown error)
2015-06-15 12:48:58,301 [pool-7-thread-1-SendThread(10.58.126.245:2181)] INFO  org.apache.zookeeper.ClientCnxn  - Socket connection established to 10.58.126.245/10.58.126.245:2181, initiating session
2015-06-15 12:48:58,314 [pool-7-thread-1-SendThread(10.58.126.245:2181)] INFO  org.apache.zookeeper.ClientCnxn  - Session establishment complete on server 10.58.126.245/10.58.126.245:2181, sessionid = 0x14df5b87b120040, negotiated timeout = 90000
2015-06-15 12:49:58,100 [pool-7-thread-1] INFO  org.apache.hadoop.hbase.client.RpcRetryingCaller  - Call exception, tries=10, retries=35, started=59774 ms ago, cancelled=false, msg=
2015-06-15 12:50:20,456 [pool-7-thread-1] INFO  org.apache.hadoop.hbase.client.RpcRetryingCaller  - Call exception, tries=11, retries=35, started=82130 ms ago, cancelled=false, msg=
2015-06-15 12:50:36,114 [AWT-EventQueue-1] ERROR net.sourceforge.squirrel_sql.client.gui.db.ConnectToAliasCallBack  - Unexpected Error occurred attempting to open an SQL connection.
java.util.concurrent.TimeoutException
    at java.util.concurrent.FutureTask.get(FutureTask.java:201)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.awaitConnection(OpenConnectionCommand.java:132)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand.access$100(OpenConnectionCommand.java:45)
    at net.sourceforge.squirrel_sql.client.mainframe.action.OpenConnectionCommand$2.run(OpenConnectionCommand.java:115)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:744)

1 回答

  • 2

    我有同样的问题,还没有找到解决方案,但我设法使用“瘦”客户端代替 .

    • 启动queryserver https://phoenix.apache.org/server.html应该侦听端口8765

    • 将JAR phoenix-4.6.0-HBase-1.1-thin-client复制到Squirel lib文件夹

    • 创建新驱动程序,类名为“org.apache.phoenix.queryserver.client.Driver”

    • 用这个驱动程序连接(我的URI:jdbc:phoenix:thin:url = http://docker:8765

相关问题