Hi,
I have found the root cause of the issue,
******************************
Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to
address=(host=149.165.169.159)(port=3306)(type=master) : Connection timed out
(Connection timed out)
at
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.get(ExceptionMapper.java:156)
at
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.getException(ExceptionMapper.java:118)
at
org.mariadb.jdbc.internal.util.exceptions.ExceptionMapper.throwException(ExceptionMapper.java:92)
at org.mariadb.jdbc.Driver.connect(Driver.java:111)
at java.sql.DriverManager.getConnection(DriverManager.java:664)
at java.sql.DriverManager.getConnection(DriverManager.java:270)
at
org.apache.airavata.credential.store.store.impl.util.ConnectionPool.makeNewConnection(ConnectionPool.java:188)
at
org.apache.airavata.credential.store.store.impl.util.ConnectionPool.initialize(ConnectionPool.java:125)
at
org.apache.airavata.credential.store.store.impl.util.ConnectionPool.<init>(ConnectionPool.java:88)
at
org.apache.airavata.credential.store.store.impl.util.JdbcStorage.<init>(JdbcStorage.java:39)
... 6 common frames omitted
Caused by: java.sql.SQLException: Could not connect to
address=(host=149.165.169.159)(port=3306)(type=master) : Connection timed out
(Connection timed out)
at
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1029)
at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:483)
at org.mariadb.jdbc.Driver.connect(Driver.java:106)
... 12 common frames omitted
Caused by: java.net.ConnectException: Connection timed out (Connection timed
out)
at java.net.PlainSocketImpl.socketConnect(Native Method)
at
java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
at
java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
at
java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
at java.net.Socket.connect(Socket.java:589)
at java.net.Socket.connect(Socket.java:538)
at
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:401)
at
org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1022)
... 14 common frames omitted
******************************
So to resolve this issue, I tried to open the port 3306 through firewalld,
[email protected] bin]# sudo firewall-cmd --zone=public
--add-port=3306/tcp --permanent && sudo firewall-cmd --reload
Status:
sudo firewall-cmd --list-all
public
target: default
icmp-block-inversion: no
interfaces:
sources:
services: dhcpv6-client ssh http https
ports: 443/tcp 3306/tcp 8008/tcp 8080/tcp 8962/tcp 9930/tcp 22/tcp 2181/tcp
5672/tcp 15672/tcp 8950/tcp 8930/tcp 8940/tcp 8960/tcp 8970/tcp 8443/tcp
protocols:
masquerade: no
forward-ports:
source-ports:
icmp-blocks:
rich rules:
Stopped and re-ran the airavata and gfac server. But still the issue persists.
Thanks.
Prashant
________________________________________
From: Modak, Prashant Kumar
Sent: Monday, October 29, 2018 3:34 PM
To: [email protected]
Subject: error while trying to run airavata server
Hi,
While trying to run the airavata server, I have got the following error message:
********************
[INFO] Server Arguments:
/home/pga/master-deployment/gfac-instance/logs/output.log
[INFO] Starting
[ERROR] Server Start Error:
org.apache.airavata.common.exception.AiravataStartupException: Gfac Server
Initialization error
at
org.apache.airavata.gfac.server.GfacServerHandler.<init>(GfacServerHandler.java:98)
at org.apache.airavata.gfac.server.GfacServer.start(GfacServer.java:101)
at
org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:372)
at
org.apache.airavata.server.ServerMain.performServerStart(ServerMain.java:221)
at org.apache.airavata.server.ServerMain.main(ServerMain.java:206)
Caused by: org.apache.zookeeper.KeeperException$ConnectionLossException:
KeeperErrorCode = ConnectionLoss for /servers
at org.apache.zookeeper.KeeperException.create(KeeperException.java:99)
at org.apache.zookeeper.KeeperException.create(KeeperException.java:51)
at org.apache.zookeeper.ZooKeeper.exists(ZooKeeper.java:1003)
at org.apache.zookeeper.ZooKeeper.exists(ZooKeeper.java:1031)
at org.apache.curator.utils.ZKPaths.mkdirs(ZKPaths.java:215)
at org.apache.curator.utils.ZKPaths.mkdirs(ZKPaths.java:164)
at
org.apache.airavata.gfac.server.GfacServerHandler.initZkDataStructure(GfacServerHandler.java:124)
at
org.apache.airavata.gfac.server.GfacServerHandler.<init>(GfacServerHandler.java:94)
... 4 common frames omitted
********************
I ran the following two scripts:
go to
/home/pga/master-deployment/api-orchestrator/apache-airavata-server-<version>-SNAPSHOT/bin
and run ./airavata-server-start.sh -d api-orch
go to
/home/pga/master-deployment/gfac-instance/apache-airavata-server-<version>-SNAPSHOT/bin
and run ./airavata-server-start.sh -d gfac
Thanks.
Prashant
