Hi Lahiru, The latest commit should fix the issue. There was an inconsistency in the database SQL scripts.
Thanks -Supun On Fri, Aug 26, 2016 at 1:35 AM, Lahiru Ginnaliya Gamathige < [email protected]> wrote: > Hi All, > > I tried to build airavata/develop branch and started the server but fails > with this stacktrace, > > NFO] Server Arguments: --servers=all > > Thu Aug 25 22:21:33 PDT 2016 : Apache Derby Network Server - 10.11.1.1 - > (1616546) started and ready to accept connections on port 1527 > > [ERROR] Error occurred while executing : /* * * Licensed to the Apache > Software Foundation (ASF) under one * or more contributor license > agreements. See the NOTICE file * distributed with this work for > additional information * regarding copyright ownership. The ASF licenses > this file * to you under the Apache License, Version 2.0 (the * "License"); > you may not use this file except in compliance * with the License. You may > obtain a copy of the License at * * http://www.apache.org/ > licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to > in writing, * software distributed under the License is distributed on an * > "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY * KIND, either > express or implied. See the License for the * specific language governing > permissions and limitations * under the License. * */ CREATE TABLE GATEWAY > ( GATEWAY_ID VARCHAR(255), GATEWAY_NAME VARCHAR(255), DOMAIN VARCHAR(255), > EMAIL_ADDRESS VARCHAR(255), GATEWAY_ACRONYM varchar(255), > GATEWAY_ADMIN_EMAIL varchar(255), GATEWAY_ADMIN_FIRST_NAME varchar(255), > GATEWAY_APPROVAL_STATUS varchar(255), GATEWAY_PUBLIC_ABSTRACT varchar(255), > GATEWAY_URL varchar(255), GATEWAY_ADMIN_LAST_NAME varchar(255), > IDENTITY_SERVER_PASSWORD_TOKEN varchar(255), IDENTITY_SERVER_USERNAME > varchar(255), GATEWAY_REVIEW_PROPOSAL_DESCRIPTION varchar(255), > DECLINED_REASON varchar(255), OAUTH_CLIENT_SECRET varchar(255), > OAUTH_CLIENT_ID varchar(255), REQUEST_CREATION_TIME datetime DEFAULT > CURRENT_TIMESTAMP, PRIMARY KEY (GATEWAY_ID) ) > > java.lang.Exception: Error occurred while executing : /* * * Licensed to > the Apache Software Foundation (ASF) under one * or more contributor > license agreements. See the NOTICE file * distributed with this work for > additional information * regarding copyright ownership. The ASF licenses > this file * to you under the Apache License, Version 2.0 (the * "License"); > you may not use this file except in compliance * with the License. You may > obtain a copy of the License at * * http://www.apache.org/ > licenses/LICENSE-2.0 * * Unless required by applicable law or agreed to > in writing, * software distributed under the License is distributed on an * > "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY * KIND, either > express or implied. See the License for the * specific language governing > permissions and limitations * under the License. * */ CREATE TABLE GATEWAY > ( GATEWAY_ID VARCHAR(255), GATEWAY_NAME VARCHAR(255), DOMAIN VARCHAR(255), > EMAIL_ADDRESS VARCHAR(255), GATEWAY_ACRONYM varchar(255), > GATEWAY_ADMIN_EMAIL varchar(255), GATEWAY_ADMIN_FIRST_NAME varchar(255), > GATEWAY_APPROVAL_STATUS varchar(255), GATEWAY_PUBLIC_ABSTRACT varchar(255), > GATEWAY_URL varchar(255), GATEWAY_ADMIN_LAST_NAME varchar(255), > IDENTITY_SERVER_PASSWORD_TOKEN varchar(255), IDENTITY_SERVER_USERNAME > varchar(255), GATEWAY_REVIEW_PROPOSAL_DESCRIPTION varchar(255), > DECLINED_REASON varchar(255), OAUTH_CLIENT_SECRET varchar(255), > OAUTH_CLIENT_ID varchar(255), REQUEST_CREATION_TIME datetime DEFAULT > CURRENT_TIMESTAMP, PRIMARY KEY (GATEWAY_ID) ) > > at org.apache.airavata.registry.api.service.util. > DatabaseCreator.executeSQL(DatabaseCreator.java:154) > > at org.apache.airavata.registry.api.service.util.DatabaseCreator. > executeSQLScript(DatabaseCreator.java:299) > > at org.apache.airavata.registry.api.service.util.DatabaseCreator. > createDatabase(DatabaseCreator.java:238) > > at org.apache.airavata.registry.api.service.util.DatabaseCreator. > createRegistryDatabase(DatabaseCreator.java:66) > > at org.apache.airavata.registry.api.service.util. > ExperimentCatalogInitUtil.initializeDB(ExperimentCatalogInitUtil.java:81) > > at org.apache.airavata.registry.api.service.RegistryAPIServer. > StartRegistryServer(RegistryAPIServer.java:55) > > at org.apache.airavata.registry.api.service.RegistryAPIServer. > start(RegistryAPIServer.java:119) > > at org.apache.airavata.server.ServerMain.startAllServers( > ServerMain.java:331) > > at org.apache.airavata.server.ServerMain.performServerStart( > ServerMain.java:180) > > at org.apache.airavata.server.ServerMain.main(ServerMain.java:163) > > Caused by: java.sql.SQLSyntaxErrorException: Schema 'AIRAVATA' does not > exist > > at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown > Source) > > at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) > > at org.apache.derby.client.am.ClientStatement.execute(Unknown Source) > > at org.apache.airavata.registry.api.service.util. > DatabaseCreator.executeSQL(DatabaseCreator.java:126) > > ... 9 more > > Caused by: ERROR 42Y07: Schema 'AIRAVATA' does not exist > > at org.apache.derby.client.am.ClientStatement.completeSqlca(Unknown > Source) > > at org.apache.derby.client.am.ClientStatement.completeExecuteImmediate(Unknown > Source) > > at org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown > Source) > > at org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown > Source) > > at org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown > Source) > > at org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown > Source) > > at org.apache.derby.client.am.ClientStatement.readExecuteImmediate(Unknown > Source) > > at org.apache.derby.client.am.ClientStatement.flowExecute(Unknown Source) > > at org.apache.derby.client.am.ClientStatement.executeX(Unknown Source) > > ... 11 more > > [ERROR] Server Start Error: > > java.lang.RuntimeException: Database failure > > at org.apache.airavata.registry.api.service.util. > ExperimentCatalogInitUtil.initializeDB(ExperimentCatalogInitUtil.java:124) > > at org.apache.airavata.registry.api.service.RegistryAPIServer. > StartRegistryServer(RegistryAPIServer.java:55) > > at org.apache.airavata.registry.api.service.RegistryAPIServer. > start(RegistryAPIServer.java:119) > > at org.apache.airavata.server.ServerMain.startAllServers( > ServerMain.java:331) > > at org.apache.airavata.server.ServerMain.performServerStart( > ServerMain.java:180) > > at org.apache.airavata.server.ServerMain.main(ServerMain.java:163) > > Caused by: java.lang.Exception: Error occurred while executing : /* * * > Licensed to the Apache Software Foundation (ASF) under one * or more > contributor license agreements. See the NOTICE file * distributed with > this work for additional information * regarding copyright ownership. The > ASF licenses this file * to you under the Apache License, Version 2.0 (the > * "License"); you may not use this file except in compliance * with the > License. You may obtain a copy of the License at * * > http://www.apache.org/licenses/LICENSE-2.0 * * Unless required by > applicable law or agreed to in writing, * software distributed under the > License is distributed on an * "AS IS" BASIS, WITHOUT WARRANTIES OR > CONDITIONS OF ANY * KIND, either express or implied. See the License for > the * specific language governing permissions and limitations * under the > License. * */ CREATE TABLE GATEWAY ( GATEWAY_ID VARCHAR(255), GATEWAY_NAME > VARCHAR(255), DOMAIN VARCHAR(255), EMAIL_ADDRESS VARCHAR(255), > GATEWAY_ACRONYM varchar(255), GATEWAY_ADMIN_EMAIL varchar(255), > GATEWAY_ADMIN_FIRST_NAME varchar(255), GATEWAY_APPROVAL_STATUS > varchar(255), GATEWAY_PUBLIC_ABSTRACT varchar(255), GATEWAY_URL > varchar(255), GATEWAY_ADMIN_LAST_NAME varchar(255), > IDENTITY_SERVER_PASSWORD_TOKEN varchar(255), IDENTITY_SERVER_USERNAME > varchar(255), GATEWAY_REVIEW_PROPOSAL_DESCRIPTION varchar(255), > DECLINED_REASON varchar(255), OAUTH_CLIENT_SECRET varchar(255), > OAUTH_CLIENT_ID varchar(255), REQUEST_CREATION_TIME datetime DEFAULT > CURRENT_TIMESTAMP, PRIMARY KEY (GATEWAY_ID) ) > > at org.apache.airavata.registry.api.service.util. > DatabaseCreator.executeSQL(DatabaseCreator.java:154) > > at org.apache.airavata.registry.api.service.util.DatabaseCreator. > executeSQLScript(DatabaseCreator.java:299) > > at org.apache.airavata.registry.api.service.util.DatabaseCreator. > createDatabase(DatabaseCreator.java:238) > > at org.apache.airavata.registry.api.service.util.DatabaseCreator. > createRegistryDatabase(DatabaseCreator.java:66) > > at org.apache.airavata.registry.api.service.util. > ExperimentCatalogInitUtil.initializeDB(ExperimentCatalogInitUtil.java:81) > > ... 5 more > > Caused by: java.sql.SQLSyntaxErrorException: Schema 'AIRAVATA' does not > exist > > at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown > Source) > > at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source) > > at org.apache.derby.client.am.ClientStatement.execute(Unknown Source) > > at org.apache.airavata.registry.api.service.util. > DatabaseCreator.executeSQL(DatabaseCreator.java:126) > > ... 9 more > > Caused by: ERROR 42Y07: Schema 'AIRAVATA' does not exist > > at org.apache.derby.client.am.ClientStatement.completeSqlca(Unknown > Source) > > at org.apache.derby.client.am.ClientStatement.completeExecuteImmediate(Unknown > Source) > > at org.apache.derby.client.net.NetStatementReply.parseEXCSQLIMMreply(Unknown > Source) > > at org.apache.derby.client.net.NetStatementReply.readExecuteImmediate(Unknown > Source) > > at org.apache.derby.client.net.StatementReply.readExecuteImmediate(Unknown > Source) > > at org.apache.derby.client.net.NetStatement.readExecuteImmediate_(Unknown > Source) > > at org.apache.derby.client.am.ClientStatement.readExecuteImmediate(Unknown > Source) > > at org.apache.derby.client.am.ClientStatement.flowExecute(Unknown Source) > > at org.apache.derby.client.am.ClientStatement.executeX(Unknown Source) > > ... 11 more > > [INFO] Starting Credential store Server on Port 8960 > > [INFO] Listening to Credential store clients .... > > [INFO] Security module reached... > > [ERROR] RabbitMQ connection issue for exchange : status_exchange > > [ERROR] Error occured while reading airavata-server properties.. > > org.apache.airavata.common.exception.AiravataException: RabbitMQ > connection issue for exchange : status_exchange > > at org.apache.airavata.messaging.core.impl.RabbitMQPublisher. > connect(RabbitMQPublisher.java:79) > > at org.apache.airavata.messaging.core.impl.RabbitMQPublisher.< > init>(RabbitMQPublisher.java:52) > > at org.apache.airavata.messaging.core.MessagingFactory.getStatusPublisher( > MessagingFactory.java:100) > > at org.apache.airavata.messaging.core.MessagingFactory. > getPublisher(MessagingFactory.java:84) > > at org.apache.airavata.api.server.handler.AiravataServerHandler.<init>( > AiravataServerHandler.java:97) > > at org.apache.airavata.api.server.handler.AiravataServerHandler$$ > EnhancerByGuice$$3ac39014.<init>(<generated>) > > at org.apache.airavata.api.server.handler.AiravataServerHandler$$ > EnhancerByGuice$$3ac39014$$FastClassByGuice$$be216934. > newInstance(<generated>) > > at com.google.inject.internal.cglib.reflect.$FastConstructor.newInstance( > FastConstructor.java:40) > > at com.google.inject.internal.ProxyFactory$ProxyConstructor. > newInstance(ProxyFactory.java:266) > > at com.google.inject.internal.ConstructorInjector.provision( > ConstructorInjector.java:105) > > at com.google.inject.internal.ConstructorInjector.construct( > ConstructorInjector.java:85) > > at com.google.inject.internal.ConstructorBindingImpl$Factory.get( > ConstructorBindingImpl.java:267) > > at com.google.inject.internal.InjectorImpl$2$1.call( > InjectorImpl.java:1016) > > at com.google.inject.internal.InjectorImpl.callInContext( > InjectorImpl.java:1092) > > at com.google.inject.internal.InjectorImpl$2.get(InjectorImpl.java:1012) > > at com.google.inject.internal.InjectorImpl.getInstance( > InjectorImpl.java:1051) > > at org.apache.airavata.api.server.AiravataAPIServer. > start(AiravataAPIServer.java:190) > > at org.apache.airavata.server.ServerMain.startAllServers( > ServerMain.java:331) > > at org.apache.airavata.server.ServerMain.performServerStart( > ServerMain.java:180) > > at org.apache.airavata.server.ServerMain.main(ServerMain.java:163) > > Caused by: java.net.ConnectException: Connection refused > > at java.net.PlainSocketImpl.socketConnect(Native Method) > > at java.net.AbstractPlainSocketImpl.doConnect( > AbstractPlainSocketImpl.java:345) > > 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 com.rabbitmq.client.impl.FrameHandlerFactory.create( > FrameHandlerFactory.java:32) > > at com.rabbitmq.client.impl.recovery.RecoveryAwareAMQConnectionFact > ory.newConnection(RecoveryAwareAMQConnectionFactory.java:34) > > at com.rabbitmq.client.impl.recovery.AutorecoveringConnection.init( > AutorecoveringConnection.java:83) > > at com.rabbitmq.client.ConnectionFactory.newConnection( > ConnectionFactory.java:595) > > at com.rabbitmq.client.ConnectionFactory.newConnection( > ConnectionFactory.java:625) > > at org.apache.airavata.messaging.core.impl.RabbitMQPublisher. > connect(RabbitMQPublisher.java:60) > > ... 19 more > > [INFO] API server started over TLS on Port: 9930 ... > > [ERROR] RabbitMQ connection issue for exchange : status_exchange > > [ERROR] RabbitMQ connection issue for exchange : status_exchange > > org.apache.airavata.common.exception.AiravataException: RabbitMQ > connection issue for exchange : status_exchange > > at org.apache.airavata.messaging.core.impl.RabbitMQPublisher. > connect(RabbitMQPublisher.java:79) > > at org.apache.airavata.messaging.core.impl.RabbitMQPublisher.< > init>(RabbitMQPublisher.java:52) > > at org.apache.airavata.messaging.core.MessagingFactory.getStatusPublisher( > MessagingFactory.java:100) > > at org.apache.airavata.messaging.core.MessagingFactory. > getPublisher(MessagingFactory.java:84) > > at org.apache.airavata.orchestrator.server.OrchestratorServerHandler.< > init>(OrchestratorServerHandler.java:95) > > at org.apache.airavata.orchestrator.server.OrchestratorServer.start( > OrchestratorServer.java:109) > > at org.apache.airavata.server.ServerMain.startAllServers( > ServerMain.java:331) > > at org.apache.airavata.server.ServerMain.performServerStart( > ServerMain.java:180) > > at org.apache.airavata.server.ServerMain.main(ServerMain.java:163) > > Caused by: java.net.ConnectException: Connection refused > > at java.net.PlainSocketImpl.socketConnect(Native Method) > > at java.net.AbstractPlainSocketImpl.doConnect( > AbstractPlainSocketImpl.java:345) > > 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 com.rabbitmq.client.impl.FrameHandlerFactory.create( > FrameHandlerFactory.java:32) > > at com.rabbitmq.client.impl.recovery.RecoveryAwareAMQConnectionFact > ory.newConnection(RecoveryAwareAMQConnectionFactory.java:34) > > at com.rabbitmq.client.impl.recovery.AutorecoveringConnection.init( > AutorecoveringConnection.java:83) > > at com.rabbitmq.client.ConnectionFactory.newConnection( > ConnectionFactory.java:595) > > at com.rabbitmq.client.ConnectionFactory.newConnection( > ConnectionFactory.java:625) > > at org.apache.airavata.messaging.core.impl.RabbitMQPublisher. > connect(RabbitMQPublisher.java:60) > > ... 8 more > > [ERROR] Server Start Error: > > org.apache.airavata.orchestrator.core.exception.OrchestratorException: > Error while initializing orchestrator service > > at org.apache.airavata.orchestrator.server.OrchestratorServerHandler.< > init>(OrchestratorServerHandler.java:102) > > at org.apache.airavata.orchestrator.server.OrchestratorServer.start( > OrchestratorServer.java:109) > > at org.apache.airavata.server.ServerMain.startAllServers( > ServerMain.java:331) > > at org.apache.airavata.server.ServerMain.performServerStart( > ServerMain.java:180) > > at org.apache.airavata.server.ServerMain.main(ServerMain.java:163) > > Caused by: org.apache.airavata.common.exception.AiravataException: > RabbitMQ connection issue for exchange : status_exchange > > at org.apache.airavata.messaging.core.impl.RabbitMQPublisher. > connect(RabbitMQPublisher.java:79) > > at org.apache.airavata.messaging.core.impl.RabbitMQPublisher.< > init>(RabbitMQPublisher.java:52) > > at org.apache.airavata.messaging.core.MessagingFactory.getStatusPublisher( > MessagingFactory.java:100) > > at org.apache.airavata.messaging.core.MessagingFactory. > getPublisher(MessagingFactory.java:84) > > at org.apache.airavata.orchestrator.server.OrchestratorServerHandler.< > init>(OrchestratorServerHandler.java:95) > > ... 4 more > > Caused by: java.net.ConnectException: Connection refused > > at java.net.PlainSocketImpl.socketConnect(Native Method) > > at java.net.AbstractPlainSocketImpl.doConnect( > AbstractPlainSocketImpl.java:345) > > 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 com.rabbitmq.client.impl.FrameHandlerFactory.create( > FrameHandlerFactory.java:32) > > at com.rabbitmq.client.impl.recovery.RecoveryAwareAMQConnectionFact > ory.newConnection(RecoveryAwareAMQConnectionFactory.java:34) > > at com.rabbitmq.client.impl.recovery.AutorecoveringConnection.init( > AutorecoveringConnection.java:83) > > at com.rabbitmq.client.ConnectionFactory.newConnection( > ConnectionFactory.java:595) > > at com.rabbitmq.client.ConnectionFactory.newConnection( > ConnectionFactory.java:625) > > at org.apache.airavata.messaging.core.impl.RabbitMQPublisher. > connect(RabbitMQPublisher.java:60) > > ... 8 more > > [INFO] Starting > > [INFO] State change: CONNECTED > > [ERROR] could not open channel for exchange process_exchange > > [ERROR] Server Start Error: > > org.apache.airavata.common.exception.AiravataStartupException: Gfac > Server Initialization error > > at org.apache.airavata.gfac.server.GfacServerHandler.< > init>(GfacServerHandler.java:93) > > at org.apache.airavata.gfac.server.GfacServer.start(GfacServer.java:102) > > at org.apache.airavata.server.ServerMain.startAllServers( > ServerMain.java:331) > > at org.apache.airavata.server.ServerMain.performServerStart( > ServerMain.java:180) > > at org.apache.airavata.server.ServerMain.main(ServerMain.java:163) > > Caused by: org.apache.airavata.common.exception.AiravataException: could > not open channel for exchange process_exchange > > at org.apache.airavata.messaging.core.impl.RabbitMQSubscriber. > createConnection(RabbitMQSubscriber.java:71) > > at org.apache.airavata.messaging.core.impl.RabbitMQSubscriber.< > init>(RabbitMQSubscriber.java:52) > > at org.apache.airavata.messaging.core.MessagingFactory. > getProcessSubscriber(MessagingFactory.java:128) > > at org.apache.airavata.messaging.core.MessagingFactory.getSubscriber( > MessagingFactory.java:55) > > at org.apache.airavata.gfac.impl.Factory.initPrcessLaunchSubscriber( > Factory.java:179) > > at org.apache.airavata.gfac.server.GfacServerHandler.initAMQPClient( > GfacServerHandler.java:99) > > at org.apache.airavata.gfac.server.GfacServerHandler.< > init>(GfacServerHandler.java:90) > > ... 4 more > > Caused by: java.net.ConnectException: Connection refused > > at java.net.PlainSocketImpl.socketConnect(Native Method) > > at java.net.AbstractPlainSocketImpl.doConnect( > AbstractPlainSocketImpl.java:345) > > 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 com.rabbitmq.client.impl.FrameHandlerFactory.create( > FrameHandlerFactory.java:32) > > at com.rabbitmq.client.impl.recovery.RecoveryAwareAMQConnectionFact > ory.newConnection(RecoveryAwareAMQConnectionFactory.java:34) > > at com.rabbitmq.client.impl.recovery.AutorecoveringConnection.init( > AutorecoveringConnection.java:83) > > at com.rabbitmq.client.ConnectionFactory.newConnection( > ConnectionFactory.java:595) > > at com.rabbitmq.client.ConnectionFactory.newConnection( > ConnectionFactory.java:625) > > at org.apache.airavata.messaging.core.impl.RabbitMQSubscriber. > createConnection(RabbitMQSubscriber.java:60) > > ... 10 more > > ^C[ERROR] Error stopping the Gfac Server!!! > > [ERROR] Error stopping the Orchestrator Server!!! > > [ERROR] Error stopping the Airavata API Server!!! > > [INFO] Waiting for Credential Store Server to stop... > > [INFO] Airavata API Server over TLS Stopped. > > [INFO] Credential store Server Stopped. > > [ERROR] Error stopping the Registry API Server!!! > -- Thank you Supun Nakandala Dept. Computer Science and Engineering University of Moratuwa
