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'

Reply via email to