Hi Bikram, Looks like you've added the column (i.e. column exists) prior to the upgrade? You may either drop the column prior to the upgrade and try again, or deploy a fresh installation/setup of your dev/test environment.
Regards. ________________________________ From: Bikram Biswas <bickrombishs...@gmail.com> Sent: Friday, August 13, 2021 04:17 To: dev@cloudstack.apache.org <dev@cloudstack.apache.org> Subject: Error while database upgrade. engine/schema/src/main/resources/META-INF/db/schema-41510to41600.sql line:23 ALTER TABLE `cloud`.`service_offering` ADD COLUMN `dynamic_scaling_enabled` tinyint(1) unsigned NOT NULL DEFAULT 1 COMMENT 'true(1) if VM needs to be dynamically scalable of cpu or memory'; Log message ... ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) Error executing: ALTER TABLE `cloud`.`service_offering` ADD COLUMN `dynamic_scaling_enabled` tinyint(1) unsigned NOT NULL DEFAULT 1 COMMENT 'true(1) if VM needs to be dynamically scalable of cpu or memory' ERROR [c.c.u.d.ScriptRunner] (main:null) (logid:) java.sql.SQLSyntaxErrorException: Duplicate column name 'dynamic_scaling_enabled' ERROR [c.c.u.DatabaseUpgradeChecker] (main:null) (logid:) Unable to execute upgrade script java.sql.SQLSyntaxErrorException: Duplicate column name 'dynamic_scaling_enabled'
