CS-15070: remove invalid refs from storage_pool_host_ref
Project: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/repo Commit: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/commit/44b88e09 Tree: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/tree/44b88e09 Diff: http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/diff/44b88e09 Branch: refs/heads/3.0.x Commit: 44b88e093f225ef1eb347bfd0209a1455f7e172a Parents: 63d512b Author: Alena Prokharchyk <[email protected]> Authored: Wed May 23 14:49:28 2012 -0700 Committer: Alena Prokharchyk <[email protected]> Committed: Wed May 23 14:50:03 2012 -0700 ---------------------------------------------------------------------- setup/db/db/schema-302to303.sql | 2 ++ 1 files changed, 2 insertions(+), 0 deletions(-) ---------------------------------------------------------------------- http://git-wip-us.apache.org/repos/asf/incubator-cloudstack/blob/44b88e09/setup/db/db/schema-302to303.sql ---------------------------------------------------------------------- diff --git a/setup/db/db/schema-302to303.sql b/setup/db/db/schema-302to303.sql index 4ae6aac..998d1c9 100755 --- a/setup/db/db/schema-302to303.sql +++ b/setup/db/db/schema-302to303.sql @@ -171,3 +171,5 @@ CREATE TABLE `cloud`.`port_profile` ( `port_binding` varchar(20), PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; + +DELETE FROM `cloud`.`storage_pool_host_ref` WHERE pool_id IN (SELECT id FROM storage_pool WHERE removed IS NOT NULL);
