Re: Cloudstack 4.11.3 to 4.13.1 DB Upgrade Error
Correcting few typos: There are 2 possibilities here 1. Since column reаson was added to table network_acl_item during the DB schema upgrade from 4.11.2 to 4.12 this likely means that your upgrade failed on a later step and you've tried to re-execute upgrade script. If so this is not a right sequence of recovering from a failed upgrade. You need to restore DB to pre-upgrade state and re-execute all according to the guide. You need to capture full management_server.log to figure you what went wrong 2. You might have upgraded to 4.11.3 using RC or pre-released code where column insertion happens during 4.11.2->4.11.3 phase that later was removed from the ACS master. If that's the case there is way to succeed although longer and not as pleasant. You still need to try #1 to capture and share full management_server.log On 7/19/20, 3:56 AM, "Rakesh v" wrote: From the log, it looks like the column "reason" already exists in network_acl_item table. Does this take suppose to have that field in 4.11? Sent from my iPhone > On 19-Jul-2020, at 9:30 AM, Ammad Syed wrote: > > Hi, > > I am trying to upgrade cloudstack from 4.11.3 to 4.13.1. I am having below > db upgrade error while upgrading. I think the upgrade is executing wrong > script i.e from 4.11.2 to 4.12.0. Please advise. > > 2020-07-13 20:29:37,650 INFO [o.a.c.s.l.CloudStackExtendedLifeCycle] > (main:null) (logid:) Running system integrity checker > com.cloud.upgrade.DatabaseUpgradeChecker@8dfe921 > 2020-07-13 20:29:37,651 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) Grabbing lock to check for database upgrade. > 2020-07-13 20:29:37,684 DEBUG [c.c.u.d.VersionDaoImpl] (main:null) (logid:) > Checking to see if the database is at a version before it was the version > table is created > 2020-07-13 20:29:37,701 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) DB version = 4.11.3.0 Code Version = 4.13.1.0 > 2020-07-13 20:29:37,701 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) Database upgrade must be performed from 4.11.3.0 to 4.13.1.0 > 2020-07-13 20:29:37,712 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) Running upgrade Upgrade41120to41200 to upgrade from > 4.11.2.0-4.12.0.0 to 4.12.0.0 > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- Licensed to the Apache Software Foundation (ASF) under one > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- or more contributor license agreements. See the NOTICE file > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- distributed with this work for additional information > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- regarding copyright ownership. The ASF licenses this file > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- to you under the Apache License, Version 2.0 (the > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- "License"); you may not use this file except in compliance > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- with the License. You may obtain a copy of the License at > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- http://www.apache.org/licenses/LICENSE-2.0 > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- Unless required by applicable law or agreed to in writing, > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- software distributed under the License is distributed on an > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- KIND, either express or implied. See the License for the > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- specific language governing permissions and limitations > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- under the License. > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > --; > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- Schema upgrade from 4.11.2.0 to
Re: Cloudstack 4.11.3 to 4.13.1 DB Upgrade Error
There are 2 possibilities here 1. Since column reаson was added to table network_acl_item during the DB schema upgrade from 4.11.12 to 4.12 this likely means that your upgrade failed on a later step and you've tried to re-execute upgrade script. If so this is not a right sequence of recovering from a failed upgrade. You need to restore DB to pre-upgrade state and re-execute all according to the guide. You need to capture full management_server.log to figure you what went wrong 2. You might have upgraded to 4.11.3 using RC or pre-released code where column insertion happens during 4.11.12->4.11.13 phase that later was removed from the ACS master. If that's the case there is way to succeed although longer and not as pleasant. You still need to try #1 to capture and share full management_server.log On 7/19/20, 3:56 AM, "Rakesh v" wrote: From the log, it looks like the column "reason" already exists in network_acl_item table. Does this take suppose to have that field in 4.11? Sent from my iPhone > On 19-Jul-2020, at 9:30 AM, Ammad Syed wrote: > > Hi, > > I am trying to upgrade cloudstack from 4.11.3 to 4.13.1. I am having below > db upgrade error while upgrading. I think the upgrade is executing wrong > script i.e from 4.11.2 to 4.12.0. Please advise. > > 2020-07-13 20:29:37,650 INFO [o.a.c.s.l.CloudStackExtendedLifeCycle] > (main:null) (logid:) Running system integrity checker > com.cloud.upgrade.DatabaseUpgradeChecker@8dfe921 > 2020-07-13 20:29:37,651 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) Grabbing lock to check for database upgrade. > 2020-07-13 20:29:37,684 DEBUG [c.c.u.d.VersionDaoImpl] (main:null) (logid:) > Checking to see if the database is at a version before it was the version > table is created > 2020-07-13 20:29:37,701 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) DB version = 4.11.3.0 Code Version = 4.13.1.0 > 2020-07-13 20:29:37,701 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) Database upgrade must be performed from 4.11.3.0 to 4.13.1.0 > 2020-07-13 20:29:37,712 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) Running upgrade Upgrade41120to41200 to upgrade from > 4.11.2.0-4.12.0.0 to 4.12.0.0 > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- Licensed to the Apache Software Foundation (ASF) under one > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- or more contributor license agreements. See the NOTICE file > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- distributed with this work for additional information > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- regarding copyright ownership. The ASF licenses this file > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- to you under the Apache License, Version 2.0 (the > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- "License"); you may not use this file except in compliance > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- with the License. You may obtain a copy of the License at > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- http://www.apache.org/licenses/LICENSE-2.0 > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- Unless required by applicable law or agreed to in writing, > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- software distributed under the License is distributed on an > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- KIND, either express or implied. See the License for the > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- specific language governing permissions and limitations > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- under the License. > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > --; > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- Schema upgrade from 4.11.2.0 to 4.12.0.0 > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > --; > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- [CLOUDSTACK-10314] Add reason column to ACL rule table > 2020-07-13 20:29:37,716 DEBUG
Re: Need Support
You need to cleanup entry in vmware_data_center table e.g. assuming you have unique vmware datacenter names: delete from vmware_data_center where name='name_of_your_datacenter' Thanks, Sergey On 7/18/20, 9:22 AM, "Rakesh v" wrote: All the cloudstack management logs are stored in /var/log/cloudstack/management/management-server.log Search for "error|fail|exception" in the log Sent from my iPhone > On 18-Jul-2020, at 11:21 AM, Ajit Singh wrote: > > Hi Rakesh > > Can you pls guide how to get logs for the same as I not well versed with > apache cloud stack > > Regards > Ajit Singh > >> On Sat, Jul 18, 2020 at 1:58 PM Rakesh v wrote: >> >> Providing exceptions in the logs will be more helpful >> >> Sent from my iPhone >> On 18-Jul-2020, at 7:46 AM, Ajit Singh wrote: >>> >>> Dear All >>> >>> I am new to Apache Cloud Stack and we have one already running in our >>> office infra and it has 3 zones having hypervisors as Xenservers and >>> management servers are also installed on Xenservers. >>> >>> Now, I am trying to add VMware vsphere in the existing Apache Cloud Stack >>> through it's UI by creating a new zone but not able to do so. It throws >>> below errors. >>> >>> *Something went wrong; please correct the following: This DC is already >>> part of other CloudStack zone(s). Cannot add this DC to more zones.* >>> >>> and if I am able to resolve the above error, it throws another error >>> >>> *Something went wrong; please correct the following: unable to add the >>> external cluster* >>> >>> It would be great if somebody can help me out with the above mentioned >>> errors. >>> >>> Regards >>> Ajit Singh >>
Re: Cloudstack 4.11.3 to 4.13.1 DB Upgrade Error
From the log, it looks like the column "reason" already exists in network_acl_item table. Does this take suppose to have that field in 4.11? Sent from my iPhone > On 19-Jul-2020, at 9:30 AM, Ammad Syed wrote: > > Hi, > > I am trying to upgrade cloudstack from 4.11.3 to 4.13.1. I am having below > db upgrade error while upgrading. I think the upgrade is executing wrong > script i.e from 4.11.2 to 4.12.0. Please advise. > > 2020-07-13 20:29:37,650 INFO [o.a.c.s.l.CloudStackExtendedLifeCycle] > (main:null) (logid:) Running system integrity checker > com.cloud.upgrade.DatabaseUpgradeChecker@8dfe921 > 2020-07-13 20:29:37,651 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) Grabbing lock to check for database upgrade. > 2020-07-13 20:29:37,684 DEBUG [c.c.u.d.VersionDaoImpl] (main:null) (logid:) > Checking to see if the database is at a version before it was the version > table is created > 2020-07-13 20:29:37,701 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) DB version = 4.11.3.0 Code Version = 4.13.1.0 > 2020-07-13 20:29:37,701 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) Database upgrade must be performed from 4.11.3.0 to 4.13.1.0 > 2020-07-13 20:29:37,712 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) Running upgrade Upgrade41120to41200 to upgrade from > 4.11.2.0-4.12.0.0 to 4.12.0.0 > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- Licensed to the Apache Software Foundation (ASF) under one > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- or more contributor license agreements. See the NOTICE file > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- distributed with this work for additional information > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- regarding copyright ownership. The ASF licenses this file > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- to you under the Apache License, Version 2.0 (the > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- "License"); you may not use this file except in compliance > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- with the License. You may obtain a copy of the License at > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- http://www.apache.org/licenses/LICENSE-2.0 > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- Unless required by applicable law or agreed to in writing, > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- software distributed under the License is distributed on an > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- KIND, either express or implied. See the License for the > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- specific language governing permissions and limitations > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- under the License. > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > --; > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- Schema upgrade from 4.11.2.0 to 4.12.0.0 > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > --; > 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > -- [CLOUDSTACK-10314] Add reason column to ACL rule table > 2020-07-13 20:29:37,716 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) > ALTER TABLE `cloud`.`network_acl_item` ADD COLUMN `reason` VARCHAR(2500) > AFTER `display` > 2020-07-13 20:29:37,718 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) > Error executing: ALTER TABLE `cloud`.`network_acl_item` ADD COLUMN `reason` > VARCHAR(2500) AFTER `display` > 2020-07-13 20:29:37,718 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column > name 'reason' > 2020-07-13 20:29:37,719 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) > (logid:) Unable to execute upgrade script > com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column > name 'reason' >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:199) >at > com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:254) >at >
Cloudstack 4.11.3 to 4.13.1 DB Upgrade Error
Hi, I am trying to upgrade cloudstack from 4.11.3 to 4.13.1. I am having below db upgrade error while upgrading. I think the upgrade is executing wrong script i.e from 4.11.2 to 4.12.0. Please advise. 2020-07-13 20:29:37,650 INFO [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Running system integrity checker com.cloud.upgrade.DatabaseUpgradeChecker@8dfe921 2020-07-13 20:29:37,651 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Grabbing lock to check for database upgrade. 2020-07-13 20:29:37,684 DEBUG [c.c.u.d.VersionDaoImpl] (main:null) (logid:) Checking to see if the database is at a version before it was the version table is created 2020-07-13 20:29:37,701 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) DB version = 4.11.3.0 Code Version = 4.13.1.0 2020-07-13 20:29:37,701 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Database upgrade must be performed from 4.11.3.0 to 4.13.1.0 2020-07-13 20:29:37,712 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Running upgrade Upgrade41120to41200 to upgrade from 4.11.2.0-4.12.0.0 to 4.12.0.0 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Licensed to the Apache Software Foundation (ASF) under one 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- or more contributor license agreements. See the NOTICE file 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- distributed with this work for additional information 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- regarding copyright ownership. The ASF licenses this file 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- to you under the Apache License, Version 2.0 (the 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- "License"); you may not use this file except in compliance 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- with the License. You may obtain a copy of the License at 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- http://www.apache.org/licenses/LICENSE-2.0 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Unless required by applicable law or agreed to in writing, 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- software distributed under the License is distributed on an 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- KIND, either express or implied. See the License for the 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- specific language governing permissions and limitations 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- under the License. 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --; 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Schema upgrade from 4.11.2.0 to 4.12.0.0 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --; 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- [CLOUDSTACK-10314] Add reason column to ACL rule table 2020-07-13 20:29:37,716 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`network_acl_item` ADD COLUMN `reason` VARCHAR(2500) AFTER `display` 2020-07-13 20:29:37,718 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) Error executing: ALTER TABLE `cloud`.`network_acl_item` ADD COLUMN `reason` VARCHAR(2500) AFTER `display` 2020-07-13 20:29:37,718 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'reason' 2020-07-13 20:29:37,719 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Unable to execute upgrade script com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'reason' 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:199) at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:254) at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:338) at org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:65) at org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:55) at
Cloudstack 4.11.3 to 4.13.1 DB Upgrade Error
Hi, I am trying to upgrade cloudstack from 4.11.3 to 4.13.1. I am having below db upgrade error while upgrading. I think the upgrade is executing wrong script i.e from 4.11.2 to 4.12.0. Please advise. 2020-07-13 20:29:37,650 INFO [o.a.c.s.l.CloudStackExtendedLifeCycle] (main:null) (logid:) Running system integrity checker com.cloud.upgrade.DatabaseUpgradeChecker@8dfe921 2020-07-13 20:29:37,651 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Grabbing lock to check for database upgrade. 2020-07-13 20:29:37,684 DEBUG [c.c.u.d.VersionDaoImpl] (main:null) (logid:) Checking to see if the database is at a version before it was the version table is created 2020-07-13 20:29:37,701 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) DB version = 4.11.3.0 Code Version = 4.13.1.0 2020-07-13 20:29:37,701 INFO [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Database upgrade must be performed from 4.11.3.0 to 4.13.1.0 2020-07-13 20:29:37,712 DEBUG [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Running upgrade Upgrade41120to41200 to upgrade from 4.11.2.0-4.12.0.0 to 4.12.0.0 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Licensed to the Apache Software Foundation (ASF) under one 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- or more contributor license agreements. See the NOTICE file 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- distributed with this work for additional information 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- regarding copyright ownership. The ASF licenses this file 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- to you under the Apache License, Version 2.0 (the 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- "License"); you may not use this file except in compliance 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- with the License. You may obtain a copy of the License at 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- http://www.apache.org/licenses/LICENSE-2.0 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Unless required by applicable law or agreed to in writing, 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- software distributed under the License is distributed on an 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- KIND, either express or implied. See the License for the 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- specific language governing permissions and limitations 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- under the License. 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --; 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Schema upgrade from 4.11.2.0 to 4.12.0.0 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --; 2020-07-13 20:29:37,715 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- [CLOUDSTACK-10314] Add reason column to ACL rule table 2020-07-13 20:29:37,716 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`network_acl_item` ADD COLUMN `reason` VARCHAR(2500) AFTER `display` 2020-07-13 20:29:37,718 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) Error executing: ALTER TABLE `cloud`.`network_acl_item` ADD COLUMN `reason` VARCHAR(2500) AFTER `display` 2020-07-13 20:29:37,718 ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'reason' 2020-07-13 20:29:37,719 ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Unable to execute upgrade script com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Duplicate column name 'reason' 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:199) at com.cloud.upgrade.DatabaseUpgradeChecker.upgrade(DatabaseUpgradeChecker.java:254) at com.cloud.upgrade.DatabaseUpgradeChecker.check(DatabaseUpgradeChecker.java:338) at org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.checkIntegrity(CloudStackExtendedLifeCycle.java:65) at org.apache.cloudstack.spring.lifecycle.CloudStackExtendedLifeCycle.start(CloudStackExtendedLifeCycle.java:55) at