sureshanaparti commented on issue #6074: URL: https://github.com/apache/cloudstack/issues/6074#issuecomment-1063824957
Hi @AlexanderKgr, I've checked the upgrade path, and as @nvazquez pointed the column `secondary_object` doesn't exists in 4.16.0 **DB before upgrade:** ``` [cloud]> desc vm_work_job; +----------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------------+---------------------+------+-----+---------+-------+ | id | bigint(20) unsigned | NO | PRI | NULL | | | step | char(32) | NO | MUL | NULL | | | vm_type | char(32) | NO | MUL | NULL | | | vm_instance_id | bigint(20) unsigned | NO | MUL | NULL | | +----------------+---------------------+------+-----+---------+-------+ 4 rows in set (0.00 sec) ``` **Upgrade log =>** _2022-03-10 08:51:25,906 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Schema upgrade from 4.16.0.0 to 4.16.1.0 2022-03-10 08:51:25,906 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) --; 2022-03-10 08:51:25,907 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) ALTER TABLE `cloud`.`vm_work_job` ADD COLUMN `secondary_object` char(100) COMMENT 'any additional item that must be checked during queueing' AFTER `vm_instance_id` 2022-03-10 08:51:25,930 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Stored procedures to handle cloud and cloud_schema changes 2022-03-10 08:51:25,931 DEBUG [c.c.u.d.ScriptRunner] (main:null) (logid:) -- Idempotent ADD COLUMN_ **DB after upgrade:** ``` [cloud]> desc cloud.vm_work_job; +------------------+---------------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------------+---------------------+------+-----+---------+-------+ | id | bigint(20) unsigned | NO | PRI | NULL | | | step | char(32) | NO | MUL | NULL | | | vm_type | char(32) | NO | MUL | NULL | | | vm_instance_id | bigint(20) unsigned | NO | MUL | NULL | | | secondary_object | char(100) | YES | | NULL | | +------------------+---------------------+------+-----+---------+-------+ 5 rows in set (0.00 sec) ``` Can you try with the steps @nvazquez suggested, and update us. Thanks. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
