Re: Failed CloudStack 4.6 Upgrade
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 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 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 > > > 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 wrote: > > >> > > >> Try commenting out both the min_iops and max_iops lines. > > >> > > >> > > >> > > >> > > >> From: Dustin Wright > > >> 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 wrote: > > >>> > > >>> Dustin, > > >>> > > >>> Was 4.5.2 a fresh install, or did you upgrade from a previous version > > to it? If so, can
RE: Failed CloudStack 4.6 Upgrade
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 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 > > 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 wrote: > >> > >> Try commenting out both the min_iops and max_iops lines. > >> > >> > >> > >> > >> From: Dustin Wright > >> 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 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 > >>> 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. > >>> &
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 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 > > 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 wrote: > >> > >> Try commenting out both the min_iops and max_iops lines. > >> > >> > >> > >> > >> From: Dustin Wright > >> 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 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 > >>> 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 > wrote: > >>>> > >>>> from which version are you trying to upgrade? Were there any custom > changes > >>>> on top of ACS? > >>>> > >>
Re: Failed CloudStack 4.6 Upgrade
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 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 > 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 wrote: >> >> Try commenting out both the min_iops and max_iops lines. >> >> >> >> ________ >> From: Dustin Wright >> 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 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 >>> 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 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' >
Re: Failed CloudStack 4.6 Upgrade
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 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 wrote: > > Try commenting out both the min_iops and max_iops lines. > > > > > From: Dustin Wright > 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 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 >> 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 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'
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 wrote: > > Try commenting out both the min_iops and max_iops lines. > > > > > From: Dustin Wright > 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 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 >> 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 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'
Re: Failed CloudStack 4.6 Upgrade
Try commenting out both the min_iops and max_iops lines. From: Dustin Wright 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 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 > 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 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'
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 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 > 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 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'
Re: Failed CloudStack 4.6 Upgrade
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 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 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'
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 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'
Re: Failed CloudStack 4.6 Upgrade
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'
Failed CloudStack 4.6 Upgrade
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'
