Note
For V4.1.0, this parameter is available starting with V4.1.0.
Description
log_storage_warning_tolerance_time specifies the time from when a log disk I/O fails to when the disk is marked as faulty and the primary node is switched.
Privilege requirements
Query the parameter
The sys tenant and all user tenants can query the value of this parameter by using the
SHOW PARAMETERSstatement or theGV$OB_PARAMETERSview.Modify the parameter
Only the sys tenant can modify this parameter. User tenants cannot modify this parameter.
Attributes
| Attribute | Description |
|---|---|
| Type | Time |
| Default value | 5s |
| Value range | [1s,300s] |
| 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.
NoteStarting with V4.2.5 BP2, this parameter takes effect dynamically in V4.2.5. |
Examples
Set the time from when a log disk I/O fails to when the disk is marked as faulty and the primary node is switched to 5s.
obclient> ALTER SYSTEM SET log_storage_warning_tolerance_time = '5s';