Options

ODBC Failover timeout when using backup hosts/nodes

yxuyxu Vertica Customer

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

  • Options
    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
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file