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: 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 automatic retry times when an SQL statement error occurs. Currently, a statement can start retrying if the following errors occur: Connection reset by peer, Lock wait timeout, and Connection timed out. If this parameter is set to 0, the retry 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: 5 GB
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 45003