Note
This parameter is available starting with V3.2.4.
Description
The ob_query_switch_leader_retry_timeout parameter specifies the maximum retry timeout for failed queries.
Privilege requirements
Query the parameter
The
systenant and all user tenants can query the parameter by using theSHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
The
systenant and user tenants can modify the parameter.
Attributes
Attribute |
Description |
|---|---|
| Type | Time |
| Default value | 0ms, which indicates that the retry timeout check feature is disabled. |
| Value range | [0ms, +∞) |
| Modifiable | Yes. You can use the ALTER SYSTEM SET statement to modify the parameter. |
| Effective upon OBServer node restart | No. The setting takes effect immediately. |
Considerations
If the value of the parameter is n (n > 0), an error is returned to the client when the cumulative execution time of a retried query exceeds n.
Examples
Disable the retry timeout check feature for queries.
obclient> ALTER SYSTEM SET ob_query_switch_leader_retry_timeout = '0ms';