[
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)
