Bug 1687707

+++ This bug was initially created as a clone of Bug #1547038 +++

+++ This bug was initially created as a clone of Bug #1528316 +++


As explained in https://bugzilla.redhat.com/show_bug.cgi?id=1528316#c4 our vm_interface has two fields (vm_guid and vmt_guid) referring to the same table, and we should eliminate this.

--- Additional comment from Red Hat Bugzilla Rules Engine on 2018-02-20 12:54:41 CET ---

This bug report has Keywords: Regression or TestBlocker.
Since no regressions or test blockers are allowed between releases, it is also being identified as a blocker for this release. Please resolve ASAP.

--- Additional comment from Yaniv Kaul on 2018-02-21 09:11:31 CET ---

Is this a bug or a feature?

--- Additional comment from  on 2018-02-22 07:54:53 CET ---

This is technical debt of normalizing the db and aligning the engine accordingly, with no customer facing effects (hopefully...)

--- Additional comment from Yaniv Lavi on 2018-08-29 10:12:03 CEST ---

This seems like a risky change with limited benefit, therefore for now.

--- Additional comment from Dominik Holler on 2019-03-06 10:04:49 CET ---



--- Additional comment from Dominik Holler on 2019-03-06 15:51:50 CET ---

Steps to Reproduce on oVirt 4.3:
1. Create a VM with a vNIC
2. Create a template of this VM
3. Create a subversion of the template
4. Run engine-setup


Actual results:
[ INFO  ] Checking the Engine database consistency
[ ERROR ] Failed to execute stage 'Setup validation': Failed checking Engine database: an exception occurred while validating the Engine database, please check the logs for getting more info:
         Constraint violation found in  vm_interface (vmt_guid) |1


Expected results:
engine-setup succeeds

--- Additional comment from Dominik Holler on 2019-03-08 23:02:23 CET ---



--- Additional comment from Martin Perina on 2019-03-12 08:54:33 CET ---

Removing CodeChange and updating title as this is an upgrade blocker