Roy Golan has uploaded a new change for review. Change subject: core: Create default disk profiles for data domains ......................................................................
core: Create default disk profiles for data domains All data domains should have default disk profiles with unlimited QoS (currently implemented by null) Otherwise all existing data domains needs manual intervention for creating disks if the data center is upgraded to version 3.5 Change-Id: I3ee3174e5c7bef3bcd5591b9cd99ff5324bee488 Bug-Url: https://bugzilla.redhat.com/1145421 Signed-off-by: Roy Golan <rgo...@redhat.com> (cherry picked from commit ae0e66b7416f3707eccb76641ad6e80794d19f4f) --- A packaging/dbscripts/upgrade/03_06_0490_create_default_disk_profiles.sql 1 file changed, 20 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/98/34598/1 diff --git a/packaging/dbscripts/upgrade/03_06_0490_create_default_disk_profiles.sql b/packaging/dbscripts/upgrade/03_06_0490_create_default_disk_profiles.sql new file mode 100644 index 0000000..57df2d1 --- /dev/null +++ b/packaging/dbscripts/upgrade/03_06_0490_create_default_disk_profiles.sql @@ -0,0 +1,20 @@ +CREATE OR REPLACE FUNCTION create_default_disk_profiles() RETURNS VOID AS $$ +DECLARE +sd_id uuid; +BEGIN +RAISE NOTICE 'Assigning defaults disk profiles for all storage domains...'; + +INSERT INTO disk_profiles + (SELECT uuid_generate_v1(), storage_name, id, NULL, 'Default unlimited disk profile' + FROM storage_domain_static + WHERE storage_domain_type IN (0,1) -- 0 and 1 are data domains type + AND id NOT IN (select storage_domain_id from disk_profiles)); + +RAISE NOTICE 'Done Assigning default disk profiles.'; +RETURN ; +END; +$$ LANGUAGE plpgsql; + +SELECT create_default_disk_profiles(); +DROP FUNCTION create_default_disk_profiles(); + -- To view, visit http://gerrit.ovirt.org/34598 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I3ee3174e5c7bef3bcd5591b9cd99ff5324bee488 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: ovirt-engine-3.5 Gerrit-Owner: Roy Golan <rgo...@redhat.com> _______________________________________________ Engine-patches mailing list Engine-patches@ovirt.org http://lists.ovirt.org/mailman/listinfo/engine-patches
