Skip to main content
Question

ODBC Failover timeout when using backup hosts/nodes

  • April 17, 2020
  • 1 reply
  • 5 views

yxu

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

1 reply

mosheg
Forum|alt.badge.img+2
  • Participating Frequently
  • April 19, 2020

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