[ 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 <tall...@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)