There is no null record for that zone, also state of all VM's are "Expunging" and "Destroyed"!!
-----Original Message----- From: Kiran manohar Chavala [mailto:[email protected]] Sent: Saturday, August 8, 2015 10:18 PM To: [email protected] Subject: Re: How to delete a zone in database Hi Amir Pleas check if there are any instances which ar mysql>select id name,state from vm_instances where removed is null; If you get any id which is not removed, update the database mysql>update vm_instances set removed=now() where id in (select id from vm_instances where removed is null); Regards Kiran On Sat, Aug 8, 2015 at 1:05 PM, Amir Abbasi <[email protected]> wrote: > Thanks, but I get the following error after removing the secondary storage: > The zone is not deletable because there are virtual machines running > in this zone > > in vm_instance table there are some instances in "Expunging" status, > does it caused the problem? > -----Original Message----- > From: Kiran manohar Chavala [mailto:[email protected]] > Sent: Wednesday, August 5, 2015 4:35 PM > To: [email protected] > Subject: Re: How to delete a zone in database > > Hi Amir > > You can delete the templates present in secondary storage from the > database > > mysql > select * from image_store where name="<replace the name of > the secondary storage"; > > note down the id > > > mysql> select * from template_store_ref where store_id=<replace the id > here>; > > > mysql> delete from template_store_ref where store_id=<replace the id > mysql> here>; > > > Then try to remove the secondary storage > > > Regards > > Kiran Manohar > > Citrix systems > On Aug 5, 2015 5:03 PM, "Amir Abbasi" <[email protected]> wrote: > > > Hi All, > > > > > > > > All accounts, Domains and then hosts, clusters, pods, Primary > > Storage have been removed but secondary storage could not be removed > > and I face the following error: > > > > > > > > Cannot delete image store with active templates backup! > > > > > > > > I can see old templates of deleted accounts. How can I delete them > > off from cloud database and then remove old zone? > > > > > > > > Thanks in advance > > > > > >
