forked from docs/doc-exports
luhuayi
177cd61a57
Reviewed-by: Pruthi, Vineet <vineet.pruthi@t-systems.com> Co-authored-by: luhuayi <luhuayi@huawei.com> Co-committed-by: luhuayi <luhuayi@huawei.com>
34 lines
6.1 KiB
HTML
34 lines
6.1 KiB
HTML
<a name="EN-US_TOPIC_0000001811490753"></a><a name="EN-US_TOPIC_0000001811490753"></a>
|
|
|
|
<h1 class="topictitle1">Fault Tolerance</h1>
|
|
<div id="body8662426"><p id="EN-US_TOPIC_0000001811490753__en-us_topic_0059778347_p16741971293">This section describes parameters used for controlling the methods that the server processes an error occurring in the database system.</p>
|
|
<div class="section" id="EN-US_TOPIC_0000001811490753__sc080ae6f23a54a1c9e4cf175efe7787b"><h4 class="sectiontitle">exit_on_error</h4><p id="EN-US_TOPIC_0000001811490753__a7ad01ca93c624e3db5807a041b89af8a"><strong id="EN-US_TOPIC_0000001811490753__en-us_topic_0059778347_en-us_topic_0058967750_b60161848">Parameter description</strong>: Specifies whether to terminate the current session.</p>
|
|
<p id="EN-US_TOPIC_0000001811490753__p1970111811131"><strong id="EN-US_TOPIC_0000001811490753__b143237114179">Type</strong>: SUSET</p>
|
|
<p id="EN-US_TOPIC_0000001811490753__aba2110a5cd794574a12bf64208ff72d1"><strong id="EN-US_TOPIC_0000001811490753__en-us_topic_0059778347_en-us_topic_0058967750_b61660271">Value range</strong>: Boolean</p>
|
|
<ul id="EN-US_TOPIC_0000001811490753__u8cb361c1af974d2e95961bc12947e04a"><li id="EN-US_TOPIC_0000001811490753__lacaccaee3f654fd88cc5b8ec5f96c362"><strong id="EN-US_TOPIC_0000001811490753__b116430464434353">on</strong> indicates that any error will terminate the current session.</li><li id="EN-US_TOPIC_0000001811490753__l7df4d1a407684ef5a8594173e09f327a"><strong id="EN-US_TOPIC_0000001811490753__b47819794934353">off</strong> indicates that only a FATAL error will terminate the current session.</li></ul>
|
|
<p id="EN-US_TOPIC_0000001811490753__aa2d05d2fd34e4eb5a69c199248f9449d"><strong id="EN-US_TOPIC_0000001811490753__b55233292105553">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490753__b842352706172155">off</strong></p>
|
|
</div>
|
|
<div class="section" id="EN-US_TOPIC_0000001811490753__s8467e2c2956442ca9ebe1bc4c69d6bf9"><h4 class="sectiontitle">omit_encoding_error</h4><p id="EN-US_TOPIC_0000001811490753__a227b1d80bce047119f555b047076e136"><strong id="EN-US_TOPIC_0000001811490753__b1077072415562">Parameter description</strong>: 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 "?".</p>
|
|
<p id="EN-US_TOPIC_0000001811490753__p52932562718"><strong id="EN-US_TOPIC_0000001811490753__b3316933154719">Type</strong>: USERSET</p>
|
|
<p id="EN-US_TOPIC_0000001811490753__ab5937fe7738948cd9d1db27a44ed6691"><strong id="EN-US_TOPIC_0000001811490753__en-us_topic_0059778347_en-us_topic_0058967750_b9233635">Value range</strong>: Boolean</p>
|
|
<ul id="EN-US_TOPIC_0000001811490753__u606c587290304407ab8329192db99180"><li id="EN-US_TOPIC_0000001811490753__l393c442d7c0b4ab4aa882edd4f60e247"><strong id="EN-US_TOPIC_0000001811490753__b207086933034353">on</strong> indicates that characters that have conversion errors will be ignored and replaced with question marks (?), and error information will be recorded in logs.</li><li id="EN-US_TOPIC_0000001811490753__lf8f5eb30c05b43c68a1396c413ea1d39"><strong id="EN-US_TOPIC_0000001811490753__b52762365334353">off</strong> indicates that characters that have conversion errors cannot be converted and error information will be directly displayed.</li></ul>
|
|
<p id="EN-US_TOPIC_0000001811490753__aec3bce8889554182bc753808d430d6f9"><strong id="EN-US_TOPIC_0000001811490753__b1079663404">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490753__b904328247">off</strong></p>
|
|
</div>
|
|
<div class="section" id="EN-US_TOPIC_0000001811490753__sc9cd4d1562654b6ebb842765d3e398e4"><a name="EN-US_TOPIC_0000001811490753__sc9cd4d1562654b6ebb842765d3e398e4"></a><a name="sc9cd4d1562654b6ebb842765d3e398e4"></a><h4 class="sectiontitle">max_query_retry_times</h4><p id="EN-US_TOPIC_0000001811490753__a046399f2096540869f7ffed5edadc801"><strong id="EN-US_TOPIC_0000001811490753__b18981432193116">Parameter description</strong>: 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 <strong id="EN-US_TOPIC_0000001811490753__b193691606330">Connection reset by peer</strong>, <strong id="EN-US_TOPIC_0000001811490753__b41851066334">Lock wait timeout</strong>, and <strong id="EN-US_TOPIC_0000001811490753__b11460191213316">Connection timed out</strong>. Setting this parameter to <strong id="EN-US_TOPIC_0000001811490753__b1737891833312">0</strong> will disable the retry feature.</p>
|
|
<p id="EN-US_TOPIC_0000001811490753__p2364123518270"><strong id="EN-US_TOPIC_0000001811490753__b11651133513477">Type</strong>: USERSET</p>
|
|
<p id="EN-US_TOPIC_0000001811490753__a62f7dd88fc944363835fa76ab35bece3"><strong id="EN-US_TOPIC_0000001811490753__b1592203154216">Value range</strong>: an integer ranging from 0 to 20</p>
|
|
<p id="EN-US_TOPIC_0000001811490753__a5de2356eb81445a9af6a108d4aeb9062"><strong id="EN-US_TOPIC_0000001811490753__b11441792421">Default value</strong>: <strong id="EN-US_TOPIC_0000001811490753__b161455914214">6</strong></p>
|
|
</div>
|
|
<div class="section" id="EN-US_TOPIC_0000001811490753__section21795287405"><h4 class="sectiontitle">retry_ecode_list</h4><p id="EN-US_TOPIC_0000001811490753__p117952817400"><strong id="EN-US_TOPIC_0000001811490753__b1514154743915">Parameter description</strong>: Specifies the list of SQL error types that support automatic retry.</p>
|
|
<p id="EN-US_TOPIC_0000001811490753__p728764511279"><strong id="EN-US_TOPIC_0000001811490753__b059753817474">Type</strong>: USERSET</p>
|
|
<p id="EN-US_TOPIC_0000001811490753__p9179202844011"><strong id="EN-US_TOPIC_0000001811490753__b1397615017391">Value range</strong>: a string</p>
|
|
<p id="EN-US_TOPIC_0000001811490753__p41791628124012"><strong id="EN-US_TOPIC_0000001811490753__b5575102923319">Default value</strong>: 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</p>
|
|
</div>
|
|
</div>
|
|
<div>
|
|
<div class="familylinks">
|
|
<div class="parentlink"><strong>Parent topic:</strong> <a href="dws_04_0883.html">GUC Parameters of the GaussDB(DWS) Database</a></div>
|
|
</div>
|
|
</div>
|
|
|