rohityadavcloud commented on issue #6167: URL: https://github.com/apache/cloudstack/issues/6167#issuecomment-1079783190
Something went wrong in the upgrade because of which this line with secondary_object didn't work: https://github.com/apache/cloudstack/blob/main/engine/schema/src/main/resources/META-INF/db/schema-41600to41610.sql#L22 The issue was incorrect unique key, fixing that fixed this issue: ``` | vm_work_job | CREATE TABLE `vm_work_job` ( `id` bigint unsigned NOT NULL, `step` char(32) NOT NULL COMMENT 'state', `vm_type` char(32) NOT NULL COMMENT 'type of vm', `vm_instance_id` bigint unsigned NOT NULL COMMENT 'vm instance', `secondary_object` char(100) DEFAULT NULL COMMENT 'any additional item that must be checked during queueing', PRIMARY KEY (`id`), UNIQUE KEY `vm_work_job_step_and_objects` (`step`,`vm_instance_id`), KEY `fk_vm_work_job__instance_id` (`vm_instance_id`), KEY `i_vm_work_job__vm` (`vm_type`,`vm_instance_id`), KEY `i_vm_work_job__step` (`step`), CONSTRAINT `fk_vm_work_job__instance_id` FOREIGN KEY (`vm_instance_id`) REFERENCES `vm_instance` (`id`) ON DELETE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3 | ``` -- 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]
