GitHub user Pearl1594 added a comment to the discussion: Unable to delete Zone

If you are trying to decommission the zone, and this is a test environment, 
then you could mark all the templates of the zone as Inactive in the database. 
To get the list of all the Active templates 
```
select distinct(id) from template_view where store_id in (select id from 
image_store where data_center_id = <id_of_zone>) and type = 'USER' and 
template_state = 'Active'\G
```

And mark their states as Inactive
```
update vm_template set state = 'Inactive' where id in (select distinct(id) from 
template_view where store_id in (select id from image_store where 
data_center_id = <id_of_zone>) and type = 'USER' and template_state = 
'Active'\G);
```
You can then manually clean up your secondary store. 

Please take note, that this is more of a hack to clean up your env - do it only 
if it's a test environment. 


GitHub link: 
https://github.com/apache/cloudstack/discussions/9532#discussioncomment-10341192

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]

Reply via email to