You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@cloudstack.apache.org by "prashant kumar mishra (JIRA)" <ji...@apache.org> on 2014/02/10 12:40:21 UTC
[jira] [Closed] (CLOUDSTACK-5817) [Dev Setup]Deploy Db is failing
on master and 4.3
[ https://issues.apache.org/jira/browse/CLOUDSTACK-5817?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
prashant kumar mishra closed CLOUDSTACK-5817.
---------------------------------------------
tested , passed
> [Dev Setup]Deploy Db is failing on master and 4.3
> -------------------------------------------------
>
> Key: CLOUDSTACK-5817
> URL: https://issues.apache.org/jira/browse/CLOUDSTACK-5817
> Project: CloudStack
> Issue Type: Bug
> Security Level: Public(Anyone can view this level - this is the default.)
> Components: Management Server
> Affects Versions: 4.3.0
> Reporter: prashant kumar mishra
> Assignee: Harikrishna Patnala
> Priority: Blocker
> Fix For: 4.3.0
>
>
> Ddeploydb is failing on master and 4.3 branch . For branch 4.2 it is working fine
> [root@localhost cloudstack]# mvn -P developer -pl developer -Ddeploydb
> [INFO] Scanning for projects...
> [INFO]
> [INFO] ------------------------------------------------------------------------
> [INFO] Building Apache CloudStack Developer Mode 4.4.0-SNAPSHOT
> [INFO] ------------------------------------------------------------------------
> [INFO]
> [INFO] --- properties-maven-plugin:1.0-alpha-2:read-project-properties (default) @ cloud-developer ---
> [INFO]
> [INFO] --- maven-remote-resources-plugin:1.3:process (default) @ cloud-developer ---
> [INFO]
> [INFO] --- maven-antrun-plugin:1.7:run (default) @ cloud-developer ---
> [INFO] Executing tasks
> main:
> [INFO] Executed tasks
> [INFO]
> [INFO] >>> exec-maven-plugin:1.2.1:java (create-schema) @ cloud-developer >>>
> [INFO]
> [INFO] <<< exec-maven-plugin:1.2.1:java (create-schema) @ cloud-developer <<<
> [INFO]
> [INFO] --- exec-maven-plugin:1.2.1:java (create-schema) @ cloud-developer ---
> log4j:WARN No appenders could be found for logger (org.springframework.core.env.StandardEnvironment).
> log4j:WARN Please initialize the log4j system properly.
> log4j:WARN See http://logging.apache.org/log4j/1.2/faq.html#noconfig for more info.
> ========> WARNING: Provided file does not exist: /root/cloudstack/developer/developer-prefill.sql.override
> ========> Initializing database=cloud with host=localhost port=3306 username=root password=
> ============> Running query: drop database if exists `cloud`
> ============> Running query: create database `cloud`
> ============> Running query: GRANT ALL ON cloud.* to 'root'@`localhost` identified by ''
> ============> Running query: GRANT ALL ON cloud.* to 'root'@`%` identified by ''
> ========> Initializing database=cloud_usage with host=localhost port=3306 username=root password=
> ============> Running query: drop database if exists `cloud_usage`
> ============> Running query: create database `cloud_usage`
> ============> Running query: GRANT ALL ON cloud_usage.* to 'root'@`localhost` identified by ''
> ============> Running query: GRANT ALL ON cloud_usage.* to 'root'@`%` identified by ''
> ========> Initializing database=cloudbridge with host=localhost port=3306 username=root password=
> ============> Running query: drop database if exists `cloudbridge`
> ============> Running query: create database `cloudbridge`
> ============> Running query: GRANT ALL ON cloudbridge.* to 'root'@`localhost` identified by ''
> ============> Running query: GRANT ALL ON cloudbridge.* to 'root'@`%` identified by ''
> ========> Processing SQL file at /root/cloudstack/developer/target/db/create-schema.sql
> ========> Processing SQL file at /root/cloudstack/developer/target/db/create-schema-premium.sql
> ========> Processing SQL file at /root/cloudstack/developer/target/db/templates.sql
> ========> Processing SQL file at /root/cloudstack/developer/target/db/cloudbridge_schema.sql
> ========> Processing SQL file at /root/cloudstack/developer/target/db/cloudbridge_multipart.sql
> ========> Processing SQL file at /root/cloudstack/developer/target/db/cloudbridge_index.sql
> ========> Processing SQL file at /root/cloudstack/developer/target/db/cloudbridge_multipart_alter.sql
> ========> Processing SQL file at /root/cloudstack/developer/target/db/cloudbridge_bucketpolicy.sql
> ========> Processing SQL file at /root/cloudstack/developer/target/db/cloudbridge_policy_alter.sql
> ========> Processing SQL file at /root/cloudstack/developer/target/db/cloudbridge_offering.sql
> ========> Processing SQL file at /root/cloudstack/developer/target/db/cloudbridge_offering_alter.sql
> ========> Processing SQL file at /root/cloudstack/developer/developer-prefill.sql
> ========> Processing upgrade: com.cloud.upgrade.DatabaseUpgradeChecker
> [WARNING]
> java.lang.reflect.InvocationTargetException
> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.lang.reflect.Method.invoke(Method.java:616)
> at org.codehaus.mojo.exec.ExecJavaMojo$1.run(ExecJavaMojo.java:297)
> at java.lang.Thread.run(Thread.java:679)
> Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to upgrade the database
> at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:337)
> at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:432)
> at com.cloud.upgrade.DatabaseCreator.main(DatabaseCreator.java:222)
> ... 6 more
> Caused by: com.cloud.utils.exception.CloudRuntimeException: Unable to execute upgrade script: /root/cloudstack/developer/target/db/db/schema-421to430.sql
> at com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:252)
> at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:306)
> ... 8 more
> Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'is_exclusive_gslb_provider'
> at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:193)
> at com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
> at com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:243)
> ... 9 more
> [INFO] ------------------------------------------------------------------------
> [INFO] BUILD FAILURE
> [INFO] ------------------------------------------------------------------------
> [INFO] Total time: 30.030s
> [INFO] Finished at: Tue Jan 07 05:45:06 EST 2014
> [INFO] Final Memory: 37M/90M
> [INFO] ------------------------------------------------------------------------
> [ERROR] Failed to execute goal org.codehaus.mojo:exec-maven-plugin:1.2.1:java (create-schema) on project cloud-developer: An exception occured while executing the Java class. null: InvocationTargetException: Unable to upgrade the database: Unable to execute upgrade script: /root/cloudstack/developer/target/db/db/schema-421to430.sql: Duplicate column name 'is_exclusive_gslb_provider' -> [Help 1]
> [ERROR]
> [ERROR] To see the full stack trace of the errors, re-run Maven with the -e switch.
> [ERROR] Re-run Maven using the -X switch to enable full debug logging.
> [ERROR]
> [ERROR] For more information about the errors and possible solutions, please read the following articles:
> [ERROR] [Help 1] http://cwiki.apache.org/confluence/display/MAVEN/MojoExecutionException
> [root@localhost cloudstack]# mysql
> Welcome to the MySQL monitor. Commands end with ; or \g.
> Your MySQL connection id is 1459
> Server version: 5.1.66-log Source distribution
> Copyright (c) 2000, 2012, Oracle and/or its affiliates. All rights reserved.
> Oracle is a registered trademark of Oracle Corporation and/or its
> affiliates. Other names may be trademarks of their respective
> owners.
> Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
> Setup Detail
> ===========
> [root@localhost cloudstack]# git branch
> 4.2
> 4.3
> * master
> origin
> root@localhost cloudstack]# git log --name-status HEAD^..HEAD
> commit c2b5addaedc47b3715b408a6d5a2aa356e7fcd1b
> Author: SrikanteswaraRao Talluri <ta...@apache.org>
> Date: Mon Jan 6 14:50:46 2014 +0530
> CLOUDSTACK-5625: removed unnecessary global setting 'ldap.realname.attribute'
> M test/integration/component/test_ldap.py
--
This message was sent by Atlassian JIRA
(v6.1.5#6160)