Important

Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.

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?