Skip to main content
Question

VerticaError connection attempt failed:could not send SSL negotiation packet: Socket is not connect

  • March 16, 2019
  • 2 replies
  • 13 views
mpedroso
Forum|alt.badge.img+1

Hello guys

I have a big problem with my Vertica cluster. I'm trying to create a connection to the database using OBDC with Vertica Client 9.2 (which is the version I use) and when I activate the "Use connection load balacing" option the following error: "vertica connection attempt failed: could not send SSL negotiation packet: Socket is not connected ".

Has anyone ever experienced this? Could you tell me how to fix this?

p.s: I already ran the native load balacing with the command: SELECT SET_LOAD_BALANCE_POLICY ('ROUNDROBIN');

    2 replies

    DaveT
    Forum|alt.badge.img
    • DaveT
    • Participating Frequently
    • March 17, 2019

    You also need to either set the export_subnet for the database or the export_address for each node and it needs to be a public address the client can reach. Otherwise the load balancer will return a node's private addresses that is used for Vertica node intra-communication. The client will try to connect to that private address and it will be unable to do so.

    Note that 9.2 also has added the ability to use load balancing policies if you want to take a look at that.

    Link that describes requirement for classic load balancing requirements (look at the "Requirements" section):
    https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/ManagingClientConnections/LoadBalancing/Legacy/LegacyClusterLoadBalancing.htm

    More info on setting database export_subnet or nodes export_address:
    https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/CopyExportData/ChangingNodeExportAddress.htm

    More info on load balancing policies, new in 9.2:
    https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/ManagingClientConnections/LoadBalancing/AboutConnectionLoadBalancingPolicies.htm

    mpedroso
    Forum|alt.badge.img+1
    • mpedroso
    • Author
    • Participating Frequently
    • March 17, 2019
    Hey DaveT

    Thanks for the answer. I understand, I actually did a cluster installation using the old ips of exclusive communication between the nodes in the vertica_install script parameters ...

    Can you change this IP so that Vertica's load balancing uses public IP?

    PS. : I have not read the documentation yet, I'll do it now.
    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement