Return-Path: X-Original-To: apmail-incubator-cloudstack-commits-archive@minotaur.apache.org Delivered-To: apmail-incubator-cloudstack-commits-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 5BFB2CEE1 for ; Sun, 27 May 2012 22:35:48 +0000 (UTC) Received: (qmail 4567 invoked by uid 500); 27 May 2012 22:35:43 -0000 Delivered-To: apmail-incubator-cloudstack-commits-archive@incubator.apache.org Received: (qmail 4523 invoked by uid 500); 27 May 2012 22:35:43 -0000 Mailing-List: contact cloudstack-commits-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: cloudstack-dev@incubator.apache.org Delivered-To: mailing list cloudstack-commits@incubator.apache.org Received: (qmail 3520 invoked by uid 99); 27 May 2012 22:35:42 -0000 Received: from tyr.zones.apache.org (HELO tyr.zones.apache.org) (140.211.11.114) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 27 May 2012 22:35:42 +0000 Received: by tyr.zones.apache.org (Postfix, from userid 65534) id 4D9B4184C1; Sun, 27 May 2012 22:35:42 +0000 (UTC) Content-Type: text/plain; charset="us-ascii" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit From: ke4qqq@apache.org To: cloudstack-commits@incubator.apache.org X-Mailer: ASF-Git Admin Mailer Subject: [49/50] [abbrv] git commit: CS-15070: remove invalid refs from storage_pool_host_ref Message-Id: <20120527223542.4D9B4184C1@tyr.zones.apache.org> Date: Sun, 27 May 2012 22:35:42 +0000 (UTC) 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 Authored: Wed May 23 14:49:28 2012 -0700 Committer: Alena Prokharchyk 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);