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.na...@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.hoogl...@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 < > dwri...@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 <swel...@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 <dwri...@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 <swel...@ena.com> wrote: > > >> > > >> Try commenting out both the min_iops and max_iops lines. > > >> > > >> > > >> > > >> ________________________________________ > > >> From: Dustin Wright <dwri...@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 <swel...@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 <dwri...@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 <raj...@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 < > > >>>> dwri...@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 >