Hi Vivek, I feel this is a different issue. I have attached the StackTrace as well. Please let me know if you think it is similar.
Thanks, Bhakti From: Bandaru, Vivek Shresta<mailto:vivb...@iu.edu> Sent: Wednesday, May 13, 2020 12:04 PM To: dev@airavata.apache.org<mailto:dev@airavata.apache.org> Subject: Re: [External] Re: Airavata database connection issue Hi Bhakti, This looks very similar to the database connection error a couple of us faced few weeks ago. Without the full stacktrace I can't say for sure, but you can try the fix mentioned in this mail: https://markmail.org/message/oojdzfmczss2gepr?q=Airavata+database+connection+error+while+starting Regards, Vivek. From: "Narvekar, Bhakti Sunil" <bhn...@iu.edu> Reply-To: "dev@airavata.apache.org" <dev@airavata.apache.org> Date: Wednesday, May 13, 2020 at 11:52 AM To: "dev@airavata.apache.org" <dev@airavata.apache.org> Subject: RE: [External] Re: Airavata database connection issue Hi Aarushi, The services are up and running. I have attached the screenshots for the same. The localhost:13306 is reachable but localhost:3306 is not. I have attached the result of the telnet for both the ports 3306 and 13306. Also, I have MySQL server installed on my local machine, would that be an issue. Thanks & Regards, Bhakti Narvekar From: Bisht, Aarushi<mailto:abi...@iu.edu> Sent: Wednesday, May 13, 2020 4:15 AM To: dev@airavata.apache.org<mailto:dev@airavata.apache.org> Subject: RE: [External] Re: Airavata database connection issue Hi Bhakti, >From the logs it seems you are not able to connect to database on localhost: >13306. Make sure db container is up and running. Try using nc or some other command to make sure that you are able to connect to this port. - Aarushi Bisht On May 13, 2020 12:05 AM, "Narvekar, Bhakti Sunil" <bhn...@iu.edu> wrote: Hi Akhil, Yes, I tried deleting the ide-integration/resources/database_data folder, stopping all the services, and restarting them again. But I'm still facing this issue. Regards, Bhakti From: akhil nagulavancha<mailto:akhilnl...@gmail.com> Sent: Tuesday, May 12, 2020 9:43 PM To: dev@airavata.apache.org<mailto:dev@airavata.apache.org> Subject: [External] Re: Airavata database connection issue This message was sent from a non-IU address. Please exercise caution when clicking links or opening attachments from external sources. Hi Bhakti , Did you try the note mentioned in start airavata server step of cwiki ? It has helped me to solve a similar database related error. Regards Akhil On Tue, May 12, 2020 at 8:41 PM Narvekar, Bhakti Sunil <bhn...@iu.edu<mailto:bhn...@iu.edu>> wrote: Hi, On starting APIServerStarter, I ran into an exception - SQLNonTransientConnectionException. I have attached the StackTrace and database logs. Could anyone please help me with this issue. Thanks & Regards, Bhakti Narvekar
"C:\Program Files\Java\jdk-12.0.2\bin\java.exe" "-javaagent:C:\Program Files\JetBrains\IntelliJ IDEA 2019.2.4\lib\idea_rt.jar=50929:C:\Program Files\JetBrains\IntelliJ IDEA 2019.2.4\bin" -Dfile.encoding=UTF-8 -classpath D:\Airavata\airavata\modules\ide-integration\target\classes;D:\Airavata\airavata\modules\db-event-manager\target\classes;D:\Airavata\airavata\modules\commons\target\classes;C:\Users\Bhakti\.m2\repository\org\ogce\xpp3\1.1.6\xpp3-1.1.6.jar;C:\Users\Bhakti\.m2\repository\jakarta-regexp\jakarta-regexp\1.4\jakarta-regexp-1.4.jar;C:\Users\Bhakti\.m2\repository\org\ogce\xpp5\1.2.8\xpp5-1.2.8.jar;C:\Users\Bhakti\.m2\repository\org\apache\commons\commons-pool2\2.7.0\commons-pool2-2.7.0.jar;C:\Users\Bhakti\.m2\repository\com\google\guava\guava\20.0\guava-20.0.jar;C:\Users\Bhakti\.m2\repository\org\apache\derby\derby\10.13.1.1\derby-10.13.1.1.jar;C:\Users\Bhakti\.m2\repository\org\apache\derby\derbyclient\10.13.1.1\derbyclient-10.13.1.1.jar;C:\Users\Bhakti\.m2\repository\org\apache\derby\derbytools\10.13.1.1\derbytools-10.13.1.1.jar;C:\Users\Bhakti\.m2\repository\org\apache\tomcat\embed\tomcat-embed-core\7.0.22\tomcat-embed-core-7.0.22.jar;C:\Users\Bhakti\.m2\repository\commons-cli\commons-cli\1.2\commons-cli-1.2.jar;C:\Users\Bhakti\.m2\repository\junit\junit\4.12\junit-4.12.jar;C:\Users\Bhakti\.m2\repository\org\hamcrest\hamcrest-core\1.3\hamcrest-core-1.3.jar;C:\Users\Bhakti\.m2\repository\com\google\code\gson\gson\2.3\gson-2.3.jar;C:\Users\Bhakti\.m2\repository\ch\qos\logback\logback-classic\1.2.3\logback-classic-1.2.3.jar;D:\Airavata\airavata\airavata-api\airavata-base-api\target\classes;C:\Users\Bhakti\.m2\repository\javax\xml\bind\jaxb-api\2.4.0-b180830.0359\jaxb-api-2.4.0-b180830.0359.jar;C:\Users\Bhakti\.m2\repository\javax\activation\javax.activation-api\1.2.0\javax.activation-api-1.2.0.jar;D:\Airavata\airavata\modules\messaging\core\target\classes;C:\Users\Bhakti\.m2\repository\com\rabbitmq\amqp-client\3.5.1\amqp-client-3.5.1.jar;D:\Airavata\airavata\modules\registry\registry-server\registry-api-service\target\classes;D:\Airavata\airavata\airavata-api\airavata-data-models\target\classes;C:\Users\Bhakti\.m2\repository\javax\annotation\javax.annotation-api\1.3.2\javax.annotation-api-1.3.2.jar;D:\Airavata\airavata\modules\registry\registry-server\registry-api-stubs\target\classes;D:\Airavata\airavata\modules\registry\registry-cpi\target\classes;C:\Users\Bhakti\.m2\repository\org\apache\thrift\libthrift\0.10.0\libthrift-0.10.0.jar;C:\Users\Bhakti\.m2\repository\org\apache\httpcomponents\httpcore\4.4.1\httpcore-4.4.1.jar;D:\Airavata\airavata\modules\registry\registry-core\target\classes;C:\Users\Bhakti\.m2\repository\org\apache\ibatis\ibatis-sqlmap\2.3.0\ibatis-sqlmap-2.3.0.jar;D:\Airavata\airavata\modules\sharing-registry\sharing-registry-stubs\target\classes;D:\Airavata\airavata\modules\credential-store\credential-store-service\target\classes;D:\Airavata\airavata\modules\credential-store\credential-store-stubs\target\classes;C:\Users\Bhakti\.m2\repository\edu\uiuc\ncsa\myproxy\oa4mp-client-api\1.1.3\oa4mp-client-api-1.1.3.jar;C:\Users\Bhakti\.m2\repository\edu\uiuc\ncsa\security\delegation\ncsa-security-delegation-client\1.1.3\ncsa-security-delegation-client-1.1.3.jar;C:\Users\Bhakti\.m2\repository\edu\uiuc\ncsa\security\ncsa-security-util\1.1.3\ncsa-security-util-1.1.3.jar;C:\Users\Bhakti\.m2\repository\edu\uiuc\ncsa\security\delegation\ncsa-security-delegation-common\1.1.3\ncsa-security-delegation-common-1.1.3.jar;C:\Users\Bhakti\.m2\repository\edu\uiuc\ncsa\security\ncsa-security-storage\1.1.3\ncsa-security-storage-1.1.3.jar;C:\Users\Bhakti\.m2\repository\edu\uiuc\ncsa\security\ncsa-security-servlet\1.1.3\ncsa-security-servlet-1.1.3.jar;C:\Users\Bhakti\.m2\repository\edu\uiuc\ncsa\security\ncsa-security-core\1.1.3\ncsa-security-core-1.1.3.jar;C:\Users\Bhakti\.m2\repository\commons-configuration\commons-configuration\1.7\commons-configuration-1.7.jar;C:\Users\Bhakti\.m2\repository\commons-digester\commons-digester\1.8.1\commons-digester-1.8.1.jar;C:\Users\Bhakti\.m2\repository\edu\uiuc\ncsa\myproxy\oa4mp-client-loader-oauth1\1.1.3\oa4mp-client-loader-oauth1-1.1.3.jar;C:\Users\Bhakti\.m2\repository\edu\uiuc\ncsa\myproxy\myproxy-logon\1.7\myproxy-logon-1.7.jar;C:\Users\Bhakti\.m2\repository\edu\uiuc\ncsa\security\delegation\ncsa-security-oauth-1.0a\1.1.3\ncsa-security-oauth-1.0a-1.1.3.jar;C:\Users\Bhakti\.m2\repository\edu\uiuc\ncsa\security\delegation\ncsa-security-delegation-server\1.1.3\ncsa-security-delegation-server-1.1.3.jar;C:\Users\Bhakti\.m2\repository\net\oauth\core\oauth\20100527\oauth-20100527.jar;C:\Users\Bhakti\.m2\repository\net\oauth\core\oauth-provider\20100527\oauth-provider-20100527.jar;C:\Users\Bhakti\.m2\repository\org\slf4j\slf4j-api\1.7.25\slf4j-api-1.7.25.jar;C:\Users\Bhakti\.m2\repository\org\apache\derby\derbynet\10.13.1.1\derbynet-10.13.1.1.jar;C:\Users\Bhakti\.m2\repository\commons-dbcp\commons-dbcp\1.4\commons-dbcp-1.4.jar;C:\Users\Bhakti\.m2\repository\commons-pool\commons-pool\1.5.4\commons-pool-1.5.4.jar;C:\Users\Bhakti\.m2\repository\com\jcraft\jsch\0.1.50\jsch-0.1.50.jar;C:\Users\Bhakti\.m2\repository\org\apache\commons\commons-email\1.3.2\commons-email-1.3.2.jar;C:\Users\Bhakti\.m2\repository\javax\activation\activation\1.1.1\activation-1.1.1.jar;D:\Airavata\airavata\modules\sharing-registry\sharing-registry-server\target\classes;D:\Airavata\airavata\modules\configuration\server\target\classes;C:\Users\Bhakti\.m2\repository\net\sf\dozer\dozer\5.4.0\dozer-5.4.0.jar;C:\Users\Bhakti\.m2\repository\commons-beanutils\commons-beanutils\1.8.3\commons-beanutils-1.8.3.jar;C:\Users\Bhakti\.m2\repository\org\apache\commons\commons-lang3\3.1\commons-lang3-3.1.jar;C:\Users\Bhakti\.m2\repository\org\slf4j\jcl-over-slf4j\1.7.25\jcl-over-slf4j-1.7.25.jar;C:\Users\Bhakti\.m2\repository\org\apache\openjpa\openjpa\3.1.0\openjpa-3.1.0.jar;C:\Users\Bhakti\.m2\repository\org\apache\commons\commons-collections4\4.3\commons-collections4-4.3.jar;C:\Users\Bhakti\.m2\repository\net\sourceforge\serp\serp\1.15.1\serp-1.15.1.jar;C:\Users\Bhakti\.m2\repository\org\apache\geronimo\specs\geronimo-jms_1.1_spec\1.1.1\geronimo-jms_1.1_spec-1.1.1.jar;C:\Users\Bhakti\.m2\repository\org\apache\geronimo\specs\geronimo-jta_1.1_spec\1.1.1\geronimo-jta_1.1_spec-1.1.1.jar;C:\Users\Bhakti\.m2\repository\org\apache\xbean\xbean-asm7-shaded\4.12\xbean-asm7-shaded-4.12.jar;C:\Users\Bhakti\.m2\repository\org\apache\geronimo\specs\geronimo-jpa_2.2_spec\1.0\geronimo-jpa_2.2_spec-1.0.jar;C:\Users\Bhakti\.m2\repository\mysql\mysql-connector-java\5.1.34\mysql-connector-java-5.1.34.jar;C:\Users\Bhakti\.m2\repository\org\databene\contiperf\2.3.4\contiperf-2.3.4.jar;C:\Users\Bhakti\.m2\repository\commons-lang\commons-lang\2.6\commons-lang-2.6.jar;D:\Airavata\airavata\airavata-api\airavata-api-server\target\classes;D:\Airavata\airavata\airavata-api\airavata-api-stubs\target\classes;D:\Airavata\airavata\airavata-api\airavata-model-utils\target\classes;D:\Airavata\airavata\modules\orchestrator\orchestrator-client\target\classes;D:\Airavata\airavata\modules\configuration\client\target\classes;D:\Airavata\airavata\modules\security\target\classes;C:\Users\Bhakti\.m2\repository\org\apache\shiro\shiro-core\1.2.1\shiro-core-1.2.1.jar;D:\Airavata\airavata\airavata-services\services-security\target\classes;C:\Users\Bhakti\.m2\repository\org\json\json\20131018\json-20131018.jar;D:\Airavata\airavata\modules\compute-account-provisioning\target\classes;C:\Users\Bhakti\.m2\repository\org\apache\directory\api\api-all\1.0.0\api-all-1.0.0.jar;C:\Users\Bhakti\.m2\repository\org\apache\servicemix\bundles\org.apache.servicemix.bundles.xpp3\1.1.4c_7\org.apache.servicemix.bundles.xpp3-1.1.4c_7.jar;C:\Users\Bhakti\.m2\repository\org\apache\servicemix\bundles\org.apache.servicemix.bundles.dom4j\1.6.1_5\org.apache.servicemix.bundles.dom4j-1.6.1_5.jar;C:\Users\Bhakti\.m2\repository\xml-apis\xml-apis\1.0.b2\xml-apis-1.0.b2.jar;C:\Users\Bhakti\.m2\repository\org\apache\mina\mina-core\2.0.16\mina-core-2.0.16.jar;C:\Users\Bhakti\.m2\repository\commons-collections\commons-collections\3.2.2\commons-collections-3.2.2.jar;C:\Users\Bhakti\.m2\repository\org\apache\servicemix\bundles\org.apache.servicemix.bundles.antlr\2.7.7_5\org.apache.servicemix.bundles.antlr-2.7.7_5.jar;C:\Users\Bhakti\.m2\repository\org\apache\curator\curator-framework\2.8.0\curator-framework-2.8.0.jar;C:\Users\Bhakti\.m2\repository\org\apache\curator\curator-client\2.8.0\curator-client-2.8.0.jar;C:\Users\Bhakti\.m2\repository\org\apache\zookeeper\zookeeper\3.4.0\zookeeper-3.4.0.jar;C:\Users\Bhakti\.m2\repository\jline\jline\0.9.94\jline-0.9.94.jar;C:\Users\Bhakti\.m2\repository\org\jboss\netty\netty\3.2.2.Final\netty-3.2.2.Final.jar;C:\Users\Bhakti\.m2\repository\org\apache\httpcomponents\httpclient\4.4\httpclient-4.4.jar;C:\Users\Bhakti\.m2\repository\commons-logging\commons-logging\1.2\commons-logging-1.2.jar;C:\Users\Bhakti\.m2\repository\commons-codec\commons-codec\1.9\commons-codec-1.9.jar;C:\Users\Bhakti\.m2\repository\com\google\inject\guice\4.0\guice-4.0.jar;C:\Users\Bhakti\.m2\repository\javax\inject\javax.inject\1\javax.inject-1.jar;C:\Users\Bhakti\.m2\repository\aopalliance\aopalliance\1.0\aopalliance-1.0.jar;C:\Users\Bhakti\.m2\repository\org\apache\oltu\oauth2\org.apache.oltu.oauth2.client\1.0.0\org.apache.oltu.oauth2.client-1.0.0.jar;C:\Users\Bhakti\.m2\repository\org\apache\oltu\oauth2\org.apache.oltu.oauth2.common\1.0.0\org.apache.oltu.oauth2.common-1.0.0.jar;C:\Users\Bhakti\.m2\repository\org\codehaus\jackson\jackson-mapper-asl\1.9.13\jackson-mapper-asl-1.9.13.jar;C:\Users\Bhakti\.m2\repository\org\codehaus\jackson\jackson-core-asl\1.9.13\jackson-core-asl-1.9.13.jar;D:\Airavata\airavata\airavata-services\profile-service\profile-service-stubs\target\classes;D:\Airavata\airavata\modules\orchestrator\orchestrator-service\target\classes;D:\Airavata\airavata\modules\orchestrator\orchestrator-core\target\classes;D:\Airavata\airavata\modules\cluster-monitoring\target\classes;C:\Users\Bhakti\.m2\repository\org\quartz-scheduler\quartz\2.2.1\quartz-2.2.1.jar;C:\Users\Bhakti\.m2\repository\c3p0\c3p0\0.9.1.1\c3p0-0.9.1.1.jar;C:\Users\Bhakti\.m2\repository\org\quartz-scheduler\quartz-jobs\2.2.1\quartz-jobs-2.2.1.jar;D:\Airavata\airavata\airavata-services\profile-service\profile-service-server\target\classes;D:\Airavata\airavata\airavata-services\profile-service\profile-user-core\target\classes;D:\Airavata\airavata\airavata-services\profile-service\profile-service-commons\target\classes;D:\Airavata\airavata\airavata-services\profile-service\profile-tenant-core\target\classes;D:\Airavata\airavata\airavata-services\profile-service\iam-admin-services-core\target\classes;C:\Users\Bhakti\.m2\repository\commons-httpclient\commons-httpclient\3.1\commons-httpclient-3.1.jar;C:\Users\Bhakti\.m2\repository\javax\ws\rs\javax.ws.rs-api\2.0.1\javax.ws.rs-api-2.0.1.jar;C:\Users\Bhakti\.m2\repository\org\jboss\resteasy\resteasy-client\3.0.14.Final\resteasy-client-3.0.14.Final.jar;C:\Users\Bhakti\.m2\repository\org\jboss\resteasy\resteasy-jaxrs\3.0.14.Final\resteasy-jaxrs-3.0.14.Final.jar;C:\Users\Bhakti\.m2\repository\org\jboss\spec\javax\ws\rs\jboss-jaxrs-api_2.0_spec\1.0.0.Final\jboss-jaxrs-api_2.0_spec-1.0.0.Final.jar;C:\Users\Bhakti\.m2\repository\org\jboss\spec\javax\annotation\jboss-annotations-api_1.2_spec\1.0.0.Final\jboss-annotations-api_1.2_spec-1.0.0.Final.jar;C:\Users\Bhakti\.m2\repository\net\jcip\jcip-annotations\1.0\jcip-annotations-1.0.jar;C:\Users\Bhakti\.m2\repository\org\jboss\logging\jboss-logging\3.1.4.GA\jboss-logging-3.1.4.GA.jar;C:\Users\Bhakti\.m2\repository\org\jboss\resteasy\resteasy-jackson2-provider\3.0.14.Final\resteasy-jackson2-provider-3.0.14.Final.jar;C:\Users\Bhakti\.m2\repository\com\fasterxml\jackson\core\jackson-core\2.6.3\jackson-core-2.6.3.jar;C:\Users\Bhakti\.m2\repository\com\fasterxml\jackson\core\jackson-annotations\2.6.3\jackson-annotations-2.6.3.jar;C:\Users\Bhakti\.m2\repository\com\fasterxml\jackson\core\jackson-databind\2.5.4\jackson-databind-2.5.4.jar;C:\Users\Bhakti\.m2\repository\org\keycloak\keycloak-admin-client\2.5.5.Final\keycloak-admin-client-2.5.5.Final.jar;C:\Users\Bhakti\.m2\repository\org\keycloak\keycloak-core\2.5.5.Final\keycloak-core-2.5.5.Final.jar;C:\Users\Bhakti\.m2\repository\org\keycloak\keycloak-common\2.5.5.Final\keycloak-common-2.5.5.Final.jar;C:\Users\Bhakti\.m2\repository\org\slf4j\slf4j-log4j12\1.7.25\slf4j-log4j12-1.7.25.jar;C:\Users\Bhakti\.m2\repository\log4j\log4j\1.2.17\log4j-1.2.17.jar;C:\Users\Bhakti\.m2\repository\org\mariadb\jdbc\mariadb-java-client\2.0.2\mariadb-java-client-2.0.2.jar;D:\Airavata\airavata\modules\airavata-helix\helix-spectator\target\classes;D:\Airavata\airavata\modules\airavata-helix\task-core\target\classes;D:\Airavata\airavata\modules\airavata-helix\task-api\target\classes;C:\Users\Bhakti\.m2\repository\org\apache\helix\helix-core\0.8.2\helix-core-0.8.2.jar;C:\Users\Bhakti\.m2\repository\com\101tec\zkclient\0.5\zkclient-0.5.jar;C:\Users\Bhakti\.m2\repository\org\apache\commons\commons-math\2.1\commons-math-2.1.jar;C:\Users\Bhakti\.m2\repository\io\dropwizard\metrics\metrics-core\3.2.3\metrics-core-3.2.3.jar;D:\Airavata\airavata\modules\airavata-helix\agent-api\target\classes;D:\Airavata\airavata\modules\airavata-helix\agent-impl\sshj-agent\target\classes;C:\Users\Bhakti\.m2\repository\com\hierynomus\sshj\0.23.0\sshj-0.23.0.jar;C:\Users\Bhakti\.m2\repository\com\jcraft\jzlib\1.1.3\jzlib-1.1.3.jar;C:\Users\Bhakti\.m2\repository\net\i2p\crypto\eddsa\0.2.0\eddsa-0.2.0.jar;D:\Airavata\airavata\modules\airavata-helix\agent-impl\ssh-agent\target\classes;D:\Airavata\airavata\modules\airavata-helix\workflow-impl\target\classes;C:\Users\Bhakti\.m2\repository\org\codehaus\groovy\groovy-templates\2.4.7\groovy-templates-2.4.7.jar;C:\Users\Bhakti\.m2\repository\org\codehaus\groovy\groovy-xml\2.4.7\groovy-xml-2.4.7.jar;C:\Users\Bhakti\.m2\repository\org\codehaus\groovy\groovy\2.4.7\groovy-2.4.7.jar;C:\Users\Bhakti\.m2\repository\org\apache\kafka\kafka-clients\1.0.0\kafka-clients-1.0.0.jar;C:\Users\Bhakti\.m2\repository\org\lz4\lz4-java\1.4\lz4-java-1.4.jar;C:\Users\Bhakti\.m2\repository\org\xerial\snappy\snappy-java\1.1.4\snappy-java-1.1.4.jar;D:\Airavata\airavata\modules\job-monitor\job-monitor-api\target\classes;C:\Users\Bhakti\.m2\repository\org\slf4j\log4j-over-slf4j\1.7.25\log4j-over-slf4j-1.7.25.jar;C:\Users\Bhakti\.m2\repository\com\github\danielwegener\logback-kafka-appender\0.2.0-RC1\logback-kafka-appender-0.2.0-RC1.jar;C:\Users\Bhakti\.m2\repository\net\logstash\logback\logstash-logback-encoder\5.0\logstash-logback-encoder-5.0.jar;C:\Users\Bhakti\.m2\repository\ch\qos\logback\logback-core\1.2.3\logback-core-1.2.3.jar;C:\Users\Bhakti\.m2\repository\com\github\docker-java\docker-java\3.0.14\docker-java-3.0.14.jar;C:\Users\Bhakti\.m2\repository\com\fasterxml\jackson\jaxrs\jackson-jaxrs-json-provider\2.6.4\jackson-jaxrs-json-provider-2.6.4.jar;C:\Users\Bhakti\.m2\repository\com\fasterxml\jackson\jaxrs\jackson-jaxrs-base\2.6.4\jackson-jaxrs-base-2.6.4.jar;C:\Users\Bhakti\.m2\repository\com\fasterxml\jackson\module\jackson-module-jaxb-annotations\2.6.4\jackson-module-jaxb-annotations-2.6.4.jar;C:\Users\Bhakti\.m2\repository\org\glassfish\jersey\connectors\jersey-apache-connector\2.23.1\jersey-apache-connector-2.23.1.jar;C:\Users\Bhakti\.m2\repository\org\glassfish\jersey\core\jersey-common\2.23.1\jersey-common-2.23.1.jar;C:\Users\Bhakti\.m2\repository\org\glassfish\jersey\bundles\repackaged\jersey-guava\2.23.1\jersey-guava-2.23.1.jar;C:\Users\Bhakti\.m2\repository\org\glassfish\hk2\osgi-resource-locator\1.0.1\osgi-resource-locator-1.0.1.jar;C:\Users\Bhakti\.m2\repository\org\glassfish\jersey\core\jersey-client\2.23.1\jersey-client-2.23.1.jar;C:\Users\Bhakti\.m2\repository\org\glassfish\hk2\hk2-api\2.4.0-b34\hk2-api-2.4.0-b34.jar;C:\Users\Bhakti\.m2\repository\org\glassfish\hk2\hk2-utils\2.4.0-b34\hk2-utils-2.4.0-b34.jar;C:\Users\Bhakti\.m2\repository\org\glassfish\hk2\external\aopalliance-repackaged\2.4.0-b34\aopalliance-repackaged-2.4.0-b34.jar;C:\Users\Bhakti\.m2\repository\org\glassfish\hk2\external\javax.inject\2.4.0-b34\javax.inject-2.4.0-b34.jar;C:\Users\Bhakti\.m2\repository\org\glassfish\hk2\hk2-locator\2.4.0-b34\hk2-locator-2.4.0-b34.jar;C:\Users\Bhakti\.m2\repository\org\javassist\javassist\3.18.1-GA\javassist-3.18.1-GA.jar;C:\Users\Bhakti\.m2\repository\com\kohlschutter\junixsocket\junixsocket-common\2.0.4\junixsocket-common-2.0.4.jar;C:\Users\Bhakti\.m2\repository\com\kohlschutter\junixsocket\junixsocket-native-common\2.0.4\junixsocket-native-common-2.0.4.jar;C:\Users\Bhakti\.m2\repository\org\scijava\native-lib-loader\2.0.2\native-lib-loader-2.0.2.jar;C:\Users\Bhakti\.m2\repository\org\apache\commons\commons-compress\1.12\commons-compress-1.12.jar;C:\Users\Bhakti\.m2\repository\commons-io\commons-io\2.5\commons-io-2.5.jar;C:\Users\Bhakti\.m2\repository\org\bouncycastle\bcpkix-jdk15on\1.56\bcpkix-jdk15on-1.56.jar;C:\Users\Bhakti\.m2\repository\org\bouncycastle\bcprov-jdk15on\1.56\bcprov-jdk15on-1.56.jar;C:\Users\Bhakti\.m2\repository\io\netty\netty-codec-http\4.1.11.Final\netty-codec-http-4.1.11.Final.jar;C:\Users\Bhakti\.m2\repository\io\netty\netty-codec\4.1.11.Final\netty-codec-4.1.11.Final.jar;C:\Users\Bhakti\.m2\repository\io\netty\netty-handler\4.1.11.Final\netty-handler-4.1.11.Final.jar;C:\Users\Bhakti\.m2\repository\io\netty\netty-buffer\4.1.11.Final\netty-buffer-4.1.11.Final.jar;C:\Users\Bhakti\.m2\repository\io\netty\netty-transport\4.1.11.Final\netty-transport-4.1.11.Final.jar;C:\Users\Bhakti\.m2\repository\io\netty\netty-resolver\4.1.11.Final\netty-resolver-4.1.11.Final.jar;C:\Users\Bhakti\.m2\repository\io\netty\netty-handler-proxy\4.1.11.Final\netty-handler-proxy-4.1.11.Final.jar;C:\Users\Bhakti\.m2\repository\io\netty\netty-codec-socks\4.1.11.Final\netty-codec-socks-4.1.11.Final.jar;C:\Users\Bhakti\.m2\repository\io\netty\netty-transport-native-epoll\4.1.11.Final\netty-transport-native-epoll-4.1.11.Final-linux-x86_64.jar;C:\Users\Bhakti\.m2\repository\io\netty\netty-common\4.1.11.Final\netty-common-4.1.11.Final.jar;C:\Users\Bhakti\.m2\repository\io\netty\netty-transport-native-unix-common\4.1.11.Final\netty-transport-native-unix-common-4.1.11.Final.jar;C:\Users\Bhakti\.m2\repository\io\netty\netty-transport-native-kqueue\4.1.11.Final\netty-transport-native-kqueue-4.1.11.Final-osx-x86_64.jar;D:\Airavata\airavata\modules\job-monitor\email-monitor\target\classes;C:\Users\Bhakti\.m2\repository\org\yaml\snakeyaml\1.15\snakeyaml-1.15.jar;C:\Users\Bhakti\.m2\repository\javax\mail\mail\1.4.5\mail-1.4.5.jar org.apache.airavata.ide.integration.APIServerStarter SLF4J: Class path contains multiple SLF4J bindings. SLF4J: Found binding in [jar:file:/C:/Users/Bhakti/.m2/repository/ch/qos/logback/logback-classic/1.2.3/logback-classic-1.2.3.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: Found binding in [jar:file:/C:/Users/Bhakti/.m2/repository/org/slf4j/slf4j-log4j12/1.7.25/slf4j-log4j12-1.7.25.jar!/org/slf4j/impl/StaticLoggerBinder.class] SLF4J: See http://www.slf4j.org/codes.html#multiple_bindings for an explanation. 12:52:26,773 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback-test.xml] 12:52:26,774 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Could NOT find resource [logback.groovy] 12:52:26,775 |-INFO in ch.qos.logback.classic.LoggerContext[default] - Found resource [logback.xml] at [file:/D:/Airavata/airavata/modules/ide-integration/target/classes/logback.xml] 12:52:26,777 |-WARN in ch.qos.logback.classic.LoggerContext[default] - Resource [logback.xml] occurs multiple times on the classpath. 12:52:26,777 |-WARN in ch.qos.logback.classic.LoggerContext[default] - Resource [logback.xml] occurs at [file:/D:/Airavata/airavata/modules/airavata-helix/helix-spectator/target/classes/logback.xml] 12:52:26,777 |-WARN in ch.qos.logback.classic.LoggerContext[default] - Resource [logback.xml] occurs at [file:/D:/Airavata/airavata/modules/job-monitor/email-monitor/target/classes/logback.xml] 12:52:26,777 |-WARN in ch.qos.logback.classic.LoggerContext[default] - Resource [logback.xml] occurs at [file:/D:/Airavata/airavata/modules/configuration/server/target/classes/logback.xml] 12:52:26,777 |-WARN in ch.qos.logback.classic.LoggerContext[default] - Resource [logback.xml] occurs at [file:/D:/Airavata/airavata/modules/ide-integration/target/classes/logback.xml] 12:52:26,959 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - debug attribute not set 12:52:26,966 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.core.ConsoleAppender] 12:52:27,009 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [CONSOLE] 12:52:27,024 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] property 12:52:27,107 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - About to instantiate appender of type [ch.qos.logback.core.rolling.RollingFileAppender] 12:52:27,124 |-INFO in ch.qos.logback.core.joran.action.AppenderAction - Naming appender as [LOGFILE] 12:52:27,130 |-INFO in ch.qos.logback.core.joran.action.NestedComplexPropertyIA - Assuming default type [ch.qos.logback.classic.encoder.PatternLayoutEncoder] for [encoder] property 12:52:27,145 |-INFO in c.q.l.core.rolling.TimeBasedRollingPolicy@1237550792 - setting totalSizeCap to 1 GB 12:52:27,156 |-INFO in c.q.l.core.rolling.TimeBasedRollingPolicy@1237550792 - No compression will be used 12:52:27,159 |-INFO in c.q.l.core.rolling.TimeBasedRollingPolicy@1237550792 - Will use the pattern ../logs/airavata.log.%d{yyyy-MM-dd} for the active file 12:52:27,169 |-INFO in c.q.l.core.rolling.DefaultTimeBasedFileNamingAndTriggeringPolicy - The date pattern is 'yyyy-MM-dd' from file name pattern '../logs/airavata.log.%d{yyyy-MM-dd}'. 12:52:27,169 |-INFO in c.q.l.core.rolling.DefaultTimeBasedFileNamingAndTriggeringPolicy - Roll-over at midnight. 12:52:27,170 |-INFO in c.q.l.core.rolling.DefaultTimeBasedFileNamingAndTriggeringPolicy - Setting initial period to Wed May 13 12:45:35 EDT 2020 12:52:27,177 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[LOGFILE] - Active log file name: ../logs/airavata.log 12:52:27,178 |-INFO in ch.qos.logback.core.rolling.RollingFileAppender[LOGFILE] - File property is set to [../logs/airavata.log] 12:52:27,181 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting level of logger [ch.qos.logback] to WARN 12:52:27,181 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting level of logger [org.apache.helix] to WARN 12:52:27,181 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting level of logger [org.apache.zookeeper] to ERROR 12:52:27,181 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting level of logger [org.apache.airavata] to INFO 12:52:27,181 |-INFO in ch.qos.logback.classic.joran.action.LoggerAction - Setting level of logger [org.hibernate] to ERROR 12:52:27,181 |-INFO in ch.qos.logback.classic.joran.action.RootLoggerAction - Setting level of ROOT logger to INFO 12:52:27,183 |-ERROR in ch.qos.logback.core.joran.action.AppenderRefAction - Could not find an appender named [RELAXED-KAFKA-APPENDER]. Did you define it below instead of above in the configuration file? 12:52:27,183 |-ERROR in ch.qos.logback.core.joran.action.AppenderRefAction - See http://logback.qos.ch/codes.html#appender_order for more details. 12:52:27,183 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [CONSOLE] to Logger[ROOT] 12:52:27,185 |-INFO in ch.qos.logback.core.joran.action.AppenderRefAction - Attaching appender named [LOGFILE] to Logger[ROOT] 12:52:27,185 |-INFO in ch.qos.logback.classic.joran.action.ConfigurationAction - End of configuration. 12:52:27,186 |-INFO in ch.qos.logback.classic.joran.JoranConfigurator@56528192 - Registering current configuration as safe fallback point SLF4J: Actual binding is of type [ch.qos.logback.classic.util.ContextSelectorStaticBinder] [INFO] Starting the DB Event Manager runner. [INFO] Starting DB Event manager publisher 2020-05-13 12:52:27,225 [Thread-0] INFO o.a.a.d.e.m.m.DBEventManagerMessagingFactory Creating DB Event publisher..... [] 2020-05-13 12:52:27,248 [Thread-0] INFO o.a.a.c.u.ApplicationSettings Settings loaded from file:/D:/Airavata/airavata/modules/ide-integration/target/classes/airavata-server.properties [] 2020-05-13 12:52:27,409 [Thread-0] INFO o.a.a.m.c.i.RabbitMQPublisher connected to rabbitmq: amqp://guest@127.0.0.1:5672develop for db.event.exchange [] 2020-05-13 12:52:27,410 [Thread-0] INFO o.a.a.d.e.m.m.DBEventManagerMessagingFactory DB Event publisher created [] [INFO] Starting DB Event manager subscriber 2020-05-13 12:52:27,410 [Thread-0] INFO o.a.a.d.e.m.m.DBEventManagerMessagingFactory Creating DB Event subscriber..... [] 2020-05-13 12:52:27,530 [main] INFO o.a.a.r.a.s.RegistryAPIServer Initializing databases... [] 2020-05-13 12:52:27,599 [Thread-0] INFO o.a.c.f.i.CuratorFrameworkImpl Starting [] Exception in thread "main" java.lang.RuntimeException: Failed to initialize database for database_scripts/expcatalog at org.apache.airavata.common.utils.DBInitializer.initializeDB(DBInitializer.java:63) at org.apache.airavata.common.utils.DBInitializer.initializeDB(DBInitializer.java:45) at org.apache.airavata.registry.api.service.RegistryAPIServer.StartRegistryServer(RegistryAPIServer.java:69) at org.apache.airavata.registry.api.service.RegistryAPIServer.start(RegistryAPIServer.java:151) at org.apache.airavata.ide.integration.APIServerStarter.main(APIServerStarter.java:23) Caused by: java.sql.SQLNonTransientConnectionException: Could not connect to localhost:13306: unexpected end of exception, read 0 bytes from 4 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/java.sql.DriverManager.getConnection(DriverManager.java:677) at java.sql/java.sql.DriverManager.getConnection(DriverManager.java:189) at org.apache.airavata.common.utils.DBUtil.getConnection(DBUtil.java:212) at org.apache.airavata.common.utils.DBInitializer.initializeDB(DBInitializer.java:54) ... 4 more Caused by: java.sql.SQLException: Could not connect to localhost:13306: unexpected end of exception, read 0 bytes from 4 at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:706) at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connect(AbstractConnectProtocol.java:406) at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.connectWithoutProxy(AbstractConnectProtocol.java:1022) at org.mariadb.jdbc.internal.util.Utils.retrieveProxy(Utils.java:483) at org.mariadb.jdbc.Driver.connect(Driver.java:106) ... 8 more Caused by: java.io.EOFException: unexpected end of exception, read 0 bytes from 4 at org.mariadb.jdbc.internal.io.input.StandardPacketInputStream.getPacketArray(StandardPacketInputStream.java:246) at org.mariadb.jdbc.internal.io.input.StandardPacketInputStream.getPacket(StandardPacketInputStream.java:214) at org.mariadb.jdbc.internal.com.read.ReadInitialHandShakePacket.<init>(ReadInitialHandShakePacket.java:88) at org.mariadb.jdbc.internal.protocol.AbstractConnectProtocol.handleConnectionPhases(AbstractConnectProtocol.java:657) ... 12 more 2020-05-13 12:52:32,722 [Thread-0] INFO o.a.a.m.c.i.RabbitMQSubscriber connected to rabbitmq: amqp://guest@127.0.0.1:5672develop for db.event.exchange [] 2020-05-13 12:52:32,732 [Thread-0-EventThread] INFO o.a.c.f.s.ConnectionStateManager State change: CONNECTED [] 2020-05-13 12:52:32,789 [Thread-0] INFO o.a.a.d.e.m.m.DBEventManagerMessagingFactory DB Event subscriber created []
