Return-Path: X-Original-To: apmail-cloudstack-issues-archive@www.apache.org Delivered-To: apmail-cloudstack-issues-archive@www.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id DD12F107DC for ; Tue, 7 Jan 2014 10:24:13 +0000 (UTC) Received: (qmail 87512 invoked by uid 500); 7 Jan 2014 10:24:01 -0000 Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org Received: (qmail 87443 invoked by uid 500); 7 Jan 2014 10:23:55 -0000 Mailing-List: contact issues-help@cloudstack.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: dev@cloudstack.apache.org Delivered-To: mailing list issues@cloudstack.apache.org Received: (qmail 87418 invoked by uid 500); 7 Jan 2014 10:23:52 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 87402 invoked by uid 99); 7 Jan 2014 10:23:50 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 07 Jan 2014 10:23:50 +0000 Date: Tue, 7 Jan 2014 10:23:50 +0000 (UTC) From: "prashant kumar mishra (JIRA)" To: cloudstack-issues@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Created] (CLOUDSTACK-5817) [Dev Setup]Deploy Db is failing on master and 4.3 MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 prashant kumar mishra created CLOUDSTACK-5817: ------------------------------------------------- Summary: [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 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 * master root@localhost cloudstack]# git log --name-status HEAD^..HEAD commit c2b5addaedc47b3715b408a6d5a2aa356e7fcd1b Author: SrikanteswaraRao Talluri 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)