On Wed, Apr 17, 2019 at 10:30 AM Lucie Leistnerova <[email protected]> wrote:
>
> Hi Edward,
>
> On 4/16/19 9:23 PM, Edward Berger wrote:
>
> I was trying to upgrade a hyperconverged oVirt hosted engine and failed in
> the engine-setup command with these error and warnings.
>
> ...
> [ INFO ] Creating/refreshing Engine database schema
> [ ERROR ] schema.sh: FATAL: Cannot execute sql command:
> --file=/usr/share/ovirt-engine/dbscripts/upgrade/04_03_0830_add_foreign_key_to_image_transfers.sql
>
> The error is
>
> ERROR: insert or update on table "image_transfers" violates foreign key
> constraint "fk_image_transfers_command_enitites"
> DETAIL: Key (command_id)=(fedc82f7-9bf7-4988-b9d9-23853e04e44e) is not
> present in table "command_entities".
>
> So there is some image transfer left without appropriate command entity.
> If you are sure that no such transfer is active. You can remove it from the
> table.
>
>
> $ scl enable rh-postgresql10 bash
> $ psql engine
>
> engine=# delete from image_transfers where
> command_id='fedc82f7-9bf7-4988-b9d9-23853e04e44e';
Or, more generally, copying from
04_03_0270_add_foreign_key_to_image_transfers.sql:
DELETE FROM image_transfers
WHERE command_id NOT IN
(SELECT command_entities.command_id
FROM command_entities);
and then try again.
Adding Also Bhushan, who reported this in private as well.
Adding Daniel, author of the patch causing this:
https://gerrit.ovirt.org/#/q/I65906d09ba201c93da65e9a2b67cef5f9f177747,n,z
Daniel:
This already happened in the past, and we fixed it by adding
04_03_0265_remove_foreign_key_in_image_transfers.sql . Not sure why we
needed to add 04_03_0830_add_foreign_key_to_image_transfers.sql again,
but perhaps add now another copy of
04_03_0265_remove_foreign_key_in_image_transfers.sql before it as
well.
Also: Perhaps push a patch to OST to verify this flow.
Thanks and best regards,
>
>
> [ ERROR ] Failed to execute stage 'Misc configuration': Engine schema refresh
> failed
> ...
> [ INFO ] Yum Verify: 16/16: ovirt-engine-tools.noarch 0:4.3.3.5-1.el7 - e
> [WARNING] Rollback of DWH database postponed to Stage "Clean up"
> [ INFO ] Rolling back database schema
> ...
> [ INFO ] Stage: Pre-termination
> [ INFO ] Stage: Termination
> [ ERROR ] Execution of setup failed
>
> Attaching engine-setup logfile.
>
> _______________________________________________
> Users mailing list -- [email protected]
> To unsubscribe send an email to [email protected]
> Privacy Statement: https://www.ovirt.org/site/privacy-policy/
> oVirt Code of Conduct:
> https://www.ovirt.org/community/about/community-guidelines/
> List Archives:
> https://lists.ovirt.org/archives/list/[email protected]/message/45EDYLIQE4QUJYZUG6KJJRJAKCJ5OI3P/
>
> Best regards,
>
> --
> Lucie Leistnerova
> Quality Engineer, QE Cloud, RHVM
> Red Hat EMEA
>
> IRC: lleistne @ #rhev-qe
>
> _______________________________________________
> Users mailing list -- [email protected]
> To unsubscribe send an email to [email protected]
> Privacy Statement: https://www.ovirt.org/site/privacy-policy/
> oVirt Code of Conduct:
> https://www.ovirt.org/community/about/community-guidelines/
> List Archives:
> https://lists.ovirt.org/archives/list/[email protected]/message/2UT7ANKVQKB5NSE3DQAFH6EFDEYDEWVB/
--
Didi
_______________________________________________
Users mailing list -- [email protected]
To unsubscribe send an email to [email protected]
Privacy Statement: https://www.ovirt.org/site/privacy-policy/
oVirt Code of Conduct:
https://www.ovirt.org/community/about/community-guidelines/
List Archives:
https://lists.ovirt.org/archives/list/[email protected]/message/QPJHQT4V3WNAWJCRH6666DNQ2ZHPM4WH/
