Hi Wei Thank you very much for the sql query, I was able to solve it, after understanding the table relations. The project and accounts that the corresponding netwoks belonged to were changed to status "removed"/"Disabled" but the "removed" field was still set to "NULL".
Bes wishes 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 16:28 > To: users@cloudstack.apache.org > Subject: Re: null pointer exception when accessing networks > > 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.ja > > > > va:2 > > > > 863) > > > > > > > > at > > > > com.cloud.api.ApiResponseHelper.createNetworkResponse(ApiResponseH > > > > elpe > > > > r.java:2601) > > > > > > > > at > > > > org.apache.cloudstack.api.command.user.network.ListNetworksCmd.exe > > > > cute > > > > (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:3 > > > > 42) > > > > > > > > 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.c > > > > allW > > > > ithContext(DefaultManagedContext.java:102) > > > > > > > > at > > > > org.apache.cloudstack.managed.context.impl.DefaultManagedContext.r > > > > unWi > > > > 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(ServletHo > > > > lder > > > > .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(ScopedHandle > > > > r.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(ScopedHa > > > > ndle > > > > r.java:235) > > > > > > > > at > > > > org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHa > > > > ndle > > > > r.java:1624) > > > > > > > > at > > > > org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHa > > > > ndle > > > > r.java:233) > > > > > > > > at > > > > org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHa > > > > ndle > > > > r.java:1440) > > > > > > > > at > > > > org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHan > > > > dler > > > > .java:188) > > > > > > > > at > > > > org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.ja > > > > va:5 > > > > 05) > > > > > > > > at > > > > org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHan > > > > dler > > > > .java:1594) > > > > > > > > at > > > > org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHan > > > > dler > > > > .java:186) > > > > > > > > at > > > > org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHan > > > > dler > > > > .java:1355) > > > > > > > > at > > > > org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandle > > > > r.ja > > > > va:141) > > > > > > > > at > > > > org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandl > > > > er.j > > > > ava:772) > > > > > > > > at > > > > org.eclipse.jetty.server.handler.HandlerCollection.handle(HandlerC > > > > olle > > > > 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(Abs > > > > trac > > > > tConnection.java:311) > > > > > > > > at > > > > org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:105) > > > > > > > > at > > > > org.eclipse.jetty.io.ChannelEndPoint$1.run(ChannelEndPoint.java:10 > > > > 4) > > > > > > > > at > > > > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatW > > > > hatY > > > > ouKill.java:338) > > > > > > > > at > > > > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(Ea > > > > tWha > > > > tYouKill.java:315) > > > > > > > > at > > > > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(E > > > > atWh > > > > atYouKill.java:173) > > > > > > > > at > > > > org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatY > > > > ouKi > > > > ll.java:131) > > > > > > > > at > > > > org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThrea > > > > d.ru > > > > n(ReservedThreadExecutor.java:409) > > > > > > > > at > > > > org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThread > > > > Pool > > > > .java:883) > > > > > > > > at > > > > org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedTh > > > > read > > > > 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/>* > > > > > > > > > > > > > >
smime.p7s
Description: S/MIME cryptographic signature
