Re: Failed CloudStack 4.6 Upgrade

[Daan Hoogland <da...@gmail.com>]

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 <sw...@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 <dw...@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 <sw...@ena.com> wrote:
> >>
> >> Try commenting out both the min_iops and max_iops lines.
> >>
> >>
> >>
> >> ________________________________________
> >> From: Dustin Wright <dw...@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 <sw...@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 <dw...@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 <ra...@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