Created attachment 1691751 [details] Jenkins + engine setup logs Description of problem: When executed Jenkins flow for upgrading the 4.4 env to latest build rhv-4.4.1-1 , The upgrade flow fails at stage of "Run engine-setup with answerfile": schema.sh: FATAL: Cannot execute sql command: --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_04_0650_add_fk_to_vm_checkpoint_disk_map.sql\n[ ERROR ] Failed to execute stage 'Misc configuration': Engine schema refresh failed\n[ INFO ] Unfortunately i couldnt take the table contents because the env was already re-provisioned. Version-Release number of selected component (if applicable): rhv-4.4.1-1 How reproducible: Reproduced only once when running the Jenkins upgrade flow. Attaching engine setup std out print [1] and full log of the responsible Jenkins job [2], as well as the link to it [3] [1] engine_setup_stdout.txt [2] jenkins_job.log [3] https://rhv-jenkins.rhev-ci-vms.eng.rdu2.redhat.com/job/rhv-ge-deploy-4.4/1066/consoleFull
Ilan, maybe you had some dirty entities on vm_checkpoints and vm_checkpoint_disk_map. So when the FK was added some entities didn't have a match so it fails. Can you share the DB dump/content?
Unfortunately i do not have a live DB from this failure. The env was reprovisioned.
Did you used this env for incremental backup testing?
yes i did
I see. Closing this bug for now since this issue is expected due to the tests you did on incremental backup feature which is a tech-preview. Please re-open this bug if necessary.
Also, If someone encounters it, the WA will be to align the vm_checkpoints table with vm_checkpoint_disks_map and see that for each checkpoint_id in vm_checkpoint_disks_map we have a corresponding checkpoint_id in vm_checkpoints. Fixed by - https://gerrit.ovirt.org/#/c/109101/