@Rocky How can I cancel backup?

To cancel an ongoing backup task in StarRocks, use the

CANCEL BACKUP

statement. Syntax

sql
CANCEL BACKUP { FROM <db_name> | FOR EXTERNAL CATALOG }

Examples * Cancel a backup in a specific database:

sql
    CANCEL BACKUP FROM example_db;

* Cancel a backup for external catalog metadata (supported from v3.4.0 onwards):

sql
    CANCEL BACKUP FOR EXTERNAL CATALOG;

Useful Tips * Check Status: Since backups are asynchronous, you can check the status of a job (including its ID and state) by running:

sql
    SHOW BACKUP FROM example_db;

* Restrictions: You can only have one running

BACKUP

or

RESTORE

job per database at any given time. * Shared-data Clusters: Note that shared-data StarRocks clusters do not support the built-in

BACKUP

and

RESTORE

commands. References • sql-reference/sql-statements/backup_restore/CANCEL_BACKUP.md • sql-reference/sql-statements/backup_restore/BACKUP.md • sql-reference/sql-statements/backup_restore/CANCEL_RESTORE.md • administration/management/compaction.md • sql-reference/sql-statements/backup_restore/SHOW_BACKUP.md • administration/management/Backup_and_restore.md • administration/management/monitoring/metrics.md