airavata-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Raminderjeet Singh (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (AIRAVATA-1062) Mysql script not working
Date Thu, 06 Mar 2014 18:46:56 GMT

    [ https://issues.apache.org/jira/browse/AIRAVATA-1062?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13922874#comment-13922874
] 

Raminderjeet Singh commented on AIRAVATA-1062:
----------------------------------------------

I am not able to run the airavata server on mysql. Following is the error

[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_NAME VARCHAR(255), OWNER VARCHAR(255), PRIMARY
KEY (GATEWAY_NAME) )
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_NAME VARCHAR(255), OWNER VARCHAR(255), PRIMARY
KEY (GATEWAY_NAME) )
	at org.apache.airavata.api.server.util.DatabaseCreator.executeSQL(DatabaseCreator.java:150)
	at org.apache.airavata.api.server.util.DatabaseCreator.executeSQLScript(DatabaseCreator.java:286)
	at org.apache.airavata.api.server.util.DatabaseCreator.createDatabase(DatabaseCreator.java:234)
	at org.apache.airavata.api.server.util.DatabaseCreator.createRegistryDatabase(DatabaseCreator.java:62)
	at org.apache.airavata.api.server.util.RegistryInitUtil.initializeDB(RegistryInitUtil.java:82)
	at org.apache.airavata.api.server.AiravataAPIServer.StartAiravataServer(AiravataAPIServer.java:56)
	at org.apache.airavata.api.server.AiravataAPIServer.start(AiravataAPIServer.java:101)
	at org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:72)
	at org.apache.airavata.server.ServerMain.access$000(ServerMain.java:30)
	at org.apache.airavata.server.ServerMain$1.run(ServerMain.java:42)
Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'GATEWAY' already
exists
	at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
	at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:57)
	at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
	at java.lang.reflect.Constructor.newInstance(Constructor.java:526)
	at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)
	at com.mysql.jdbc.Util.getInstance(Util.java:386)
	at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3597)
	at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3529)
	at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1990)
	at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2151)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2619)
	at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2569)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:824)
	at com.mysql.jdbc.StatementImpl.execute(StatementImpl.java:667)
	at org.apache.airavata.api.server.util.DatabaseCreator.executeSQL(DatabaseCreator.java:122)
	... 9 more
java.lang.RuntimeException: Database failure
	at org.apache.airavata.api.server.util.RegistryInitUtil.initializeDB(RegistryInitUtil.java:103)
	at org.apache.airavata.api.server.AiravataAPIServer.StartAiravataServer(AiravataAPIServer.java:56)
	at org.apache.airavata.api.server.AiravataAPIServer.start(AiravataAPIServer.java:101)
	at org.apache.airavata.server.ServerMain.startAllServers(ServerMain.java:72)
	at org.apache.airavata.server.ServerMain.access$000(ServerMain.java:30)
	at org.apache.airavata.server.ServerMain$1.run(ServerMain.java:42)

> Mysql script not working
> ------------------------
>
>                 Key: AIRAVATA-1062
>                 URL: https://issues.apache.org/jira/browse/AIRAVATA-1062
>             Project: Airavata
>          Issue Type: Bug
>            Reporter: Raminderjeet Singh
>            Assignee: Raminderjeet Singh
>




--
This message was sent by Atlassian JIRA
(v6.2#6252)

Mime
View raw message