Hi, is there some kind of a sanity check that would realize that it is impossible to have running VMs without an active host?
Regards Bernhard 2015-07-09 7:31 GMT+02:00 Bernhard Dübi <[email protected]>: > mysql> SELECT * FROM cloud.image_store where name = "vmware00"; > > +----+----------+---------------------+----------+------------------------------------+----------------+-------+-------+--------------------------------------+--------+---------------------+---------+------------+------------+ > | id | name | image_provider_name | protocol | > url | data_center_id | scope | role | > uuid | parent | created | > removed | total_size | used_bytes | > > +----+----------+---------------------+----------+------------------------------------+----------------+-------+-------+--------------------------------------+--------+---------------------+---------+------------+------------+ > | 8 | vmware00 | NFS | nfs | > nfs://chvirnfsprd01/export/cloud01 | 3 | ZONE | Image | > d9667fd9-ce36-400a-8eae-a8b17ea3df85 | NULL | 2015-07-06 14:09:25 | > NULL | NULL | NULL | > > +----+----------+---------------------+----------+------------------------------------+----------------+-------+-------+--------------------------------------+--------+---------------------+---------+------------+------------+ > 1 row in set (0.00 sec) > > > mysql> SELECT * FROM cloud.template_store_ref where store_id=8; > > +------+----------+-------------+---------------------+---------------------+--------+--------------+------+------------+---------------+----------------+-----------+------------+----------------------+--------------------------------------------------------------------------------------------+--------------+----------------------+------------+-----------+---------+--------------+---------+---------------------+ > | id | store_id | template_id | created | > last_updated | job_id | download_pct | size | store_role | > physical_size | download_state | error_str | local_path | > install_path | > url > | download_url | download_url_created | state | destroyed | is_copy | > update_count | ref_cnt | updated | > > +------+----------+-------------+---------------------+---------------------+--------+--------------+------+------------+---------------+----------------+-----------+------------+----------------------+--------------------------------------------------------------------------------------------+--------------+----------------------+------------+-----------+---------+--------------+---------+---------------------+ > | 1103 | 8 | 267 | 2015-07-06 14:09:25 | 2015-07-06 > 14:09:25 | NULL | 100 | 0 | Image | 0 | > DOWNLOADED | NULL | NULL | template/tmpl/1/267/ | > http://download.cloud.com/templates/4.3/systemvm64template-2014-06-23-master-xen.vhd.bz2 > | NULL | NULL | Ready | 0 | 0 > | 0 | 0 | NULL | > | 1104 | 8 | 10 | 2015-07-06 14:09:25 | 2015-07-06 > 14:09:25 | NULL | 100 | 0 | Image | 0 | > DOWNLOADED | NULL | NULL | template/tmpl/1/10/ | > http://download.cloud.com/templates/4.3/systemvm64template-2014-01-14-master-kvm.qcow2.bz2 > | NULL | NULL | Ready | 0 | 0 > | 0 | 0 | NULL | > | 1105 | 8 | 9 | 2015-07-06 14:09:25 | 2015-07-06 > 14:09:25 | NULL | 100 | 0 | Image | 0 | > DOWNLOADED | NULL | NULL | template/tmpl/1/9/ | > http://download.cloud.com/templates/4.3/systemvm64template-2013-12-23-hyperv.vhd.bz2 > | NULL | NULL | Ready | 0 | 0 > | 0 | 0 | NULL | > | 1106 | 8 | 8 | 2015-07-06 14:09:25 | 2015-07-06 > 14:09:25 | NULL | 100 | 0 | Image | 0 | > DOWNLOADED | NULL | NULL | template/tmpl/1/8/ | > http://download.cloud.com/templates/4.3/systemvm64template-2014-01-14-master-vmware.ova > | NULL | NULL | Ready | 0 | 0 > | 0 | 0 | NULL | > | 1107 | 8 | 3 | 2015-07-06 14:09:25 | 2015-07-06 > 14:09:25 | NULL | 100 | 0 | Image | 0 | > DOWNLOADED | NULL | NULL | template/tmpl/1/3/ | > http://download.cloud.com/templates/4.3/systemvm64template-2014-01-14-master-kvm.qcow2.bz2 > | NULL | NULL | Ready | 0 | 0 > | 0 | 0 | NULL | > | 1108 | 8 | 1 | 2015-07-06 14:09:25 | 2015-07-06 > 14:09:25 | NULL | 100 | 0 | Image | 0 | > DOWNLOADED | NULL | NULL | template/tmpl/1/1/ | > http://download.cloud.com/templates/4.2/systemvmtemplate-2013-07-12-master-xen.vhd.bz2 > | NULL | NULL | Ready | 0 | 0 > | 0 | 0 | NULL | > | 1109 | 8 | 279 | 2015-07-06 19:29:51 | > NULL | NULL | 0 | NULL | Image > | 0 | NULL | NULL | NULL | > template/tmpl/33/279 | > NULL > | NULL | NULL | Destroying | 0 | 0 > | 16 | 0 | 2015-07-08 11:15:47 | > | 1110 | 8 | 280 | 2015-07-07 07:08:59 | > NULL | NULL | 0 | NULL | Image > | 0 | NULL | NULL | NULL | > template/tmpl/32/280 | > NULL > | NULL | NULL | Destroying | 0 | 0 > | 8 | 0 | 2015-07-08 11:15:47 | > > +------+----------+-------------+---------------------+---------------------+--------+--------------+------+------------+---------------+----------------+-----------+------------+----------------------+--------------------------------------------------------------------------------------------+--------------+----------------------+------------+-----------+---------+--------------+---------+---------------------+ > 8 rows in set (0.00 sec) > > > > > 2015-07-09 7:11 GMT+02:00 ilya <[email protected]>: > >> Backup your db >> >> Try >> SELECT * FROM cloud.image_store; >> Note the store_id (assume x) >> >> SELECT * FROM cloud.template_store_ref where store_id=x; >> >> What do you get? >> >> >> >> On 7/8/15 2:03 PM, Bernhard Dübi wrote: >> >>> Hi, >>> >>> we have a CloudStack installation with lots of XenServer. Now I tried to >>> configure VMware. Unfortunatelly something was not working and I decided >>> to >>> delete everything and start over. Now my problem is that I can't delete >>> the >>> secondary storage and the zone. >>> >>> When I try to delete the secondary storage I get "Cannot delete image >>> store >>> with active templates backup!" >>> I checked the NFS share and it's empty. In the Templates view there are 2 >>> templates (SystemVM Template (XenServer), systemvm-xenserver-4.3) >>> assigned >>> to the zone. >>> >>> When I try to delete the systemvm-xenserver-4.3 template I get "The DomR >>> template cannot be deleted." >>> There is no button to delete "SystemVM Template (XenServer)" >>> >>> When I try to delete the zone I get "The zone is not deletable because >>> there are virtual machines running in this zone" >>> I deleted all pods, all clusters, all hosts, the primary storage, all >>> physical networks and all System VMs. All resources are at 0. The zone is >>> disabled.The expunge time is 6 hours but it's more than 24 hours ago >>> since >>> I deleted everything. >>> I had a look at the DB and all VMs assigned to the zone are in the status >>> destroyed. >>> >>> Any idea how to get rid of the zone? >>> >>> Regards >>> Bernhard >>> >>> >> >
