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 at at 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 at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod( at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle( at org.springframework.web.servlet.DispatcherServlet.doDispatch( at org.springframework.web.servlet.DispatcherServlet.doService( at org.springframework.web.servlet.FrameworkServlet.processRequest( at org.springframework.web.servlet.FrameworkServlet.doGet( at javax.servlet.http.HttpServlet.service( at javax.servlet.http.HttpServlet.service( at org.eclipse.jetty.servlet.ServletHolder.handle( at org.eclipse.jetty.servlet.ServletHandler.doHandle( at org.eclipse.jetty.server.handler.ScopedHandler.handle( at at org.eclipse.jetty.server.session.SessionHandler.doHandle( at org.eclipse.jetty.server.handler.ContextHandler.doHandle( at org.eclipse.jetty.servlet.ServletHandler.doScope( at org.eclipse.jetty.server.session.SessionHandler.doScope( at org.eclipse.jetty.server.handler.ContextHandler.doScope( at org.eclipse.jetty.server.handler.ScopedHandler.handle( at org.eclipse.jetty.server.Dispatcher.forward( at org.eclipse.jetty.server.Dispatcher.forward( at at at javax.servlet.http.HttpServlet.service( at org.eclipse.jetty.websocket.WebSocketServlet.service( at javax.servlet.http.HttpServlet.service( at org.eclipse.jetty.servlet.ServletHolder.handle( at org.eclipse.jetty.servlet.ServletHandler$CachedChain.doFilter( 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?


  • 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 

  • 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
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file