You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by Bikram Biswas <bi...@gmail.com> on 2021/08/12 22:47:35 UTC
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'
Re: Error while database upgrade.
Posted by Rohit Yadav <ro...@shapeblue.com>.
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 <bi...@gmail.com>
Sent: Friday, August 13, 2021 04:17
To: dev@cloudstack.apache.org <de...@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'