CLEAR PIPELINE ERRORS

Removes most pipeline errors.

This command is especially useful when a pipeline reaches its allocated storage space for errors, which causes the pipeline to pause. Errors stored in the active error file are still visible.

Syntax

CLEAR PIPELINE ERRORS [FOR <pipeline_name>]

Note

Specifying the name of a pipeline with CLEAR PIPELINE ERRORS is optional. When CLEAR PIPELINE ERRORS is run without specifying a pipeline, errors for all the pipelines are removed.

Argument

pipeline_name (Optional): Name of a pipeline.

Remarks

  • To increase the number of errors that can be stored, increase the value of the ingest_errors_max_disk_space_mb engine variable.

  • Query the information_schema.PIPELINES_ERRORS view to view the pipeline errors. For example:

    SELECT * FROM information_schema.PIPELINES_ERRORS;

Examples

CLEAR PIPELINE ERRORS;
START PIPELINE books;
CLEAR PIPELINE ERRORS FOR books;

Last modified:

Was this article helpful?