The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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