Hi Vincent,
I've checked the codebase for that NPE and it seems like there is a reference
on the 'template_store_ref' table for a removed data store. Can you please
check if the following query retrieves some data? In case it does, you can
remove the records from the template_store_ref and retry the listing operation:
select t.id, t.store_id, t.template_id, i.name, i.removed from
template_store_ref t join image_store i on (t.store_id = i.id) where i.removed
is not null;
Regards,
Nicolas Vazquez
________________________________
From: Vincent Hermes <vincenthermes2...@gmail.com>
Sent: Monday, February 8, 2021 10:06 AM
To: users@cloudstack.apache.org <users@cloudstack.apache.org>
Subject: ListTemplates - Internal Server Error
Hi Guys,
so we upgraded from 4.14 to 4.15 and our template menu on Primate opens the
/client/#/exception/500 Page now.
MGMT Log in this case:
-----------------------------------------------------------------------------------------------------------------------
2021-02-08 13:58:50,442 DEBUG [c.c.a.ApiServlet]
(qtp996796369-408:ctx-7c2a7827) (logid:82723f2b) ===START=== 172.~.~.~ -- GET
listall=true&templatefilter=all&showunique=true&page=1&pagesize=20&command=listTemplates&response=json
2021-02-08 13:58:50,448 DEBUG [c.c.a.ApiServer] (qtp996796369-408:ctx-7c2a7827
ctx-dc56388c) (logid:82723f2b) CIDRs from which account
'Acct[94b8e309-734d-11ea-bb62-005056972d0a-admin]' is allowed to perform API
calls: 0.0.0.0/0,::/0
2021-02-08 13:58:50,461 ERROR [c.c.a.ApiServer] (qtp996796369-408:ctx-7c2a7827
ctx-dc56388c) (logid:82723f2b) unhandled exception executing api command:
[Ljava.lang.String;@30ecb2b6
java.lang.NullPointerException
at
com.cloud.api.query.dao.TemplateJoinDaoImpl.newTemplateResponse(TemplateJoinDaoImpl.java:164)
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:567)
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:95)
at
org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:186)
at
org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:212)
at com.sun.proxy.$Proxy301.newTemplateResponse(Unknown Source)
at com.cloud.api.ApiDBUtils.newTemplateResponse(ApiDBUtils.java:2012)
at
com.cloud.api.query.ViewResponseHelper.createTemplateResponse(ViewResponseHelper.java:590)
at
com.cloud.api.query.QueryManagerImpl.listTemplates(QueryManagerImpl.java:3339)
at
org.apache.cloudstack.api.command.user.template.ListTemplatesCmd.execute(ListTemplatesCmd.java:180)
at com.cloud.api.ApiDispatcher.dispatch(ApiDispatcher.java:156)
at com.cloud.api.ApiServer.queueCommand(ApiServer.java:764)
at com.cloud.api.ApiServer.handleRequest(ApiServer.java:588)
at com.cloud.api.ApiServlet.processRequestInContext(ApiServlet.java:321)
at com.cloud.api.ApiServlet$1.run(ApiServlet.java:134)
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:131)
at com.cloud.api.ApiServlet.doGet(ApiServlet.java:93)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:645)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:750)
at
org.eclipse.jetty.servlet.ServletHolder$NotAsyncServlet.service(ServletHolder.java:1386)
at
org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:755)
at
org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:547)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:143)
at
org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:590)
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:1610)
at
org.eclipse.jetty.server.handler.ScopedHandler.nextHandle(ScopedHandler.java:233)
at
org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1300)
at
org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:188)
at
org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:485)
at
org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:1580)
at
org.eclipse.jetty.server.handler.ScopedHandler.nextScope(ScopedHandler.java:186)
at
org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1215)
at
org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:141)
at
org.eclipse.jetty.server.handler.gzip.GzipHandler.handle(GzipHandler.java:767)
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:500)
at
org.eclipse.jetty.server.HttpChannel.lambda$handle$1(HttpChannel.java:383)
at org.eclipse.jetty.server.HttpChannel.dispatch(HttpChannel.java:547)
at org.eclipse.jetty.server.HttpChannel.handle(HttpChannel.java:375)
at
org.eclipse.jetty.server.HttpConnection.onFillable(HttpConnection.java:273)
at
org.eclipse.jetty.io.AbstractConnection$ReadCallback.succeeded(AbstractConnection.java:311)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
at
org.eclipse.jetty.io.ssl.SslConnection$DecryptedEndPoint.onFillable(SslConnection.java:543)
at
org.eclipse.jetty.io.ssl.SslConnection.onFillable(SslConnection.java:398)
at
org.eclipse.jetty.io.ssl.SslConnection$2.succeeded(SslConnection.java:161)
at org.eclipse.jetty.io.FillInterest.fillable(FillInterest.java:103)
at org.eclipse.jetty.io.ChannelEndPoint$2.run(ChannelEndPoint.java:117)
at
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.runTask(EatWhatYouKill.java:336)
at
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.doProduce(EatWhatYouKill.java:313)
at
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.tryProduce(EatWhatYouKill.java:171)
at
org.eclipse.jetty.util.thread.strategy.EatWhatYouKill.run(EatWhatYouKill.java:129)
at
org.eclipse.jetty.util.thread.ReservedThreadExecutor$ReservedThread.run(ReservedThreadExecutor.java:375)
at
org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:806)
at
org.eclipse.jetty.util.thread.QueuedThreadPool$Runner.run(QueuedThreadPool.java:938)
at java.base/java.lang.Thread.run(Thread.java:835)
2021-02-08 13:58:50,467 DEBUG [c.c.a.ApiServlet] (qtp996796369-408:ctx-7c2a7827
ctx-dc56388c) (logid:82723f2b) ===END=== 172.~.~.~ -- GET
listall=true&templatefilter=all&showunique=true&page=1&pagesize=20&command=listTemplates&response=json
-------------------------------------------------------------------------------------------------------------------
"https://172.~.~.~:8443/client/api?command=listTemplates"; (Very true and normal
behaviour) :
-------------------------------------------------------------------------------------------------------------------
<listtemplatesresponse cloud-stack-version="4.15.0.0">
<errorcode>431</errorcode>
<cserrorcode>9999</cserrorcode>
<errortext>
Unable to execute API command listtemplates due to missing parameter
templatefilter
</errortext>
</listtemplatesresponse>
-------------------------------------------------------------------------------------------------------------------
But:
https://172.~.~.~:8443/client/api?command=listTemplates&templatefilter=all
(Unhandled exception / Unknown API Command) :
-------------------------------------------------------------------------------------------------------------------
<listtemplatesresponse cloud-stack-version="4.15.0.0">
<errorcode>530</errorcode>
<cserrorcode>9999</cserrorcode>
</listtemplatesresponse>
-------------------------------------------------------------------------------------------------------------------
Our console is not working as well but that should be a different problem. Do
you guys know anything bout dat?
Thanks in advance
Vincent
nicolas.vazq...@shapeblue.com
www.shapeblue.com
3 London Bridge Street, 3rd floor, News Building, London SE1 9SGUK
@shapeblue
