SQL Execution Fails With the Error Message "canceling statement due to statement timeout" Reported

Symptom

When an SQL statement is executed for more than 2 hours, the following error information is displayed:

1

ERROR: canceling statement due to statement timeoutTime.

Possible Causes

If the execution time of a statement exceeds the time specified by statement_timeout, an error is reported and the statement execution exits.

Handling Procedure

Method 1: Modify the statement_timeout parameter on the console.

1. Log in to the GaussDB(DWS) management console.
2. In the navigation pane on the left, choose Clusters.
3. In the cluster list, find the target cluster and click its name. The cluster information page is displayed.
4. Click the Parameter Modifications tab and modify the value of parameter session_timeout. Click Save.
   

   By default, GaussDB(DWS) does not trigger SQL timeout. The default value of statement_timeout is 0. If you have manually modified this parameter, you are advised to change it back to the default value 0 or set it to a proper value to prevent SQL timeout affecting other tasks.

5. In the Modification Preview dialog box, confirm the modification and click Save.
6. If No is displayed in the Restart Cluster column of the statement_timeout parameter, the parameter modification takes effect immediately without restart.
   Figure 1 Modifying the statement_timeout parameter