KNOWLEDGE BASE

Tableau Server Repository Does Not Start After Modifying Cluster Controller Timeout Setting


Published: 25 Jan 2017
Last Modified Date: 14 Mar 2019

Issue

After modifying the clustercontroller timeout setting for Tableau Server's Postgres repository, Tableau Server and its Postgres repository may not start. Additionally,  the following error may occur in the clustercontroller logs:
WARN  : com.tableausoftware.cluster.postgres.SpawnPostgresRunner - Monitoring thread for the master instance didn't start. Trying failover...
java.lang.IllegalArgumentException: Window size must be at least 1

Environment

Tableau Server

Resolution

Set the clustercontroller.pgsql_connection_timeout_ms setting to 60000 or less.

Tableau Server on Windows 2018.1 and earlier versions:
Open a command prompt as an administrator, navigate to the Tableau Server bin folder and enter the following commands:

tabadmin stop
tabadmin set clustercontroller.pgsql_connection_timeout_ms 36000
tabadmin config
tabadmin start


Tableau Server on Windows 2018.2 and newer, and Tableau Server on Linux: 
Open a command prompt as an administrator, navigate to the Tableau Server bin folder and enter the following commands: 

tsm stop
tsm configuration set -k clustercontroller.pgsql_connection_timeout_ms -v 36000
tsm pending-changes apply
tsm start


The maximum value for this setting is 60000.  The default setting is 3000.

 

Cause

If the clustercontroller.pgsql_connection_timeout_ms setting was set to a number greater than the maximum allowed value (60000)
Did this article resolve the issue?