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 >> >> >
