Support Questions
Find answers, ask questions, and share your expertise
Announcements
Alert: Welcome to the Unified Cloudera Community. Former HCC members be sure to read and learn how to activate your account here.

500 status code received on GET method for API: /api/v1/clusters/GHDP_sandbox/alerts?format=groupedSummary.

Highlighted

500 status code received on GET method for API: /api/v1/clusters/GHDP_sandbox/alerts?format=groupedSummary.

Explorer

I was trying to setup the sandbox cluster with HDP 2.3.6. Everytime when I open ambari GUI I am seeing the error (attached image to the post) and logs. Please share any thoughts.

Thanks in advance.

18 Oct 2016 14:08:54,113 ERROR [qtp-client-26] ReadHandler:91 - Caught a runtime exception executing a query java.lang.NullPointerException at org.apache.ambari.server.controller.internal.AlertResourceProvider.toResource(AlertResourceProvider.java:210) at org.apache.ambari.server.controller.internal.AlertResourceProvider.getResources(AlertResourceProvider.java:179) at org.apache.ambari.server.controller.internal.AlertResourceProvider.queryForResources(AlertResourceProvider.java:135) at org.apache.ambari.server.controller.internal.ClusterControllerImpl$ExtendedResourceProviderWrapper.queryForResources(ClusterControllerImpl.java:945) at org.apache.ambari.server.controller.internal.ClusterControllerImpl.getResources(ClusterControllerImpl.java:132) at org.apache.ambari.server.api.query.QueryImpl.doQuery(QueryImpl.java:508) at org.apache.ambari.server.api.query.QueryImpl.queryForResources(QueryImpl.java:380) at org.apache.ambari.server.api.query.QueryImpl.execute(QueryImpl.java:216) at org.apache.ambari.server.api.handlers.ReadHandler.handleRequest(ReadHandler.java:68) at org.apache.ambari.server.api.services.BaseRequest.process(BaseRequest.java:135) at org.apache.ambari.server.api.services.BaseService.handleRequest(BaseService.java:105) at org.apache.ambari.server.api.services.BaseService.handleRequest(BaseService.java:74) at org.apache.ambari.server.api.services.AlertService.getAlerts(AlertService.java:58) at sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) 18 Oct 2016 14:08:54,115 WARN [qtp-client-26] ServletHandler:563 - /api/v1/clusters/GHDP_Sandbox/alerts java.lang.NullPointerException at org.apache.ambari.server.controller.internal.AlertResourceProvider.toResource(AlertResourceProvider.java:210) at org.apache.ambari.server.controller.internal.AlertResourceProvider.getResources(AlertResourceProvider.java:179) at org.apache.ambari.server.controller.internal.AlertResourceProvider.queryForResources(AlertResourceProvider.java:135) at org.apache.ambari.server.controller.internal.ClusterControllerImpl$ExtendedResourceProviderWrapper.queryForResources(ClusterControllerImpl.java:945) at org.apache.ambari.server.controller.internal.ClusterControllerImpl.getResources(ClusterControllerImpl.java:132) at org.apache.ambari.server.api.query.QueryImpl.doQuery(QueryImpl.java:508) at org.apache.ambari.server.api.query.QueryImpl.queryForResources(QueryImpl.java:380) at org.apache.ambari.server.api.query.QueryImpl.execute(QueryImpl.java:216) at org.apache.ambari.server.api.handlers.ReadHandler.handleRequest(ReadHandler.java:68) at org.apache.ambari.server.api.services.BaseRequest.process(BaseRequest.java:135) at org.apache.ambari.server.api.services.BaseService.handleRequest(BaseService.java:105) at org.apache.ambari.server.api.services.BaseService.handleRequest(BaseService.java:74) at org.apache.ambari.server.api.services.AlertService.getAlerts(AlertService.java:58) at sun.reflect.GeneratedMethodAccessor236.invoke(Unknown Source) at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) at java.lang.reflect.Method.invoke(Method.java:497) at com.sun.jersey.spi.container.JavaMethodInvokerFactory$1.invoke(JavaMethodInvokerFactory.java:60) at com.sun.jersey.server.impl.model.method.dispatch.AbstractResourceMethodDispatchProvider$ResponseOutInvoker._dispatch(AbstractResourceMethodDispatchProvider.java:205) at com.sun.jersey.server.impl.model.method.dispatch.ResourceJavaMethodDispatcher.dispatch(ResourceJavaMethodDispatcher.java:75) at com.sun.jersey.server.impl.uri.rules.HttpMethodRule.accept(HttpMethodRule.java:302) at com.sun.jersey.server.impl.uri.rules.SubLocatorRule.accept(SubLocatorRule.java:137) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.ResourceClassRule.accept(ResourceClassRule.java:108) at com.sun.jersey.server.impl.uri.rules.RightHandPathRule.accept(RightHandPathRule.java:147) at com.sun.jersey.server.impl.uri.rules.RootResourceClassesRule.accept(RootResourceClassesRule.java:84) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1542) at com.sun.jersey.server.impl.application.WebApplicationImpl._handleRequest(WebApplicationImpl.java:1473) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1419) at com.sun.jersey.server.impl.application.WebApplicationImpl.handleRequest(WebApplicationImpl.java:1409) at com.sun.jersey.spi.container.servlet.WebComponent.service(WebComponent.java:409) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:540) at com.sun.jersey.spi.container.servlet.ServletContainer.service(ServletContainer.java:715) at javax.servlet.http.HttpServlet.service(HttpServlet.java:848) at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:684) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1496) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:330) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:118) at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:84) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.apache.ambari.server.security.authorization.AmbariAuthorizationFilter.doFilter(AmbariAuthorizationFilter.java:182) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.authentication.www.BasicAuthenticationFilter.doFilter(BasicAuthenticationFilter.java:150) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87) at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:342) at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:192) at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:160) at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:237) at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:167) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467) at org.apache.ambari.server.api.MethodOverrideFilter.doFilter(MethodOverrideFilter.java:72) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467) at org.apache.ambari.server.api.AmbariPersistFilter.doFilter(AmbariPersistFilter.java:47) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467) at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:82) at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:294) at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1467) at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:501) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:137) at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:557) at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:231) at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:1086) at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:429) at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:193) at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:1020) at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:135) at org.apache.ambari.server.controller.AmbariHandlerList.processHandlers(AmbariHandlerList.java:209) at org.apache.ambari.server.controller.AmbariHandlerList.processHandlers(AmbariHandlerList.java:198) at org.apache.ambari.server.controller.AmbariHandlerList.handle(AmbariHandlerList.java:132) at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:116) at org.eclipse.jetty.server.Server.handle(Server.java:370) at org.eclipse.jetty.server.AbstractHttpConnection.handleRequest(AbstractHttpConnection.java:494) at org.eclipse.jetty.server.AbstractHttpConnection.headerComplete(AbstractHttpConnection.java:971) at org.eclipse.jetty.server.AbstractHttpConnection$RequestHandler.headerComplete(AbstractHttpConnection.java:1033) at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:644) at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:235) at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:82) at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:696) at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:53) at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:608) at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:543)

