The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.

Connect to Cluster from MC Console

I have installed the MC console on my system and I want to connect to a database. When I enter the IP and password, I get the message that says, Failed to retrieve databases from xx.xx.xx.xx Reason: Connection to host has been Lost. In the log I get the following messages ERROR DbAdminController java.lang.Exception: Connection to the host has been lost at com.vertica.admin.tools.webui.service.AgentConnectionServiceImpl.getDBs(AgentConnectionServiceImpl.java:371) at com.vertica.admin.tools.webui.controllers.DbAdminController.getDB(DbAdminController.java:651) at com.vertica.admin.tools.webui.controllers.DbAdminController.importDB(DbAdminController.java:575) 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.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:427) at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:415) at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:788) at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:717) at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644) at org.springframework.web.servlet.FrameworkServlet.doGet(FrameworkServlet.java:549) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) 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:61) at com.vertica.admin.tools.webui.servlets.VuiWebSocketServlet.doGet(VuiWebSocketServlet.java:39) at javax.servlet.http.HttpServlet.service(HttpServlet.java:707) 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.spring... 30 Jul 2013 15:06:50 ERROR DbAdminController getDB>> Exception while getting database information from xx.xx.xx.xx: Connection to the host has been lost 30 Jul 2013 15:06:50 ERROR AgentConnectionServiceImpl getDBs>> Error response from agent. transferObject: TransferObject [success=false, messageCode=0, messageStr=Connection to the host has been lost, obj=null] 30 Jul 2013 15:06:50 WARN AgentConnectionServiceImpl executeCommandWithRetry>> cluster is null, is this while importing (connecting to) a database Can you help?

Comments

  • Hi,

    A few things to check:

    1. If MC's internal DB is running.

    Check on MC machine, if vertica process is running:

    $ ps -ef | grep vertica

    You should show a Vertica database process as below:

     /opt/vertica/bin/vertica -C <db name> -D <catalog directory path> -h <host IP> -p <port number>

    2. Check if Vertica agent is runnin on all database cluster nodes. 

    $ service vertica_agent status

    If agent are not running, start them:

    $ service vertica_agent start

    3. MC machine can access port 5444 on Vertica nodes.

    telnel port 5444 from MC --> Vertica node

    4. Nodes can access port 5444 on other nodes in the cluster

    5. All database nodes can access port 5450 on MC server.

    telnet port 5450 from Node(s) --> MC 


    Thanks,
    Pravesh
  • 1) It is OK 2) In the nodes I get: No RPM: no package provides vertica [Failed] 3) I'm fixing it 4) I'm fixing it Can you help on 2?

  • On the cluster nodes:

    Check if they are listening on port 5444:
    # netstat -an | grep 5444

    If not, restart the Vertifca Agent on the node:
    # sudo /etc/init.d/vertica_agent restart
  • The problem that I had, was with agent start and a check it was running!! Solved and now working fine!!!
  • Thanks a lot its really help me to figure out the problem

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.