Unable to connect to vertica clusters from MC.

Tim_Collie

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.

Raul_1

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

Tim_Collie

vertica-place-7.1.0-0.x86_64
vertica-R-lang-7.1.0-0.x86_64
vertica-7.1.0-0.x86_64

Raul_1

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

Raul_1

Some good news.  A fix for this has been introduced in an upcoming hotfix.