fail_points

Description

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

In builds with failpoint support (USE_LIBFIU=1), failpoints can be enabled and disabled at runtime using the SYSTEM ENABLE FAILPOINT and SYSTEM DISABLE FAILPOINT statements. These statements are not available in builds without failpoint support, although the table remains available.

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).

Examples

This example requires a build with failpoint support (USE_LIBFIU=1).

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

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