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!

Not able to connect from Client(JDBC Client Driver( 6.1x) )to Vertica DB instance using Virtual IP (

Configured 3 node Vertica Cluster ( CE ) and configured IPVS Load balancer.
Created a DB instance on 3 node cluster
Now, from Client like Squirrel we are trying to connect to DB Instance with Virtual IP.
The Connectivity is either failing at 1st instance or It connects for a while before disconnects.
Where as when we use Real IP . We don't see any Connection breakage to the DB instance.

Please note: The Ping for Virtual IP never breaks. The VIP is continuously pinging...

Is their some issue with Vertica Client JDBC driver of ( 6.1.x ) ?


  • I would finally solve this issue myself. VIP was loosing connection and  On my RHEL box system log messages helped me with the problem( /var/log/messages). I had issue with one of my Real IP interface . I changed that in keepalived.conf file and my VIP was up and running

Leave a Comment

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