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.

SYSTEM DISABLE ALL FAILPOINTS disables every failpoint at once and resumes any thread blocked on a pauseable one, which is useful for returning a server to a clean state without having to know what is currently enabled.

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 │
└───────────────────────────────────────────┴─────────────────┴─────────┘