Unable to connect to vertica clusters from MC.

I have installed a fresh version of MC 7.0.1 and am attempting to connect to a preprod vertica cluster. I have confirmed connectivity on ports 5450 and 5444 between the MC and all nodes as well as insuring the agent is running on all nodes.

I get the following error within the MC when attempting the import -

Import cluster with ip (x.x.x.x) failed with message: null

Looking at the logs I see the following on the MC -

28 Oct 2014 15:31:46,852 [qtp555551311-118 - /webui/admin/clusters/host/ping?1414510274931] VuiUtils INFO  - executeCommand>> command: ping -c 2 10.21.200.110
28 Oct 2014 15:31:47,934 [qtp555551311-118 - /webui/admin/clusters/host/ping?1414510274931] VuiUtils INFO  - getBuildInfo>> commandOutput: PING 10.21.200.110 (10.21.200.110) 56(84) bytes of data.
64 bytes from 10.21.200.110: icmp_seq=1 ttl=63 time=0.386 ms
64 bytes from 10.21.200.110: icmp_seq=2 ttl=63 time=0.868 ms

--- 10.21.200.110 ping statistics ---
2 packets transmitted, 2 received, 0% packet loss, time 1002ms
rtt min/avg/max/mdev = 0.386/0.627/0.868/0.241 ms

