Moti Asayag has submitted this change and it was merged. Change subject: engine: Modify vm_interface-vnic-profiles foreign key ...................................................................... engine: Modify vm_interface-vnic-profiles foreign key The patch modifies the FK of vm_interface on vnic-profiles to be set NULL in case of deletion of the vnic profiles. Removal of a vnic profile which is used by vnics is blocked by can-do-action, same for network removal which is used by vms. However, when forcibly removing a data-center, the removal of the vm interface is being executed in a different transaction than the network entities. This can be avoided if the logic of DC removal would have been implemented by code and not in a stored procedure. Change-Id: I2feef15a7460899979a78b357886bd1f027918af Bug-Url: https://bugzilla.redhat.com/996934 Signed-off-by: Moti Asayag <masayag@redhat.com> --- A packaging/dbscripts/upgrade/03_03_0770_alter_vm_interface_vnic_profile_fk.sql 1 file changed, 3 insertions(+), 0 deletions(-) Approvals: Moti Asayag: Verified; Looks good to me, approved -- To view, visit http://gerrit.ovirt.org/18175 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: merged Gerrit-Change-Id: I2feef15a7460899979a78b357886bd1f027918af Gerrit-PatchSet: 2 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Moti Asayag <masayag@redhat.com> Gerrit-Reviewer: Allon Mureinik <amureini@redhat.com> Gerrit-Reviewer: Lior Vernia <lvernia@redhat.com> Gerrit-Reviewer: Mike Kolesnik <mkolesni@redhat.com> Gerrit-Reviewer: Moti Asayag <masayag@redhat.com> Gerrit-Reviewer: Omer Frenkel <ofrenkel@redhat.com>