ODBC Failover timeout when using backup hosts/nodes

yxuyxu Vertica Customer
in General Discussion

Hi,
Does anyone know if there's any vertica setting that controls ODBC timeout setting for connection fail over when using backup hosts/nodes ? Currently it takes a very long time to failover/switch to backup nodes when primary node failed.
Is there a setting just could solve this issue or is there any workarounds ?

I noticed there are threads on the same question that went unanswered https://forum.vertica.com/discussion/238559/odbc-timeout-setting-for-connection-failover-backup-node

Answers

  • moshegmosheg Vertica Employee Administrator

    Please open a support case and mention VER-9179
    Besides the DSN connection properties mentioned here, JDBC connection properties include LoginTimeout
    and ADO.NET connection properties include ConnectionTimeout

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...