v.23.9Improvement
Added restore setting restore_broken_parts_as_detached to handle broken parts during RESTORE process
Added restore settingrestore_broken_parts_as_detached: if it's true the RESTORE process won't stop on broken parts while restoring, instead all the broken parts will be copied to thedetachedfolder with the prefix `broken-from-backup'. If it's false the RESTORE process will stop on the first broken part (if any). The default value is false. #53877 (Vitaly Baranov).
Why it matters
This feature addresses the issue where the RESTORE process would stop immediately upon encountering broken parts in the backup. By enabling this setting, users can avoid restore failures due to corrupted parts and handle them separately, improving the robustness and flexibility of data restoration.How to use it
Set therestore_broken_parts_as_detached setting to true during the RESTORE operation to allow the process to skip broken parts and move them to the detached folder with the prefix broken-from-backup. By default, this setting is false, which causes the restore to stop on the first broken part.