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 09D3B99D9 for ; Wed, 23 May 2012 20:40:56 +0000 (UTC) Received: (qmail 84890 invoked by uid 500); 23 May 2012 20:40:55 -0000 Delivered-To: apmail-incubator-cloudstack-users-archive@incubator.apache.org Received: (qmail 84859 invoked by uid 500); 23 May 2012 20:40:55 -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 84851 invoked by uid 99); 23 May 2012 20:40:55 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 23 May 2012 20:40:55 +0000 X-ASF-Spam-Status: No, hits=1.7 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (athena.apache.org: domain of scr512@gmail.com designates 209.85.215.47 as permitted sender) Received: from [209.85.215.47] (HELO mail-lpp01m010-f47.google.com) (209.85.215.47) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 23 May 2012 20:40:51 +0000 Received: by lags15 with SMTP id s15so5611582lag.6 for ; Wed, 23 May 2012 13:40:29 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=mime-version:in-reply-to:references:date:message-id:subject:from:to :content-type; bh=1Mwbb6xEaVoWXwmROdgo4Ch/1ex/CvCSJGHjTG6a6o0=; b=dBfKhQZqH2o3KwGAJcVeTk/TAOkGSyQlT0o9Zzsk3IOcJUDqGBeB7xqlbROc8wYww3 1f3e2BItRQoqZ2XvUdANS68Re5RHr4nFEVUJ+TSO4ZiDHXNChNPwAlJXVj4ehEY//MAL UabzTaAyD9946rV9yQwQIjHfbcMrbLbJxPTuqU/GuRbJXMkSerfuP61thvFlwvCI8wYO J5MoAWyBQqfMLY81SeXRBsBFf6o+zIlWvHjbuFMzKFeSrOPAdKpqftWUaPkLTSs2hZy3 TZAW++wIAU7Nv1TxYk0i5s9UJYinOYkpkfgHBuYyjVCw1hsct9Z3dr2qJ3cOT4xnuRDZ kfqA== MIME-Version: 1.0 Received: by 10.112.46.135 with SMTP id v7mr12593829lbm.3.1337805629433; Wed, 23 May 2012 13:40:29 -0700 (PDT) Received: by 10.112.46.197 with HTTP; Wed, 23 May 2012 13:40:28 -0700 (PDT) In-Reply-To: References: Date: Wed, 23 May 2012 15:40:28 -0500 Message-ID: Subject: Re: Anyone try upgrading from 2.2.14 to 3.0.2? From: Jason Davis To: cloudstack-users@incubator.apache.org Content-Type: multipart/mixed; boundary=bcaec55240be52282904c0ba2577 X-Virus-Checked: Checked by ClamAV on apache.org --bcaec55240be52282904c0ba2577 Content-Type: multipart/alternative; boundary=bcaec55240be52281104c0ba2575 --bcaec55240be52281104c0ba2575 Content-Type: text/plain; charset=ISO-8859-1 Here you go. Not sure if attachments will work. If that is true then I have it available here as well: https://www.box.com/s/3ad5f1cae4230eb02580 On Wed, May 23, 2012 at 3:32 PM, Alena Prokharchyk < Alena.Prokharchyk@citrix.com> wrote: > On 5/23/12 12:54 PM, "Jason Davis" wrote: > > >Would it be better to include these dumps on the original bug submission > >in > >Jira or replying here in the mailing list? > > > Replying here. > > > > > >On Wed, May 23, 2012 at 2:15 PM, Alena Prokharchyk < > >Alena.Prokharchyk@citrix.com> wrote: > > > >> On 5/23/12 8:55 AM, "Jason Davis" wrote: > >> > >> >I've tried the upgrade in my development environment and this has > >>largely > >> >worked other than the fact that the API command "listHosts" seems to > >>now > >> >be > >> >broken. I've also tried doing a clean install of 3.0.2 and then > >>restoring > >> >a > >> >backup copy of my MySQL DB of the 2.2.14-3.0.2 upgrade and still > >>encounter > >> >the same issue. > >> > > >> > > >> >I've opened a bug report > >>here:http://bugs.cloudstack.org/browse/CS-14846 > >> > > >> >Just curious if anyone else has tried this and have had this work > >> >successfully. > >> > > >> > >> > >> > >> The bug indicates that there are some references in > >> "cloud.storage_pool_host_ref" table to the removed Local Storage > >>instance > >> ("cloud.storage_pool" table). The references were supposed to be removed > >> along with the storage removal, but due to some bug they were left > >>around. > >> > >> To debug the problem, I need the mysql db dumps of following cloudStack > >> tables (2 versions - before and after upgrade): > >> > >> * host > >> * storage_pool_host_ref > >> * storage_pool; > >> > >> > >> Thanks, > >> Alena. > >> > >> > >> > >> > >> > > > > > --bcaec55240be52281104c0ba2575 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Here you go. Not sure if=A0attachments=A0will work. If that is true then I = have it available here as well: https://www.box.com/s/3ad5f1cae4230eb02580=A0



On Wed, May 23, 2012 at 3:32 PM, Alena P= rokharchyk <Alena.Prokharchyk@citrix.com> wrote:<= br>
On 5/23/12 12:54 PM, "Jason Davis" <scr512@gmail.com> wrote:

>Would it be better to include these dumps on the original bug submissio= n
>in
>Jira or replying here in the mailing list?


Replying here.


>
>On Wed, May 23, 2012 at 2:15 PM, Alena Prokharchyk <
>Alena.Prokharchyk@citri= x.com> wrote:
>
>> On 5/23/12 8:55 AM, "Jason Davis" <scr512@gmail.com> wrote:
>>
>> >I've tried the upgrade in my development environment and t= his has
>>largely
>> >worked other than the fact that the API command "listHost= s" seems to
>>now
>> >be
>> >broken. I've also tried doing a clean install of 3.0.2 and= then
>>restoring
>> >a
>> >backup copy of my MySQL DB of the 2.2.14-3.0.2 upgrade and sti= ll
>>encounter
>> >the same issue.
>> >
>> >
>> >I've opened a bug report
>>here:http://bugs.cloudstack.org/browse/CS-14846
>> >
>> >Just curious if anyone else has tried this and have had this w= ork
>> >successfully.
>> >
>>
>>
>>
>> The bug indicates that there are some references in
>> "cloud.storage_pool_host_ref" table to the removed Local= Storage
>>instance
>> ("cloud.storage_pool" table). The references were suppos= ed to be removed
>> along with the storage removal, but due to some bug they were left=
>>around.
>>
>> To debug the problem, I need the mysql db dumps of following cloud= Stack
>> tables (2 versions - before and after upgrade):
>>
>> * host
>> * storage_pool_host_ref
>> * storage_pool;
>>
>>
>> Thanks,
>> Alena.
>>
>>
>>
>>
>>
>



--bcaec55240be52281104c0ba2575-- --bcaec55240be52282904c0ba2577--