Mailing-List: contact cloudstack-users-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cloudstack-users@incubator.apache.org
Received-SPF: pass (nike.apache.org: domain of Prasanna.Santhanam@citrix.com
 designates 203.166.19.134 as permitted sender)
Date: Thu, 5 Jul 2012 11:09:54 +0530
From: Prasanna Santhanam <prasanna.santhanam@citrix.com>
To: "cloudstack-users@incubator.apache.org"
	<cloudstack-users@incubator.apache.org>
Subject: Re: Removing a Zone
Message-ID: <20120705053954.GC3245@cloud.com>
Mail-Followup-To: "cloudstack-users@incubator.apache.org"
 <cloudstack-users@incubator.apache.org>
References: <CC18ACFC.653C%Ahmad.Emneina@citrix.com>
 <4C478694-02B7-4B72-BE79-D5770D6DB7E9@me.com>
 <BC34F2AA-4914-49BB-AC9C-1FB34B14D23C@me.com>
 <4FCA39B99132DA4EA70BE3CE408C193D010DD180EFB5@BANPMAILBOX01.citrite.net>
 <60731E21-85B2-4AC7-B9CA-72C4EDC47763@shapeblue.com>
 <87C72163-B5D4-4A18-99AB-8EDD460F1630@me.com>
 <4FCA39B99132DA4EA70BE3CE408C193D010DD180F1D7@BANPMAILBOX01.citrite.net>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Disposition: inline
In-Reply-To: 
 <4FCA39B99132DA4EA70BE3CE408C193D010DD180F1D7@BANPMAILBOX01.citrite.net>
User-Agent: Mutt/1.5.21 (2010-09-15)

On Thu, Jul 05, 2012 at 01:26:26AM -0400, Sailaja Mada wrote:
> 
> Can you remove the entries from vm_instance table and then try
> deleting the POD.   
>

That's a bad idea - Expunging is the final state of a VM. These are
valid entries. As Ahmad pointed out only if you have any that are
"Expunging" but failed to be marked as removed would those be invalid
entries to look out for.

The private IP addresses can be found in the op_dc_ip_address_alloc
table. Corresponding to each row in there is a nic_id. Pick the ones
with a non-null nic_id and check against the nics table to see if that
nic_id is removed. The ones that are in use are in "Reserved" state.

Deleting of a zone has been an issue in 3.0.0 IIRC.  Which version are
you at?

-- 
Prasanna.,

> 
> -----Original Message-----
> From: Caleb Call [mailto:calebcall@me.com] 
> Sent: Thursday, July 05, 2012 2:42 AM
> To: cloudstack-users@incubator.apache.org
> Subject: Re: Removing a Zone
> 
> @Edison - That's the state we're currently in.  The zone is
> disabled.  We basically removed everything starting with secondary
> storage.  So we removed Secondary storage, Primary storage, Hosts,
> and Clusters.  We now can't remove the pod (or zone) because of this
> error.
> 
> @Sailaja - That query returns ~2800 rows, but no private IPs are
> assigned.  However, it looks like all of them are stuck in an
> Expunging state.  Can I just remove those from the database? 
> 
> mysql> select state,COUNT(*) from cloud.vm_instance;
> +-----------+----------+
> | state     | COUNT(*) |
> +-----------+----------+
> | Expunging |     2803 |
> +-----------+----------+
> 1 row in set (0.02 sec)
> 
> @Geoff - See above, we have been able to remove everything up to the
> pod level, including system VMs and even the hypervisors (hosts).  
> 
> At this point, with no hosts added, I can't see any possible way an
> IP is actually being used. 
> 
> Thanks guys for the quick responses.
> 
> On Jul 4, 2012, at 1:14 AM, Geoff Higginbottom wrote:
>