v.24.2Improvement

Added query_id column and error stacktrace to backups tables

Added query_id column for tables system.backups and system.backup_log. Added error stacktrace to error column. #60220 (Maksim Kita).
Added a query_id column to the system.backups and system.backup_log tables, and enriched the error column with detailed error stacktraces.

Why it matters

This feature improves traceability and debugging for backup operations by associating each backup with its originating query_id and providing detailed error stacktraces when failures occur. It helps users quickly identify and troubleshoot backup issues.

How to use it

After updating to the version containing this feature, users can query the system.backups and system.backup_log tables to see the query_id of backup operations along with enriched error column information that now includes stacktraces, improving diagnostics without any additional configuration.