Help Center> Data Warehouse Service> Developer Guide> Setting GUC Parameters> Fault Tolerance
View PDF

Fault Tolerance

This section describes parameters used for controlling the methods that the server processes an error occurring in the database system.

exit_on_error

Parameter description: Specifies whether to terminate the current session.

Type: SUSET

Value range: Boolean

  • on indicates that any error will terminate the current session.
  • off indicates that only a FATAL error will terminate the current session.

Default value: off

omit_encoding_error

Parameter description: If this parameter is set to on and the client character set of the database is encoded in UTF-8 format, the occurring character encoding conversion errors will be recorded in logs. Additionally, converted characters that have conversion errors will be ignored and replaced with question marks (?).

Type: USERSET

Value range: Boolean

  • on indicates that characters that have conversion errors will be ignored and replaced with question marks (?), and error information will be recorded in logs.
  • off indicates that characters that have conversion errors cannot be converted and error information will be directly displayed.

Default value: off

max_query_retry_times

Parameter description: Specifies the maximum number of automatic retries for an SQL statement having execution errors. Currently, supported error types include "Connection reset by peer", "Lock wait timeout", and "Connection timed out". If it is set to 0, the retry function is disabled.

Type: USERSET

Value range: an integer ranging from 0 to 20

Default value: 6

retry_ecode_list

Parameter description: Specifies the list of SQL error types that support automatic retry.

Type: USERSET

Value range: a string

Default value: YY001 YY002 YY003 YY004 YY005 YY006 YY007 YY008 YY009 YY010 YY011 YY012 YY013 YY014 YY015 53200 08006 08000 57P01 XX003 XX009 YY016 CG003 CG004

Parent topic: Setting GUC Parameters