28 Oct 2014 15:31:48,002 [qtp555551311-117 - /webui/admin/clusters/services/discover?1414510276057] AgentCommands INFO  - theCommand = https://10.21.200.110:5444/hosts?only=hostname,host_id,nics.name,nics.ipaddr,total_memory,cpu_info.n...  httpMethod:GET
28 Oct 2014 15:31:48,537 [qtp555551311-117 - /webui/admin/clusters/services/discover?1414510276057] AgentCommands INFO  - executeCommand>> statusCode: 200, Raw agentResponse: {}
28 Oct 2014 15:31:48,544 [qtp555551311-117 - /webui/admin/clusters/services/discover?1414510276057] AgentConnectionServiceImpl ERROR - Error getting host IPs:null
28 Oct 2014 15:31:48,551 [qtp555551311-117 - /webui/admin/clusters/services/discover?1414510276057] AgentConnectionServiceImpl ERROR - java.lang.NullPointerException
        at com.vertica.admin.tools.webui.utils.AgentCommands.processJSONArray(AgentCommands.java:206)
        at com.vertica.admin.tools.webui.utils.AgentHostCommands.processResponse(AgentHostCommands.java:59)
        at com.vertica.admin.tools.webui.utils.AgentCommands.executeCommand(AgentCommands.java:818)
        at com.vertica.admin.tools.webui.utils.AgentCommands.executeCommand(AgentCommands.java:653)
        at com.vertica.admin.tools.webui.utils.AgentCommands.executeCommandWithRetryWithinCluster(AgentCommands.java:548)
        at com.vertica.admin.tools.webui.utils.AgentCommands.execute(AgentCommands.java:450)
        at com.vertica.admin.tools.webui.utils.AgentCommands.execute(AgentCommands.java:437)
        at com.vertica.admin.tools.webui.service.AgentConnectionServiceImpl.getAllHostIPs(AgentConnectionServiceImpl.java:748)
        at com.vertica.admin.tools.webui.controllers.ClusterAdminController.discoverCluster(ClusterAdminController.java:1124)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
        at java.lang.reflect.Method.invoke(Unknown Source)
        at org.springframework.web.method.support.InvocableHandlerMethod.invoke(InvocableHandlerMethod.java:213)
        at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:126)
        at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:96)
        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:617)
        at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:578)
        at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:80)
        at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:923)
        at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:852)
        at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:882)
        at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:789)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:547)
        at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:480)
        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
        at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:520)
        at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227)
        at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:941)
        at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:409)
        at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)
        at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:875)
        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
        at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:241)
        at org.eclipse.jetty.server.Dispatcher.forward(Dispatcher.java:115)
        at com.vertica.admin.tools.webui.servlets.VuiWebSocketServlet.forwardToDispatcher(VuiWebSocketServlet.java:66)
        at com.vertica.admin.tools.webui.servlets.VuiWebSocketServlet.doPost(VuiWebSocketServlet.java:50)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)
        at org.eclipse.jetty.websocket.WebSocketServlet.service(WebSocketServlet.java:80)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
        at org.eclipse.jetty.servlet.ServletHolder.handle(ServletHolder.java:547)
        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1359)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:322)
        at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.invoke(FilterSecurityInterceptor.java:116)
        at org.springframework.security.web.access.intercept.FilterSecurityInterceptor.doFilter(FilterSecurityInterceptor.java:83)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
        at org.springframework.security.web.access.ExceptionTranslationFilter.doFilter(ExceptionTranslationFilter.java:113)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
        at org.springframework.security.web.session.SessionManagementFilter.doFilter(SessionManagementFilter.java:103)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
        at org.springframework.security.web.authentication.AnonymousAuthenticationFilter.doFilter(AnonymousAuthenticationFilter.java:113)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
        at org.springframework.security.web.authentication.rememberme.RememberMeAuthenticationFilter.doFilter(RememberMeAuthenticationFilter.java:146)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
        at org.springframework.security.web.servletapi.SecurityContextHolderAwareRequestFilter.doFilter(SecurityContextHolderAwareRequestFilter.java:54)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
        at org.springframework.security.web.savedrequest.RequestCacheAwareFilter.doFilter(RequestCacheAwareFilter.java:45)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
        at org.springframework.security.web.authentication.AbstractAuthenticationProcessingFilter.doFilter(AbstractAuthenticationProcessingFilter.java:182)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
        at org.springframework.security.web.authentication.logout.LogoutFilter.doFilter(LogoutFilter.java:105)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
        at org.springframework.security.web.context.SecurityContextPersistenceFilter.doFilter(SecurityContextPersistenceFilter.java:87)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
        at org.springframework.security.web.session.ConcurrentSessionFilter.doFilter(ConcurrentSessionFilter.java:125)
        at org.springframework.security.web.FilterChainProxy$VirtualFilterChain.doFilter(FilterChainProxy.java:334)
        at org.springframework.security.web.FilterChainProxy.doFilterInternal(FilterChainProxy.java:184)
        at org.springframework.security.web.FilterChainProxy.doFilter(FilterChainProxy.java:155)
        at org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:346)
        at org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:259)
        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1330)
        at org.eclipse.jetty.servlets.UserAgentFilter.doFilter(UserAgentFilter.java:77)
        at org.eclipse.jetty.servlets.GzipFilter.doFilter(GzipFilter.java:144)
        at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter(ServletHandler.java:1330)
        at org.eclipse.jetty.servlet.ServletHandler.doHandle(ServletHandler.java:478)
        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:119)
        at org.eclipse.jetty.security.SecurityHandler.handle(SecurityHandler.java:520)
        at org.eclipse.jetty.server.session.SessionHandler.doHandle(SessionHandler.java:227)
        at org.eclipse.jetty.server.handler.ContextHandler.doHandle(ContextHandler.java:941)
        at org.eclipse.jetty.servlet.ServletHandler.doScope(ServletHandler.java:409)
        at org.eclipse.jetty.server.session.SessionHandler.doScope(SessionHandler.java:186)
        at org.eclipse.jetty.server.handler.ContextHandler.doScope(ContextHandler.java:875)
        at org.eclipse.jetty.server.handler.ScopedHandler.handle(ScopedHandler.java:117)
        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110)
        at org.eclipse.jetty.rewrite.handler.RewriteHandler.handle(RewriteHandler.java:312)
        at org.eclipse.jetty.server.handler.HandlerWrapper.handle(HandlerWrapper.java:110)
        at org.eclipse.jetty.server.Server.handle(Server.java:345)
        at org.eclipse.jetty.server.HttpConnection.handleRequest(HttpConnection.java:441)
        at org.eclipse.jetty.server.HttpConnection$RequestHandler.content(HttpConnection.java:936)
        at org.eclipse.jetty.http.HttpParser.parseNext(HttpParser.java:801)
        at org.eclipse.jetty.http.HttpParser.parseAvailable(HttpParser.java:224)
        at org.eclipse.jetty.server.AsyncHttpConnection.handle(AsyncHttpConnection.java:51)
        at org.eclipse.jetty.io.nio.SelectChannelEndPoint.handle(SelectChannelEndPoint.java:586)
        at org.eclipse.jetty.io.nio.SelectChannelEndPoint$1.run(SelectChannelEndPoint.java:44)
        at org.eclipse.jetty.util.thread.QueuedThreadPool.runJob(QueuedThreadPool.java:598)
        at org.eclipse.jetty.util.thread.QueuedThreadPool$3.run(QueuedThreadPool.java:533)
        at java.lang.Thread.run(Unknown Source)

28 Oct 2014 15:31:48,552 [qtp555551311-117 - /webui/admin/clusters/services/discover?1414510276057] ClusterAdminController ERROR - Import cluster with ip (10.21.200.110) failed with message:null

I am lost as what to try next, any help is appreciated.


Comments

  • What version of Vertica is on the cluster that is being imported?
    To find out, you can run the following on any of the nodes in the cluster.
    rpm -qa | grep vertica
  • vertica-place-7.1.0-0.x86_64
    vertica-R-lang-7.1.0-0.x86_64
    vertica-7.1.0-0.x86_64


  • Try installing MC version 7.1, this should address your issue.  The MC and the cluster vertica version should be the same -
    From the  section - HP Vertica Server and Management Console
    Compatibility
    Each version of Vertica Analytic Database Management Console is compatible only with the
    matching version of the Vertica Analytic Database server. For example, the Vertica Analytic
    Database 7.1 server is supported with Vertica Analytic Database 7.1 Management Console only.
    http://my.vertica.com/docs/7.1.x/PDF/HP_Vertica_7.1.x_Supported_Platforms.pdf
  • Some good news.  A fix for this has been introduced in an upcoming hotfix.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.