cloudstack-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dustin Wright <dwri...@untangledtechnology.com>
Subject Re: Failed CloudStack 4.6 Upgrade
Date Fri, 04 Dec 2015 00:08:33 GMT
Thanks for the advice. I am out of town, but will re-execute the upgrade
next week and document any hangups.

Cheers,

Dustin

On Thu, Dec 3, 2015 at 3:53 PM, Somesh Naidu <Somesh.Naidu@citrix.com>
wrote:

> Justin, to add to what Daan suggested, before you re-run the upgrade,
> ensure that you have reverted the DB (using the DB dump collected just
> prior to the upgrade) to avoid errors due to duplicate entries/columns.
>
> Somesh
> CloudPlatform Escalations
> Citrix Systems, Inc.
>
> -----Original Message-----
> From: Daan Hoogland [mailto:daan.hoogland@gmail.com]
> Sent: Tuesday, December 01, 2015 5:54 AM
> To: users@cloudstack.apache.org
> Subject: Re: Failed CloudStack 4.6 Upgrade
>
> Dustin, do the columns  `cloud`.`snapshots`.`min_iops` and
> `cloud`.`snapshots`.`max_iops` contain any significant data for you? If not
> you can delete them and rerun the upgrade. It seems like the upgrade has
> been started before this error and was aborted. Have a look at the file
> .../cloudstack/setup/db/db/schema-452to460.sql and see if any of the other
> changes in there are in your db. Also have a look at the version table to
> see whether it is at the version you expect.
>
> hope this helps,
>
> On Mon, Nov 30, 2015 at 5:54 PM, Dustin Wright <
> dwright@untangledtechnology.com> wrote:
>
> > I confirmed I have no additional plugins in use for storage or
> networking.
> > I’m using advanced /w basic VLAN networking (I went into the switches and
> > pre-assigned a few hundred VLAN’s). All of the servers (Storage,
> > Controller, Hypervisor) are all CentOS 6.7.
> >
> > Any suggestions on how I should proceed to upgrade this cloud?
> >
> > I built a new ACS 4.6 controller which is 100% vanilla just to ensure
> > everything worked on CentOS 6 new. I’m just not sure how to proceed with
> my
> > existing 4.5.2 deployment.
> >
> > Dustin W
> >
> > > On Nov 27, 2015, at 6:04 PM, Simon Weller <sweller@ena.com> wrote:
> > >
> > > There are not meant to be scheme changes on minor releases, but we'll
> > have to go and look back at the sql files in git to confirm that.
> > >
> > > Do you have any additional plugins in use (i.e. storage, or
> networking)?
> > >
> > >
> > > ________________________________________
> > > From: Dustin Wright <dwright@untangledtechnology.com>
> > > Sent: Wednesday, November 25, 2015 11:55 AM
> > > To: users@cloudstack.apache.org
> > > Subject: Re: Failed CloudStack 4.6 Upgrade
> > >
> > > Simon,
> > >
> > > I did as suggested and got a new SQL error further down the script
> (line
> > 154, user_id) see below...
> > >
> > > I also found it strange the file schema-452to460.sql has the following
> > copy at the top..
> > >
> > > --
> > > -- Schema upgrade from 4.5.1 to 4.6.0
> > > —
> > >
> > > Shouldn’t it read 4.5.2 to 4.6.0?
> > >
> > > [root@controller ~]# mysql cloud <
> > /usr/share/cloudstack-management/setup/db/schema-452to460.sql
> > > ERROR 1060 (42S21) at line 22: Duplicate column name 'min_iops'
> > > [root@controller ~]# vi
> > /usr/share/cloudstack-management/setup/db/schema-452to460.sql
> > > [root@controller ~]# mysql cloud <
> > /usr/share/cloudstack-management/setup/db/schema-452to460.sql
> > > ERROR 1060 (42S21) at line 154: Duplicate column name ‘user_id’
> > >
> > > Dustin W
> > >
> > >> On Nov 25, 2015, at 10:29 AM, Simon Weller <sweller@ena.com> wrote:
> > >>
> > >> Try commenting out both the min_iops and max_iops lines.
> > >>
> > >>
> > >>
> > >> ________________________________________
> > >> From: Dustin Wright <dwright@untangledtechnology.com>
> > >> Sent: Wednesday, November 25, 2015 8:58 AM
> > >> To: users@cloudstack.apache.org
> > >> Subject: Re: Failed CloudStack 4.6 Upgrade
> > >>
> > >> This was a fresh 4.5.2 install. No previous upgrades.
> > >>
> > >> I tried commenting out the offending SQL and it errors on the next
> line.
> > >>
> > >> I will try to gather more info later today after I put out some other
> > fires.
> > >>
> > >> Dustin
> > >>
> > >>
> > >>
> > >> Sent from my iPhone
> > >>
> > >>> On Nov 25, 2015, at 7:51 AM, Simon Weller <sweller@ena.com> wrote:
> > >>>
> > >>> Dustin,
> > >>>
> > >>> Was 4.5.2 a fresh install, or did you upgrade from a previous version
> > to it? If so, can you tell us the upgrade order?
> > >>>
> > >>> - Si
> > >>>
> > >>>
> > >>> ________________________________________
> > >>> From: Dustin Wright <dwright@untangledtechnology.com>
> > >>> Sent: Wednesday, November 25, 2015 6:21 AM
> > >>> To: users@cloudstack.apache.org
> > >>> Subject: Re: Failed CloudStack 4.6 Upgrade
> > >>>
> > >>> This was a fairly vanilla ACS 4.5.2. It has maybe 1 cluster, 6 HV's
> > and 10 HVM VM's with advanced networking (single port, vlan)
> > >>>
> > >>> Never touched DB or UI.
> > >>>
> > >>> All I did to upgrade was removed AWS APi as directed and loaded up
> the
> > 4.6 repo.
> > >>>
> > >>> I was going to troubleshoot more today might restore back.
> > >>>
> > >>> Dustin
> > >>>
> > >>> Sent from my iPhone
> > >>>
> > >>>> On Nov 25, 2015, at 5:56 AM, Rajani Karuturi <rajani@apache.org>
> > wrote:
> > >>>>
> > >>>> from which version are you trying to upgrade? Were there any custom
> > changes
> > >>>> on top of ACS?
> > >>>>
> > >>>> ~Rajani
> > >>>>
> > >>>> On Tue, Nov 24, 2015 at 3:39 AM, Dustin Wright <
> > >>>> dwright@untangledtechnology.com> wrote:
> > >>>>
> > >>>>> I’ve facing an SQL error while trying to upgrade a CloudStack
> > environment.
> > >>>>> Any suggestions?
> > >>>>>
> > >>>>> [root@controller management]# tail management-server.log -f
> > >>>>> Caused by: com.cloud.utils.exception.CloudRuntimeException:
Unable
> to
> > >>>>> execute upgrade script:
> > >>>>> /usr/share/cloudstack-management/setup/db/schema-452to460.sql
> > >>>>>     at
> > >>>>>
> >
> com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:284)
> > >>>>>     at
> > >>>>>
> >
> com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:341)
> > >>>>>     at
> > >>>>>
> >
> com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:468)
> > >>>>>     ... 45 more
> > >>>>> Caused by:
> com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException:
> > >>>>> Duplicate column name 'min_iops'
> > >>>>>     at
> > com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:185)
> > >>>>>     at
> > com.cloud.utils.db.ScriptRunner.runScript(ScriptRunner.java:87)
> > >>>>>     at
> > >>>>>
> >
> com.cloud.upgrade.DatabaseUpgradeChecker.runScript(DatabaseUpgradeChecker.java:275)
> > >>>>>     ... 47 more
> > >>>>> ^C
> > >>>>> [root@controller management]# mysql cloud <
> > >>>>> /usr/share/cloudstack-management/setup/db/schema-452to460.sql
> > >>>>> ERROR 1060 (42S21) at line 22: Duplicate column name 'min_iops'
> > >
> >
> >
>
>
> --
> Daan
>

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message