You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@airavata.apache.org by "Raminderjeet Singh (JIRA)" <ji...@apache.org> on 2014/03/06 19:46:56 UTC
[jira] [Commented] (AIRAVATA-1062) Mysql script not working

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