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: This parameter determines how to handle character code errors that occur when converting a database to UTF-8. If set to true, it replaces the invalid characters 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 times that an SQL statement with errors can be re-executed. SQL statements with the following types of errors can be re-executed: Connection reset by peer, Lock wait timeout, and Connection timed out. If this parameter is set to 0, the re-execution function is disabled.

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