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' >
