[ovirt-users] Re: ovirt-imageio-proxy upload and status
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