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'
