Hi Winkler, try this
select * from networks join projects on networks.account_id=projects.project_account_id where projects.removed is not NULL and networks.removed is NULL; -Wei On Wed, Nov 27, 2024 at 3:27 PM Winkler Marc (ID) <marc.wink...@id.ethz.ch> wrote: > Thanks for the tip, Wei. I had a look at the database but I cannot find > relation between network and a project. Can you give me a hint, which table > / relation makes that connection in the database? > > Best regards > > Marc > > ETH Zürich > Marc Winkler > ID Corporate Center > OCT G 45 > Binzmühlestrasse 130 > 8093 Zürich > Mobile +41 78 656 18 51 > marc.wink...@id.ethz.ch > www.id.ethz.ch > > > -----Original Message----- > > From: Wei ZHOU <ustcweiz...@gmail.com> > > Sent: Wednesday, 27 November 2024 14:22 > > To: users@cloudstack.apache.org > > Subject: Re: null pointer exception when accessing networks > > > > It looks there is a dangling network belonging to a removed project > > > > -Wei > > > > On Wed, Nov 27, 2024 at 1:33 PM Winkler Marc (ID) < > marc.wink...@id.ethz.ch> > > wrote: > > > > > Hi CloudStack People > > > > > > > > > > > > After someone deleted a network (sadly I don’t know which one), we get > > > the following error when trying to access the “Networks” page in the > > > Web-UI (and additionally when trying to execute cmk list networks. > > > > > > > > > > > > 2024-11-27 13:29:15,112 ERROR [c.c.a.ApiServer] > > > (qtp660017404-19:ctx-2d881f20 ctx-0c620159) (logid:3a125718) unhandled > > > exception executing api command: [Ljava.lang.String;@44dbd039 > > > > > > java.lang.NullPointerException > > > > > > at > > > com.cloud.api.ApiResponseHelper.populateOwner(ApiResponseHelper.java:2 > > > 863) > > > > > > at > > > com.cloud.api.ApiResponseHelper.createNetworkResponse(ApiResponseHelpe > > > r.java:2601) > > > > > > at > > > org.apache.cloudstack.api.command.user.network.ListNetworksCmd.execute > > > (ListNetworksCmd.java:221) > > > > > > at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:172) > > > > > > at com.cloud.api.ApiServer.queueCommand(ApiServer.java:811) > > > > > > at com.cloud.api.ApiServer.handleRequest(ApiServer.java:632) > > > > > > at > > > com.cloud.api.ApiServlet.processRequestInContext(ApiServlet.java:342) > > > > > > at com.cloud.api.ApiServlet$1.run(ApiServlet.java:149) > > > > > > at > > > org.apache.cloudstack.managed.context.impl.DefaultManagedContext$1.cal > > > l(DefaultManagedContext.java:55) > > > > > > at > > > org.apache.cloudstack.managed.context.impl.DefaultManagedContext.callW > > > ithContext(DefaultManagedContext.java:102) > > > > > > at > > > org.apache.cloudstack.managed.context.impl.DefaultManagedContext.runWi > > > thContext(DefaultManagedContext.java:52) > > > > > > at com.cloud.api.ApiServlet.processRequest(ApiServlet.java:146) > > > > > > at com.cloud.api.ApiServlet.doGet(ApiServlet.java:100) > > > > > > 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: > > > 554) > > > > > > at > > > org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.ja > > > va: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(ScopedHandle > > > r.java:235) > > > > > > at > > > org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandle > > > r.java:1624) > > > > > > at > > > org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandle > > > r.java:233) > > > > > > at > > > org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandle > > > r.java:1440) > > > > > > at > > > org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler > > > .java:188) > > > > > > at > > > org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:5 > > > 05) > > > > > > 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:1355) > > > > > > at > > > org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.ja > > > va:141) > > > > > > at > > > org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.j > > > ava:772) > > > > > > at > > > org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerColle > > > ction.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: > > > 487) > > > > > > at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:732) > > > > > > at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:479) > > > > > > at > > > org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java > > > :277) > > > > > > at > > > org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(Abstrac > > > tConnection.java:311) > > > > > > 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(EatWhatY > > > ouKill.java:338) > > > > > > at > > > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWha > > > tYouKill.java:315) > > > > > > at > > > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWh > > > atYouKill.java:173) > > > > > > at > > > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKi > > > ll.java:131) > > > > > > at > > > org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.ru > > > n(ReservedThreadExecutor.java:409) > > > > > > at > > > org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool > > > .java:883) > > > > > > at > > > org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThread > > > Pool.java:1034) > > > > > > at java.base/java.lang.Thread.run(Thread.java:829) > > > > > > > > > > > > How can I debug this further? I assume this is an error in the > > > networks table in the DB but I don’t have any additional information > > > and it is therefore tricky to troubleshoot further. The Cloudstack > > > Version is > > > 4.19.1.0 and based on KVM. > > > > > > > > > > > > Best regards > > > > > > > > > > > > Marc > > > > > > > > > > > > ETH Zürich > > > > > > Marc Winkler > > > > > > ID Corporate Center > > > > > > OCT G 45 > > > > > > Binzmühlestrasse 130 > > > > > > 8093 Zürich > > > > > > Mobile +41 78 656 18 51 > > > > > > *marc.wink...@id.ethz.ch <marc.wink...@id.ethz.ch>* > > > > > > *www.id.ethz.ch <http://www.id.ethz.ch/>* > > > > > > > > > >
