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 prifiles with unlimited QoS (currentlu 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 <[email protected]> --- A packaging/dbscripts/upgrade/03_06_0460_create_default_disk_profiles.sql 1 file changed, 22 insertions(+), 0 deletions(-) git pull ssh://gerrit.ovirt.org:29418/ovirt-engine refs/changes/22/34422/1 diff --git a/packaging/dbscripts/upgrade/03_06_0460_create_default_disk_profiles.sql b/packaging/dbscripts/upgrade/03_06_0460_create_default_disk_profiles.sql new file mode 100644 index 0000000..544a0b2 --- /dev/null +++ b/packaging/dbscripts/upgrade/03_06_0460_create_default_disk_profiles.sql @@ -0,0 +1,22 @@ +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...'; + +FOR sd_id IN + SELECT id 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) LOOP + + RAISE NOTICE 'Assigning default disk profile to storage domain %s ...', sd_id; + + INSERT INTO disk_profiles VALUES + (uuid_generate_v1(), 'Default', sd_id, NULL, 'Default unlimited disk profile'); + + END LOOP; + +RAISE NOTICE 'Done Assigning default disk profiles.'; +RETURN ; +END; +$$ LANGUAGE plpgsql; -- To view, visit http://gerrit.ovirt.org/34422 To unsubscribe, visit http://gerrit.ovirt.org/settings Gerrit-MessageType: newchange Gerrit-Change-Id: I3ee3174e5c7bef3bcd5591b9cd99ff5324bee488 Gerrit-PatchSet: 1 Gerrit-Project: ovirt-engine Gerrit-Branch: master Gerrit-Owner: Roy Golan <[email protected]> _______________________________________________ Engine-patches mailing list [email protected] http://lists.ovirt.org/mailman/listinfo/engine-patches
