Administrators can configure the global query timeout (queryTimeout parameter) to stop SQL queries from running longer than the limit. It prevents queries that take too long to impact other users.
The Limit query time is configured as below.
The administrator sets the default value on the SQL for Confluence configuration page. To set the 'Maximum number of seconds for query to run' in Global Configuration, refer to Global Configuration.
Administrators can enable the Restrict overriding global configuration limits flag to prevent overriding the Limit query time parameter and enforce the default value set on the Global configuration page. For more information, refer to Get Started - Configuration - 11.x.
An administrator can override the global queryTimeout setting for specific data source profiles in Global Configuration. The global setting takes effect if this is not overridden. For more information, refer to Data Source Profiles - Limit query time.
Users can change the default queryTimeout parameter value for the SQL and SQL-Query macros. Selecting a value from the list for Maximum number of seconds for query to run overrides the default.
| Info |
|---|
Overriding the queryTimeoutparameter
|
...
If the Macro queryTimeout parameter is set to No Limit, then queryTimeout considers the Confluence Page timeout value.
Suppose the queryTimeout parameter is set to No Limit in all three configuration options: Macro level parameter, Profile configuration, and Global configuration. In that case, the queryTimeout is set to unlimited, and the page will be timed out based on the Confluence Page timeout value.
Administrators can view the Confluence page timeout value in the path General Configuration > Users and Security > Security Configuration > Page timeout.