8659-capture.png

8 REPLIES 8
Highlighted

Re: 500 status code received on GET method for API: /api/v1/clusters/GHDP_sandbox/alerts?format=groupedSummary.

Super Collaborator

Based on the information above, I think you're using an older version of Ambari (2.2.0 or 2.2.1 maybe?). It's fixed in later versions of Ambari; I'd suggest 2.4.x ...

However, I think you fix this by restarting Ambari Server if you want to keep your current version.

Highlighted

Re: 500 status code received on GET method for API: /api/v1/clusters/GHDP_sandbox/alerts?format=groupedSummary.

Explorer

@jonathan Hurley I am using ambari 2.1.2 version and this version supports HDP 2.3.6.

Like u said I restarted the ambari-server but its still the same.

Highlighted

Re: 500 status code received on GET method for API: /api/v1/clusters/GHDP_sandbox/alerts?format=groupedSummary.

Super Collaborator

That's very odd that a restart didn't fix it. A restart would have repopulated the entity associations from the database. There's a constraint which ensures that you have an alert definition for every alert history entity. The fact that it's still giving this exact same problem after a restart would indicate you have some kind of data violation in the DB.

Are you using MySQL by any chance?

Highlighted

Re: 500 status code received on GET method for API: /api/v1/clusters/GHDP_sandbox/alerts?format=groupedSummary.

Explorer

yea I am using MySQL db at the backend

Highlighted

Re: 500 status code received on GET method for API: /api/v1/clusters/GHDP_sandbox/alerts?format=groupedSummary.

Super Collaborator

OK, I think this is a case where you're using the wrong MySQL engine. MySQL supports MyISAM and InnoDB. MyISAM doesn't support transactions or constraints (which is very bad) ... InnoDB does.

Ambari only works with MySQL on InnoDB. Can you verify which database engine you're using?

SHOW TABLE STATUS WHERE Name = 'alert_history'
Highlighted

Re: 500 status code received on GET method for API: /api/v1/clusters/GHDP_sandbox/alerts?format=groupedSummary.

Super Guru

Stop server

then check permissions

/var/run/ambari-server

Restart Ambari Server then check status:

ambari-server status

then check

ambari-agent status

Restart browser (clean and refresh)

see: /var/log/ambari-server/ambari-server.log

see: /var/log/ambari-agent/ambari-agent.log

https://community.hortonworks.com/questions/20603/500-status-code-received-on-get-method-for-api-api...

https://community.hortonworks.com/questions/20239/unable-to-log-in-to-ambari-ui-npe500-server-error....

Highlighted

Re: 500 status code received on GET method for API: /api/v1/clusters/GHDP_sandbox/alerts?format=groupedSummary.

New Contributor

I got the same issue reported in first thread.

I changed the MySQL DB point to InnoDB and updated all the tables and databases in mysql.

Restarted ambari. I've updated latest version of Ambari from Hortonworks.

Nothing fixes my issue.

Please advice on the next steps.

500 status code

received on GET method for API: /api/v1/clusters/sa_cluster/alerts?format=groupedSummary

Re: 500 status code received on GET method for API: /api/v1/clusters/GHDP_sandbox/alerts?format=groupedSummary.

Super Collaborator

If your database was MyISAM, then changing it to InnoDB won't help since none of the constraints will exist. You'll need to backup your data, re-create the database using the scripts in /var/lib/ambari-server/resources, and then re-import your data. The import may have constraint violations which you'll need to fix.

Also, to fix this specific issue, you could also clear out current notifications:

DELETE FROM alert_current;

Make sure you shut down Ambari Server before doing this.

However, I still recommend that if you are coming from a MyISAM DB, that you perform the above steps to ensure that all data consistency constraints are created in your new InnoDB database.

Don't have an account?
Coming from Hortonworks? Activate your account here