i can not Delete Kubernetes Cluster

[ahmadamirahmadi1401]

Hi
CloudStack 4.19.1.3
when i want to delete K8s Cluster i face with follow Error in UI and cloudstack error exception:
(aa) Command failed due to Internal Server Error

2025-02-12 06:05:26,406 DEBUG [o.a.c.f.j.i.AsyncJobManagerImpl] (API-Job-Executor-1:ctx-12f3c2fc job-22956) (logid:2821de47) Executing AsyncJobVO: {id:22956, userId: 2, accountId: 2, instanceType: KubernetesCluster, instanceId: 524, cmd: org.apache.cloudstack.api.command.user.kubernetes.cluster.DeleteKubernetesClusterCmd, cmdInfo: {"response":"json","ctxUserId":"2","sessionkey":"JcO4ZmzxffffffJqVh_Oc","httpmethod":"GET","ctxStartEventId":"70574","id":"65d292df-6072-4750-8d51-6d2e73aafd8e","ctxDetails":"{\"interface com.cloud.kubernetes.cluster.KubernetesCluster\":\"65d292df-6072-4750-8d51-6d2e73aafd8e\"}","ctxAccountId":"2","uuid":"65d292df-6072-4750-8d51-6d2e73aafd8e","cmdEventType":"KUBERNETES.CLUSTER.DELETE"}, cmdVersion: 0, status: IN_PROGRESS, processStatus: 0, resultCode: 0, result: null, initMsid: 345051312967, completeMsid: null, lastUpdated: null, lastPolled: null, created: null, removed: null}

2025-02-12 06:05:26,639 ERROR [c.c.a.ApiAsyncJobDispatcher] (API-Job-Executor-1:ctx-12f3c2fc job-22956) (logid:2821de47) Unexpected exception while executing org.apache.cloudstack.api.command.user.kubernetes.cluster.DeleteKubernetesClusterCmd
java.lang.NullPointerException
	at com.cloud.utils.db.SearchCriteria.findJoin(SearchCriteria.java:178)
	at com.cloud.utils.db.SearchCriteria.setJoinParameters(SearchCriteria.java:197)
	at com.cloud.vm.dao.VMInstanceDaoImpl.listNonRemovedVmsByTypeAndNetwork(VMInstanceDaoImpl.java:872)
	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 com.cloud.utils.db.TransactionContextInterceptor.invoke(TransactionContextInterceptor.java:34)
	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.$Proxy97.listNonRemovedVmsByTypeAndNetwork(Unknown Source)
	at com.cloud.kubernetes.cluster.actionworkers.KubernetesClusterDestroyWorker.destroy(KubernetesClusterDestroyWorker.java:256)
	at com.cloud.kubernetes.cluster.KubernetesClusterManagerImpl.deleteKubernetesCluster(KubernetesClusterManagerImpl.java:1449)
	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.$Proxy466.deleteKubernetesCluster(Unknown Source)
	at org.apache.cloudstack.api.command.user.kubernetes.cluster.DeleteKubernetesClusterCmd.execute(DeleteKubernetesClusterCmd.java:97)
	at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:172)
	at com.cloud.api.ApiAsyncJobDispatcher.runJob(ApiAsyncJobDispatcher.java:112)
	at org.apache.cloudstack.framework.jobs.impl.AsyncJobManagerImpl$5.runInContext(AsyncJobManagerImpl.java:654)
	at org.apache.cloudstack.managed.context.ManagedContextRunnable$1.run(ManagedContextRunnable.java:48)
	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 org.apache.cloudstack.managed.context.ManagedContextRunnable.run(ManagedContextRunnable.java:45)
	at org.apache.cloudstack.framework.jobs.impl.AsyncJobManagerImpl$5.run(AsyncJobManagerImpl.java:602)
	at java.base/java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515)
	at java.base/java.util.concurrent.FutureTask.run(FutureTask.java:264)
	at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128)
	at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628)
	at java.base/java.lang.Thread.run(Thread.java:829)

[weizhouapache]

can you check by the SQL below ?

select * from nics where network_id=<network id> and removed is NULL and instance_id is NULL;

[ahmadamirahmadi007]

my cloudstack version is CloudStack 4.19.1.3 now. Should I still have this problem? @weizhouapache

[weizhouapache]

oh, then it should not have the problem

the PR has been merged into 4.19.1.0

[ahmadamirahmadi007]

should i create issue for this problem ?

[weizhouapache]

this looks like a different issue with #9331
to be confirmed
cc @DaanHoogland

[DaanHoogland]

@ahmadamirahmadi1401 , if you have a clear reproduction scenario we can fix this. If not, more investigation is needed.