v.22.6New Feature

Added SYSTEM UNFREEZE Query for Complete Backup Deletion

Official CH changelog text
Added SYSTEM UNFREEZE query that deletes the whole backup regardless if the corresponding table is deleted or not. #36424 (Vadim Volodin).
Introduced the SYSTEM UNFREEZE query which allows deleting an entire backup regardless of whether the related table still exists.

Why it matters

This feature solves the problem of leftover backups for tables that have been deleted, ensuring users can clean up backups comprehensively and avoid orphaned data occupying storage unnecessarily.

How to use it

Execute the SYSTEM UNFREEZE query to remove the whole backup, independent of the current existence of the corresponding table.

Related resources

PreviousNext