Which hypervisor are you running in other Zones? The following SQLs should, probably, have the "where zone_id=XXX" statement:
update template_zone_ref set remvoed=now() where template_id=""; update template_store_ref set destroyed=1, state="Destroyed" where template_id=""; because the above queries would just remove reference to the template in ALL zones (zone_id=XXX condition is missing) - you might restore things/values from the DB dump/backup. However, I'm not aware of what you exactly deleted in your original screenshot - those 2 are built in and don't have to be "deleted" in order to delete a Zone. Best, On Mon, 13 Feb 2023 at 13:18, Granwille Strauss <granwi...@namhost.com> wrote: > Hi > > Thank you, we were able to boil down the issue to volumes that were in a > "Destroy" state in the volume table. When cleaned out, I managed to delete > the zone. > > However, I am now having a slight an anxiety attack since you said > removing ISOs this method is risky. I deleted the ISOs "xs-tools.iso" and > "vmware-tools.iso", as per attached screenshot sent initially, which were > automatically installed when I installed Cloudstack Management the first > time. Are they needed in the existing zone? I have not made use of them, at > least from what I can recall, unless there's some automated process that > uses them and need them active? > On 2/13/23 14:05, Andrija Panic wrote: > > Removing ISOs as such might be risky, assuming you have other Zones which > you don't want to affect. > > I would suggest that you check the DB - "storage_pool" table, and ensure > that all pools in that table, that have the zone_id=<YOUR_ZONE_ID> are > marked as Staus=Maintenance and have the Removed column with a date set. > Similar with the "image_store" table (Secondary Storage) > > > On Mon, 13 Feb 2023 at 11:36, Granwille > Strauss<granwi...@namhost.com.invalid> <granwi...@namhost.com.invalid> wrote: > > > Thank you, > > After removing ISO via DB method you provided, error still exists so you > were right, it was not the ISO causing this. Here's the log entry when I > attempt to delete zone: > > 2023-02-13 12:31:48,258 ERROR [c.c.a.ApiServer] > (qtp262366552-454:ctx-f498ef20 ctx-6c40cbcd) (logid:dd5b8f8e) unhandled > exception executing api command: [Ljava.lang.String;@38b34249 > com.cloud.utils.exception.CloudRuntimeException: The zone cannot be > deleted because there are storage volumes in this zone. > at > com.cloud.configuration.ConfigurationManagerImpl.checkIfZoneIsDeletable(ConfigurationManagerImpl.java:2234) > at > com.cloud.configuration.ConfigurationManagerImpl.deleteZone(ConfigurationManagerImpl.java:2380) > at > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native > Method) > at > java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) > at > java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) > at java.base/java.lang.reflect.Method.invoke(Method.java:566) > at > org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:344) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:198) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:163) > at > org.apache.cloudstack.network.contrail.management.EventUtils$EventInterceptor.invoke(EventUtils.java:107) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175) > at > com.cloud.event.ActionEventInterceptor.invoke(ActionEventInterceptor.java:52) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:175) > at > org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:97) > at > org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186) > at > org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:215) > at com.sun.proxy.$Proxy122.deleteZone(Unknown Source) > at > org.apache.cloudstack.api.command.admin.zone.DeleteZoneCmd.execute(DeleteZoneCmd.java:72) > at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:163) > at com.cloud.api.ApiServer.queueCommand(ApiServer.java:776) > at com.cloud.api.ApiServer.handleRequest(ApiServer.java:600) > at > com.cloud.api.ApiServlet.processRequestInContext(ApiServlet.java:327) > at com.cloud.api.ApiServlet$1.run(ApiServlet.java:145) > at > org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.call(DefaultManagedContext.java:55) > at > org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callWithContext(DefaultManagedContext.java:102) > at > org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWithContext(DefaultManagedContext.java:52) > at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:142) > at com.cloud.api.ApiServlet.doGet(ApiServlet.java:96) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:645) > at javax.servlet.http.HttpServlet.service(HttpServlet.java:750) > at > org.eclipse.jetty.servlet.ServletHolder$NotAsync.service(ServletHolder.java:1450) > at > org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:799) > at > org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:550) > at > org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143) > at > org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:600) > at > org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) > at > org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:235) > at > org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:1624) > at > org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233) > at > org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1434) > at > org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188) > at > org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:501) > at > org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1594) > at > org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186) > at > org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1349) > at > org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141) > at > org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:763) > at > org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerCollection.java:146) > at > org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:127) > at org.eclipse.jetty.server.Server.handle(Server.java:516) > at > org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:400) > at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:645) > at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:392) > at > org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:277) > at > org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311) > at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) > at > org.eclipse.jetty.io.ssl.SslConnection$DecryptedEndPoint.onFillable(SslConnection.java:555) > at > org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:410) > at > org.eclipse.jetty.io.ssl.SslConnection$2.succeeded(SslConnection.java:164) > at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) > at org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:104) > at > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:338) > at > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:315) > at > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:173) > at > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:131) > at > org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:409) > at > org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:883) > at > org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:1034) > at java.base/java.lang.Thread.run(Thread.java:829) > > I can 100% confirm, there are no primary or secondary storage configured > for this zone, whatsoever. All network interfaces tied to this zone have > been removed too. > On 2/13/23 12:21, Kiran Chavala wrote: > > Hi Groete > > Could you please share the management server logs exception when you are > trying to delete the zone. > > I don't think its related to ISO > > ---- > > If you want to clean up the stale ISO's in the system > > Then you need to update the database > > > 1. Identify the template id in the vm_template table > > select * from vm_template where name="" and format="ISO"; > > 2. Update the state field to "Inactive" > > update vm_template set state="Inactive" where template_id=""; > > 3. Update the removed field to now(); > > update template_zone_ref set remvoed=now() where template_id=""; > > 4. Update the template_Store_ref; > > update template_store_ref set destroyed=1, state="Destroyed" where > template_id=""; > > > > Regards > Kiran > > > ________________________________ > > > > From: Granwille Strauss > Sent: Monday, February 13, 2023 12:30 > To: users@cloudstack.apache.org > Subject: Removing a zone > > > Hi Guys > > I am busy cleaning up zones, and managed to delete all pods and cluster and > so tied to the zone and all that but when deleting the zone itself it shows > there is storage devices tied to zone. I have checked it all and there's > none. However, I believe its because image ISO that were initially installed, > see attached screenshot, which is why the zone can't be deleted. I tried > adding the secondary storage again, where it was stored, but no luck. Any > ideas how I can go about cleaning out these old ISOs to delete my old zone? > > -- > Regards / Groete > > [https://www.adsigner.com/v1/s/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818/logo/621b3fa39fb210001f975298/cd2904ba-304d-4a49-bf33-cbe9ac76d929_248x-.png]<https://www.namhost.com> > <https://www.namhost.com> <https://www.namhost.com> > <https://www.namhost.com> Granwille Strauss // Senior Systems Admin > > e: granwi...@namhost.com<mailto:granwi...@namhost.com> > <granwi...@namhost.com> <granwi...@namhost.com> <granwi...@namhost.com> > m: +264 81 323 1260<tel:+264813231260> <+264813231260> <+264813231260> > w: www.namhost.com<https://www.namhost.com/> <https://www.namhost.com/> > <https://www.namhost.com/> <https://www.namhost.com/> > > [https://www.adsigner.com/v1/s/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818/social_icon_01/621b3fa39fb210001f975298/9151954b-b298-41aa-89c8-1d68af075373_48x48.png]<https://www.facebook.com/namhost> > <https://www.facebook.com/namhost> <https://www.facebook.com/namhost> > <https://www.facebook.com/namhost> > [https://www.adsigner.com/v1/s/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818/social_icon_02/621b3fa39fb210001f975298/85a9dc7c-7bd1-4958-85a9-e6a25baeb028_48x48.png] > <https://twitter.com/namhost> <https://twitter.com/namhost> > <https://twitter.com/namhost> <https://twitter.com/namhost> > [https://www.adsigner.com/v1/s/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818/social_icon_03/621b3fa39fb210001f975298/c1c5386c-914c-43cf-9d37-5b4aa8e317ab_48x48.png] > <https://www.instagram.com/namhostinternetservices/> > <https://www.instagram.com/namhostinternetservices/> > <https://www.instagram.com/namhostinternetservices/> > <https://www.instagram.com/namhostinternetservices/> > [https://www.adsigner.com/v1/s/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818/social_icon_04/621b3fa39fb210001f975298/3aaa7968-130e-48ec-821d-559a332cce47_48x48.png] > <https://www.linkedin.com/company/namhos> > <https://www.linkedin.com/company/namhos> > <https://www.linkedin.com/company/namhos> > <https://www.linkedin.com/company/namhos> > [https://www.adsigner.com/v1/s/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818/social_icon_05/621b3fa39fb210001f975298/3a8c09e6-588f-43a8-acfd-be4423fd3fb6_48x48.png] > <https://www.youtube.com/channel/UCTd5v-kVPaic_dguGur15AA> > <https://www.youtube.com/channel/UCTd5v-kVPaic_dguGur15AA> > <https://www.youtube.com/channel/UCTd5v-kVPaic_dguGur15AA> > <https://www.youtube.com/channel/UCTd5v-kVPaic_dguGur15AA> > > [https://www.adsigner.com/v1/i/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818/banner/940x300]<https://www.adsigner.com/v1/l/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818/banner> > > <https://www.adsigner.com/v1/l/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818/banner> > > <https://www.adsigner.com/v1/l/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818/banner> > > <https://www.adsigner.com/v1/l/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818/banner> > > Namhost Internet Services (Pty) Ltd, > > 24 Black Eagle Rd, Hermanus, 7210, RSA > > > The content of this message is confidential. If you have received it by > mistake, please inform us by email reply and then delete the message. It is > forbidden to copy, forward, or in any way reveal the contents of this message > to anyone without our explicit consent. The integrity and security of this > email cannot be guaranteed over the Internet. Therefore, the sender will not > be held liable for any damage caused by the message. For our full privacy > policy and disclaimers, please go to https://www.namhost.com/privacy-policy > > [Powered by > AdSigner]<https://www.adsigner.com/v1/c/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818> > > <https://www.adsigner.com/v1/c/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818> > > <https://www.adsigner.com/v1/c/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818> > > <https://www.adsigner.com/v1/c/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818> > > -- > Regards / Groete > <https://www.namhost.com> <https://www.namhost.com> Granwille Strauss // > Senior Systems Admin > > *e:* granwi...@namhost.com > *m:* +264 81 323 1260 <+264813231260> > *w:* www.namhost.com > <https://www.facebook.com/namhost> <https://www.facebook.com/namhost> > <https://twitter.com/namhost> > <https://twitter.com/namhost><https://www.instagram.com/namhostinternetservices/> > > <https://www.instagram.com/namhostinternetservices/><https://www.linkedin.com/company/namhos> > > <https://www.linkedin.com/company/namhos><https://www.youtube.com/channel/UCTd5v-kVPaic_dguGur15AA> > <https://www.youtube.com/channel/UCTd5v-kVPaic_dguGur15AA> > > <https://www.adsigner.com/v1/l/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818/banner> > > <https://www.adsigner.com/v1/l/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818/banner> > > Namhost Internet Services (Pty) Ltd, > > 24 Black Eagle Rd, Hermanus, 7210, RSA > > > > The content of this message is confidential. If you have received it by > mistake, please inform us by email reply and then delete the message. It is > forbidden to copy, forward, or in any way reveal the contents of this > message to anyone without our explicit consent. The integrity and security > of this email cannot be guaranteed over the Internet. Therefore, the sender > will not be held liable for any damage caused by the message. For our full > privacy policy and disclaimers, please go > tohttps://www.namhost.com/privacy-policy > > [image: Powered by > AdSigner]<https://www.adsigner.com/v1/c/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818> > > <https://www.adsigner.com/v1/c/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818> > > -- > Regards / Groete > > <https://www.namhost.com> Granwille Strauss // Senior Systems Admin > > *e:* granwi...@namhost.com > *m:* +264 81 323 1260 <+264813231260> > *w:* www.namhost.com > > <https://www.facebook.com/namhost> <https://twitter.com/namhost> > <https://www.instagram.com/namhostinternetservices/> > <https://www.linkedin.com/company/namhos> > <https://www.youtube.com/channel/UCTd5v-kVPaic_dguGur15AA> > > > <https://www.adsigner.com/v1/l/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818/banner> > > Namhost Internet Services (Pty) Ltd, > > 24 Black Eagle Rd, Hermanus, 7210, RSA > > > > The content of this message is confidential. If you have received it by > mistake, please inform us by email reply and then delete the message. It is > forbidden to copy, forward, or in any way reveal the contents of this > message to anyone without our explicit consent. The integrity and security > of this email cannot be guaranteed over the Internet. Therefore, the sender > will not be held liable for any damage caused by the message. For our full > privacy policy and disclaimers, please go to > https://www.namhost.com/privacy-policy > > [image: Powered by AdSigner] > <https://www.adsigner.com/v1/c/631091998d4670001fe43ec2/621c9b76c140bb001ed0f818> > -- Andrija Panić
