Vertica ODBC Connection errors via Virtual IP

Abhishek_2

Hi All,
i have installed Vertica 8.1.1-8 and configured a ODBC client to connect to this cluster. i see intermittent connection timeouts with following errors:
1. [Vertica][VerticaDSII] (160) Connection attempt failed: could not receive data from server: Software caused connection abort (0x00002745/10053)
(160)
2. [Vertica][VerticaDSII] (160) Connection attempt failed: could not send load balance negotiation packet: Connection reset by peer (0x00002746/10054)

DSN File for the ODBC connection:
[ODBC]
UID=testuser
SERVER=152.129.2.4
ConnectionLoadBalance=1
DRIVER=Vertica
PORT=5433
PreferredAddressFamily=IPv4
DATABASE=vmart

Any suggestions that can cause this.

Thanks,
Abhishek

Jim_Knicely

Did you enable native load balancing in the Vertica database?

See:
https://my.vertica.com/docs/9.0.x/HTML/index.htm#Authoring/AdministratorsGuide/LoadBalancing/EnablingAndDisablingNativeConnectionLoadBalancing.htm

Abhishek_2

@Jim_Knicely , Thank you for you reply. yes, Native Load Balancing is enabled on the cluster and it is set to ROUND ROBIN load balancing. would you know of any other reason that can cause this.

Best Regards,
Abhishek

Jim_Knicely

What is the client?

Abhishek_2

ODBC call from windows