system.fail_points

Contains a list of all available failpoints with their type and current status.

Description

Contains a list of all available failpoints registered in the server, along with their type and whether they are currently enabled.

Failpoints can be enabled and disabled at runtime using the SYSTEM ENABLE FAILPOINT and SYSTEM DISABLE FAILPOINT statements.

Columns

• name (String) — Name of the failpoint.
• type (Enum8(‘once’ = 0, ‘regular’ = 1, ‘pauseable_once’ = 2, ‘pauseable’ = 3)) — Type of failpoint: ‘once’ fires a single time then auto-disables, ‘regular’ fires every time, ‘pauseable_once’ blocks execution once, ‘pauseable’ blocks execution every time until resumed.
• enabled (UInt8) — Whether the failpoint is currently enabled (1) or disabled (0).

Example

Query

SYSTEM ENABLE FAILPOINT replicated_merge_tree_insert_retry_pause;
SELECT * FROM system.fail_points WHERE enabled = 1

Response

┌─name──────────────────────────────────────┬─type────────────┬─enabled─┐
│ replicated_merge_tree_insert_retry_pause  │ pauseable_once  │       1 │
└───────────────────────────────────────────┴─────────────────┴─────────┘