Fault Tolerance

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: When performing character encoding conversion in the database, if a character encoding error occurs and the target character set encoding is UTF-8, the converted character with the error can be ignored and replaced with "?".

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 retries for the automatic retry feature when a SQL statement encounters an error. Currently, the supported error types for retry include Connection reset by peer, Lock wait timeout, and Connection timed out. Setting this parameter to 0 will disable the retry feature.

Type: USERSET

Value range: an integer ranging from 0 to 20

Default value: 6

max_cn_temp_file_size

Parameter description: Specifies the maximum number of temporary files that can be used by the CN during automatic SQL statement retries. The value 0 indicates that no temporary file is used.

Type: SIGHUP

Value range: an integer ranging from 0 to 10485760. The unit is KB.

Default value: 5GB

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 F0011 F0012 45003 42P30