> ## Documentation Index
> Fetch the complete documentation index at: https://private-7c7dfe99-mintlify-8a08bda2.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# system.fail_points

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

<h2 id="description">
  Description
</h2>

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.

<h2 id="columns">
  Columns
</h2>

* `name` ([String](/reference/data-types)) — Name of the failpoint.
* `type` ([Enum8('once' = 0, 'regular' = 1, 'pauseable\_once' = 2, 'pauseable' = 3)](/reference/data-types)) — 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](/reference/data-types)) — Whether the failpoint is currently enabled (1) or disabled (0).

<h2 id="example">
  Example
</h2>

```sql title="Query" theme={null}
SYSTEM ENABLE FAILPOINT replicated_merge_tree_insert_retry_pause;
SELECT * FROM system.fail_points WHERE enabled = 1
```

```text title="Response" theme={null}
┌─name──────────────────────────────────────┬─type────────────┬─enabled─┐
│ replicated_merge_tree_insert_retry_pause  │ pauseable_once  │       1 │
└───────────────────────────────────────────┴─────────────────┴─────────┘
```