Lu, Huayi
e6fa411af0
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: Lu, Huayi <luhuayi@huawei.com> Co-committed-by: Lu, Huayi <luhuayi@huawei.com>
7.0 KiB
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