Mailing-List: contact cloudstack-users-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cloudstack-users@incubator.apache.org
Received-SPF: neutral (athena.apache.org: local policy)
From: Tamas Monos <tamasm@veber.co.uk>
To: "cloudstack-users@incubator.apache.org"
	<cloudstack-users@incubator.apache.org>, Sheng Yang <Sheng.Yang@citrix.com>,
	"dan@soleks.com" <dan@soleks.com>
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: Ac0uy4dNonyO9vJTTQyfR9SYZtOByAAAs7YA
Date: Thu, 10 May 2012 17:01:35 +0000
Message-ID: 
 <CE854734D1A2D941BA87A532AA5DB064BC4045@AMXPRD0610MB388.eurprd06.prod.outlook.com>
References: <20120509233209.29813vpfxz6ktcmc@webmail.soleks.com>
 <CBD13CE2.4F1B%alena.prokharchyk@citrix.com>
In-Reply-To: <CBD13CE2.4F1B%alena.prokharchyk@citrix.com>
Accept-Language: en-GB, en-US
Content-Language: en-US
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0

Hi,

Same here!
I have fixed the script by hand and the server started but does not allow t=
o login users anymore :(

Regards

Tamas Monos                                               DDI         +44(0=
)2034687012
Chief Technical                                             Office    +44(0=
)2034687000
Veber: The Hosting Specialists               Fax         +44(0)871 522 7057
http://www.veber.co.uk

Follow us on Twitter: www.twitter.com/veberhost
Follow us on Facebook: www.facebook.com/veberhost


-----Original Message-----
From: Alena Prokharchyk [mailto:Alena.Prokharchyk@citrix.com]=20
Sent: 10 May 2012 17:40
To: cloudstack-users@incubator.apache.org; Sheng Yang; dan@soleks.com
Subject: Re: DB schema upgrade script for CS 3.0.1 -> 3.0.2, probably bug.

On 5/9/12 11:32 PM, "dan@soleks.com" <dan@soleks.com> wrote:

>
>
>
>Hi All,
>I've found that DB schema upgrade script (CS 3.0.1 ---> CS 3.0.2) is=20
>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`.`h=
ost`" in schema-301to302.sql
* being on 3.0.2, start management server once again


-Alena.