From cloudstack-users-return-33-apmail-incubator-cloudstack-users-archive=incubator.apache.org@incubator.apache.org Thu May 10 16:41:07 2012 Return-Path: X-Original-To: apmail-incubator-cloudstack-users-archive@minotaur.apache.org Delivered-To: apmail-incubator-cloudstack-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 865789931 for ; Thu, 10 May 2012 16:41:07 +0000 (UTC) Received: (qmail 64093 invoked by uid 500); 10 May 2012 16:41:07 -0000 Delivered-To: apmail-incubator-cloudstack-users-archive@incubator.apache.org Received: (qmail 64072 invoked by uid 500); 10 May 2012 16:41:07 -0000 Mailing-List: contact cloudstack-users-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cloudstack-users@incubator.apache.org Delivered-To: mailing list cloudstack-users@incubator.apache.org Received: (qmail 64063 invoked by uid 99); 10 May 2012 16:41:07 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 10 May 2012 16:41:07 +0000 X-ASF-Spam-Status: No, hits=0.4 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_HELO_PASS,SPF_PASS,TRACKER_ID X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of Alena.Prokharchyk@citrix.com designates 66.165.176.63 as permitted sender) Received: from [66.165.176.63] (HELO SMTP02.CITRIX.COM) (66.165.176.63) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 10 May 2012 16:41:02 +0000 X-IronPort-AV: E=Sophos;i="4.75,565,1330923600"; d="scan'208";a="194299458" Received: from sjcpmailmx02.citrite.net ([10.216.14.75]) by FTLPIPO02.CITRIX.COM with ESMTP/TLS/RC4-MD5; 10 May 2012 12:39:55 -0400 Received: from SJCPMAILBOX01.citrite.net ([10.216.4.73]) by SJCPMAILMX02.citrite.net ([10.216.14.75]) with mapi; Thu, 10 May 2012 09:39:55 -0700 From: Alena Prokharchyk To: "cloudstack-users@incubator.apache.org" , Sheng Yang , "dan@soleks.com" Date: Thu, 10 May 2012 09:39:54 -0700 Subject: Re: DB schema upgrade script for CS 3.0.1 -> 3.0.2, probably bug. Thread-Topic: DB schema upgrade script for CS 3.0.1 -> 3.0.2, probably bug. Thread-Index: Ac0uy4dNonyO9vJTTQyfR9SYZtOByA== Message-ID: In-Reply-To: <20120509233209.29813vpfxz6ktcmc@webmail.soleks.com> Accept-Language: en-US Content-Language: en-US X-MS-Has-Attach: X-MS-TNEF-Correlator: user-agent: Microsoft-MacOutlook/14.2.0.120402 acceptlanguage: en-US Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Virus-Checked: Checked by ClamAV on apache.org On 5/9/12 11:32 PM, "dan@soleks.com" wrote: > > > >Hi All, >I've found that DB schema upgrade script (CS 3.0.1 ---> CS 3.0.2) is >trying to drop non-existing index. Log is attached. > >Dan. > > > > > >---------------------------------------------------------------- >This message was sent using IMP, the Internet Messaging Program. > Sheng, this is bug introduced by your commit: 06c0fda878247020d79bb1008f8bf050070f1e73 We are trying to drop non-existing index. To be on the safe side, move this line to java code, and drop the key only when it exists. Dan, to workaround the problem on your side, do: * revert DB to your original version * comment out the line "DROP INDEX `i_host__allocation_state` ON `cloud`.`host`" in schema-301to302.sql * being on 3.0.2, start management server once again -Alena.