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 E8007105E0 for ; Tue, 9 Jul 2013 23:37:56 +0000 (UTC) Received: (qmail 24817 invoked by uid 500); 9 Jul 2013 23:37:56 -0000 Delivered-To: apmail-cloudstack-issues-archive@cloudstack.apache.org Received: (qmail 24803 invoked by uid 500); 9 Jul 2013 23:37:56 -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 24795 invoked by uid 500); 9 Jul 2013 23:37:56 -0000 Delivered-To: apmail-incubator-cloudstack-issues@incubator.apache.org Received: (qmail 24792 invoked by uid 99); 9 Jul 2013 23:37:56 -0000 Received: from arcas.apache.org (HELO arcas.apache.org) (140.211.11.28) by apache.org (qpsmtpd/0.29) with ESMTP; Tue, 09 Jul 2013 23:37:56 +0000 Date: Tue, 9 Jul 2013 23:37:56 +0000 (UTC) From: "ASF subversion and git services (JIRA)" To: cloudstack-issues@incubator.apache.org Message-ID: In-Reply-To: References: Subject: [jira] [Commented] (CLOUDSTACK-3417) [Upgrade to 4.2.0] Upgrade to 4.2.0 fails with om.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'cloud.baremetal_dhcp_devices' doesn't exist MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-JIRA-FingerPrint: 30527f35849b9dde25b450d4833f0394 [ https://issues.apache.org/jira/browse/CLOUDSTACK-3417?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13704008#comment-13704008 ] ASF subversion and git services commented on CLOUDSTACK-3417: ------------------------------------------------------------- Commit 7d8f6c70221fddd9227f7270b05245c2dd973d5b in branch refs/heads/master from [~yasker] [ https://git-wip-us.apache.org/repos/asf?p=cloudstack.git;h=7d8f6c7 ] CLOUDSTACK-3417: Prevent conflict of existed foreign keys of baremetal when upgrade Now we dropped the keys(if any) then re-add them. > [Upgrade to 4.2.0] Upgrade to 4.2.0 fails with om.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'cloud.baremetal_dhcp_devices' doesn't exist > ------------------------------------------------------------------------------------------------------------------------------------------------------------ > > Key: CLOUDSTACK-3417 > URL: https://issues.apache.org/jira/browse/CLOUDSTACK-3417 > Project: CloudStack > Issue Type: Bug > Security Level: Public(Anyone can view this level - this is the default.) > Components: Install and Setup > Affects Versions: 4.2.0 > Reporter: Abhinav Roy > Assignee: Sheng Yang > Priority: Blocker > Fix For: 4.2.0 > > Attachments: management-server.log > > > Upgrade from CS 3.0.6 to 4.2.0 fails with the following error : > 2013-07-09 16:08:56,133 ERROR [utils.db.ScriptRunner] (Timer-1:null) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'cloud.baremetal_dhcp_devices' doesn't exist > 2013-07-09 16:08:56,135 ERROR [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) Unable to execute upgrade script: /usr/share/cloudstack-management/setup/db/schema-410to420.sql > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'cloud.baremetal_dhcp_devices' doesn't exist > 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:211) > at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:272) > at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:401) > at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:90) > at com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:50) > at java.util.TimerThread.mainLoop(Timer.java:534) > at java.util.TimerThread.run(Timer.java:484) > 2013-07-09 16:08:56,139 ERROR [cloud.upgrade.DatabaseUpgradeChecker] (Timer-1:null) Unable to upgrade the database > com.cloud.utils.exception.CloudRuntimeException: Unable to execute upgrade script: /usr/share/cloudstack-management/setup/db/schema-410to420.sql > at com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:220) > at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:272) > at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:401) > at com.cloud.utils.component.ComponentContext.initComponentsLifeCycle(ComponentContext.java:90) > at com.cloud.servlet.CloudStartupServlet$1.run(CloudStartupServlet.java:50) > at java.util.TimerThread.mainLoop(Timer.java:534) > at java.util.TimerThread.run(Timer.java:484) > Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'cloud.baremetal_dhcp_devices' doesn't exist > 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:211) > ... 6 more > 2013-07-09 16:08:56,144 DEBUG [db.Transaction.Transaction] (Timer-1:null) Rolling back the transaction: Time = 1467 Name = null; called by -Transaction.rollback:890-Transaction.removeUpTo:833-Transaction.close:657-DatabaseUpgradeChecker.upgrade:305-DatabaseUpgradeChecker.check:401-ComponentContext.initComponentsLifeCycle:90-CloudStartupServlet$1.run:50-TimerThread.mainLoop:534-TimerThread.run:484 > 2013-07-09 16:08:56,144 ERROR [utils.component.ComponentContext] (Timer-1:null) System integrity check failed. Refuse to startup -- This message is automatically generated by JIRA. If you think it was sent incorrectly, please contact your JIRA administrators For more information on JIRA, see: http://www.atlassian.com/software/jira