From cloudstack-users-return-37-apmail-incubator-cloudstack-users-archive=incubator.apache.org@incubator.apache.org Thu May 10 17:04:47 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 2E32999FA for ; Thu, 10 May 2012 17:04:47 +0000 (UTC) Received: (qmail 35055 invoked by uid 500); 10 May 2012 17:04:47 -0000 Delivered-To: apmail-incubator-cloudstack-users-archive@incubator.apache.org Received: (qmail 35025 invoked by uid 500); 10 May 2012 17:04:47 -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 35015 invoked by uid 99); 10 May 2012 17:04:47 -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 17:04:47 +0000 X-ASF-Spam-Status: No, hits=-5.0 required=5.0 tests=RCVD_IN_DNSWL_HI,SPF_HELO_PASS,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of Alena.Prokharchyk@citrix.com designates 66.165.176.89 as permitted sender) Received: from [66.165.176.89] (HELO SMTP.CITRIX.COM) (66.165.176.89) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 10 May 2012 17:04:41 +0000 X-IronPort-AV: E=Sophos;i="4.75,565,1330923600"; d="scan'208";a="25074016" Received: from sjcpmailmx01.citrite.net ([10.216.14.74]) by FTLPIPO01.CITRIX.COM with ESMTP/TLS/RC4-MD5; 10 May 2012 13:04:20 -0400 Received: from SJCPMAILBOX01.citrite.net ([10.216.4.73]) by SJCPMAILMX01.citrite.net ([10.216.14.74]) with mapi; Thu, 10 May 2012 10:04:19 -0700 From: Alena Prokharchyk To: "dan@soleks.com" CC: "cloudstack-users@incubator.apache.org" , Sheng Yang Date: Thu, 10 May 2012 10:04:17 -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: Ac0uzvDS+T3/zFxGR0aAjA1EBwv9VQ== Message-ID: In-Reply-To: <20120510104217.72816ca1il0yqeko@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/10/12 10:42 AM, "dan@soleks.com" wrote: >Alena, > =20 > Yup, i commented out that drop from sql script. Thanks for confirmation. > =20 > Can you please check my post on cloudstack-dev thread about public >networks assigned to regular account, seems like problem still persists. >=20 >> 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. >> >> >> >=20 > > >---------------------------------------------------------------- >This message was sent using IMP, the Internet Messaging Program. > Dan, Just sent you/community the email regarding account specific public range problem in multiple physical networks case. -Alena.