You are viewing a plain text version of this content. The canonical link for it is here.
Posted to commits@cloudstack.apache.org by "xuanyuanaosheng (via GitHub)" <gi...@apache.org> on 2023/07/04 06:05:26 UTC
[GitHub] [cloudstack] xuanyuanaosheng opened a new issue, #7715: Please provide a sql scripts to force clear all the related resource of a zone when a zone was decomission
xuanyuanaosheng opened a new issue, #7715:
URL: https://github.com/apache/cloudstack/issues/7715
##### ISSUE TYPE
* Other
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] xuanyuanaosheng commented on issue #7715: Please provide a sql scripts to force clear all the related resource of a zone when a zone was decomission
Posted by "xuanyuanaosheng (via GitHub)" <gi...@apache.org>.
xuanyuanaosheng commented on issue #7715:
URL: https://github.com/apache/cloudstack/issues/7715#issuecomment-1623184299
I will close this issue
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] rajujith commented on issue #7715: Please provide a sql scripts to force clear all the related resource of a zone when a zone was decomission
Posted by "rajujith (via GitHub)" <gi...@apache.org>.
rajujith commented on issue #7715:
URL: https://github.com/apache/cloudstack/issues/7715#issuecomment-1621023933
@xuanyuanaosheng unfortunately there is no ready to use script delete a specific zone and associated resources to the best of my knowledge.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] DaanHoogland commented on issue #7715: Please provide a sql scripts to force clear all the related resource of a zone when a zone was decomission
Posted by "DaanHoogland (via GitHub)" <gi...@apache.org>.
DaanHoogland commented on issue #7715:
URL: https://github.com/apache/cloudstack/issues/7715#issuecomment-1619699345
@xuanyuanaosheng which resources do you mean?
also please see #7630 , it fixes some of what you describe and might contain clues to what you need.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] DaanHoogland commented on issue #7715: Please provide a sql scripts to force clear all the related resource of a zone when a zone was decomission
Posted by "DaanHoogland (via GitHub)" <gi...@apache.org>.
DaanHoogland commented on issue #7715:
URL: https://github.com/apache/cloudstack/issues/7715#issuecomment-1623072643
@xuanyuanaosheng it does not sound as the right order to go about it. But as a reparation method you could try and find the right SQLs to delete the remnance. Make sure you backup your DB before trying anything.
You should start at tables like `template_store_ref`, `volume_store_ref`, `snapshot_store_ref` and `template_spool_ref`, and work in two directions.
For IPs I think it would not be so hard as the table `user_ip_address` has a field for zone. This one is also the table the fix I referred in https://github.com/apache/cloudstack/issues/7715#issuecomment-1619699345 is for.
hope this helps
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] xuanyuanaosheng commented on issue #7715: Please provide a sql scripts to force clear all the related resource of a zone when a zone was decomission
Posted by "xuanyuanaosheng (via GitHub)" <gi...@apache.org>.
xuanyuanaosheng commented on issue #7715:
URL: https://github.com/apache/cloudstack/issues/7715#issuecomment-1621441098
@DaanHoogland
- Yes, The zone is disabled.
- Yes， the zone has physical network.
- The instances have been deleted and the Volumes are not attached to VMs.
---
##### STEPS TO REPRODUCE
- Create a zone has all the resource and work fine.
- Delete the Hosts in this zone.
- Don't readd the hosts. In this situation, how to delete all the remain resources in this zone?
I
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] DaanHoogland commented on issue #7715: Please provide a sql scripts to force clear all the related resource of a zone when a zone was decomission
Posted by "DaanHoogland (via GitHub)" <gi...@apache.org>.
DaanHoogland commented on issue #7715:
URL: https://github.com/apache/cloudstack/issues/7715#issuecomment-1621393319
@xuanyuanaosheng ,
- You have a decommisioned zone (is it disabled?
- I think it is not removed, because you indicate you want to remove the physical network and a zone cannot be removed with physical networks. Is that correct?
- the volumes and Templates you want to remove can not be removed because there is no SSVM. Are these still attached to VMs?
Please specify what action you are taking and what you would expect from it. I have removed zones for the ticket I mentioned without problems but maybe there is a sequence of events, or an extra item in the zone that prevents it for you.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] rajujith commented on issue #7715: Please provide a sql scripts to force clear all the related resource of a zone when a zone was decomission
Posted by "rajujith (via GitHub)" <gi...@apache.org>.
rajujith commented on issue #7715:
URL: https://github.com/apache/cloudstack/issues/7715#issuecomment-1620105482
@xuanyuanaosheng if you want to remove the resources of all the zones you could run the `cloudstack-setup-databases `again but this won't delete any resources at the hypervisors.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] xuanyuanaosheng commented on issue #7715: Please provide a sql scripts to force clear all the related resource of a zone when a zone was decomission
Posted by "xuanyuanaosheng (via GitHub)" <gi...@apache.org>.
xuanyuanaosheng commented on issue #7715:
URL: https://github.com/apache/cloudstack/issues/7715#issuecomment-1620953686
@rajujith I just want to delete the resources related to one zone.
---
@DaanHoogland
The resources include the volumes, Primary storage, Secondary storage, Template. and the physical network etc.
In some reason, the hosts and the Storage can not work again, this cause the System VMs can not started and the so I can not delete the resource in this zone.
like:
I can not delete the template using `Force delete`
so I can not delete the Secondary storage
I can not delete the volumes
so I can not delete the Primary storage
so I can not delete the cluster, pod and zone.
Please provide a sql scripts to force delete these resources.
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] xuanyuanaosheng commented on issue #7715: Please provide a sql scripts to force clear all the related resource of a zone when a zone was decomission
Posted by "xuanyuanaosheng (via GitHub)" <gi...@apache.org>.
xuanyuanaosheng commented on issue #7715:
URL: https://github.com/apache/cloudstack/issues/7715#issuecomment-1621053235
@rajujith It is sad to hear about that
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] xuanyuanaosheng commented on issue #7715: Please provide a sql scripts to force clear all the related resource of a zone when a zone was decomission
Posted by "xuanyuanaosheng (via GitHub)" <gi...@apache.org>.
xuanyuanaosheng commented on issue #7715:
URL: https://github.com/apache/cloudstack/issues/7715#issuecomment-1623135758
@DaanHoogland
This situation is indeed strange. Thanks for your reply.
I have done some test on DB level and it works.
Could you please help to look at the issue: https://github.com/apache/cloudstack/issues/7720
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack] xuanyuanaosheng closed issue #7715: Please provide a sql scripts to force clear all the related resource of a zone when a zone was decomission
Posted by "xuanyuanaosheng (via GitHub)" <gi...@apache.org>.
xuanyuanaosheng closed issue #7715: Please provide a sql scripts to force clear all the related resource of a zone when a zone was decomission
URL: https://github.com/apache/cloudstack/issues/7715
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: commits-unsubscribe@cloudstack.apache.org
For queries about this service, please contact Infrastructure at:
users@infra.apache.org