Question

Vertica ODBC Connection errors via Virtual IP

Forum|Forum|8 years ago
November 1, 2017
4 replies
19 views

+1

Abhishek_2
Participating Frequently

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

+2

Jim_Knicely
Participating Frequently
Forum|Forum|8 years ago
November 1, 2017

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

Like

+1

Abhishek_2
Author
Participating Frequently
Forum|Forum|8 years ago
November 14, 2017

@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