
You might be wondering what the minimum and maximum values are for the spread timeout. Although not reported in the documentation, we can easily figure out those values ourselves!
Example:
dbadmin=> SELECT SET_SPREAD_OPTION( 'TokenTimeout', '-1');
ERROR 9000: Invalid value for option TokenTimeout. Timeout must be 0 (auto) or not less than 8000 msec
dbadmin=> SELECT SET_SPREAD_OPTION( 'TokenTimeout', '1000000000');
ERROR 9010: Invalid value for option TokenTimeout. Timeout must not exceed 999000 msec
So the minimum value for spread timeout is 8 seconds and the maximum value for spread timeout is 999 seconds.
Note that Vertica issues a warning when setting the spread timeout to a value greater than 1 minute!
dbadmin=> SELECT SET_SPREAD_OPTION( 'TokenTimeout', '99900');
WARNING 9002: Setting the token timeout greater than 60000 msec may severely decrease cluster responsiveness to node shutdowns and failures
NOTICE 9003: Spread has been notified about the change
SET_SPREAD_OPTION
--------------------------------------------------------
Spread option 'TokenTimeout' has been set to '99900'.
(1 row)
Helpful Links:
https://www.vertica.com/docs/latest/HTML/Content/Authoring/UsingVerticaOnAzure/AdjustingSpreadDaemonTimeouts.htm https://www.vertica.com/docs/latest/HTML/Content/Authoring/SQLReferenceManual/Functions/VerticaFunctions/SET_SPREAD_OPTION.htm
Have fun!
Related Posts:
Adjusting Spread Daemon Timeouts for Virtual Environments
Set the Spread Daemon Timeout Back to Default Value
Monitor the Current Value of Node Spread Daemon Timeouts