On Fri, Feb 8, 2019 at 10:39 PM wrote:
For Hetz it was due to a missing foreign key constraints in image_transfers table. Can you please check if 'fk_image_transfers_command_enitites'[*] exists by executing the following sql command: SELECT COUNT(1) FROM information_schema.table_constraints WHERE constraint_name='fk_image_transfers_command_enitites' AND table_name='image_transfers';
Looks like the same here... engine=# SELECT COUNT(1) FROM information_schema.table_constraints WHERE constraint_name='fk_image_transfers_command_enitites' AND table_name='image_transfers'; count ------- 0 (1 row)
Also, can you please attach 'ovirt-engine-setup' log from after the upgrade to 4.3
[*] The constraint should be added by '04_03_0270_add_foreign_key_to_image_transfers.sql'
I see these in the engine-setup log which seem to be relevant... D: erase 100644 1 ( 0, 0) 472 /usr/share/ovirt-engine/dbscripts/upgrade/04_02_1210_add_foreign_key_to_image_transfers.sql Skipping upgrade script /usr/share/ovirt-engine/dbscripts/upgrade/04_03_0270_add_foreign_key_to_image_transfers.sql, already installed by 04021210