Omer Frenkel has uploaded a new change for review. Change subject: core: Allow SD maintenance with suspended vms ......................................................................
core: Allow SD maintenance with suspended vms Suspended vms are actually down, so not actively using the storage. we should allow the user to maintenance the SD even when vms are suspended. Change-Id: Ia0206fb7a1a0c59ff493635e5cb84805b3a9a354 Bug-Url: https://bugzilla.redhat.com/show_bug.cgi?id=1061194 Signed-off-by: Omer Frenkel <[email protected]> --- M packaging/dbscripts/vms_sp.sql 1 file changed, 2 insertions(+), 1 deletion(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/01/32201/1 diff --git a/packaging/dbscripts/vms_sp.sql b/packaging/dbscripts/vms_sp.sql index 9892e54..1dbcca9 100644 --- a/packaging/dbscripts/vms_sp.sql +++ b/packaging/dbscripts/vms_sp.sql @@ -1118,7 +1118,8 @@ INNER JOIN vm_device vd ON vd.vm_id = vms.vm_guid INNER JOIN images i ON i.image_group_id = vd.device_id inner join image_storage_domain_map on i.image_guid = image_storage_domain_map.image_id - WHERE status <> 0 AND + -- down(0) and suspended(13) vms are not using the storage + WHERE status not in (0,13) AND is_plugged = TRUE AND image_storage_domain_map.storage_domain_id = v_storage_domain_id; END; $procedure$ -- To view, visit http://gerrit.ovirt.org/32201 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: Ia0206fb7a1a0c59ff493635e5cb84805b3a9a354 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Omer Frenkel <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
