v.25.4Improvement

Respect loading_retries limit for errors during push

Respect loading_retries limit for errors during push to materialized view for StorageS3(Azure)Queue. Before that such errors were retried indefinitely. #78313 (Kseniia Sumarokova).
ClickHouse now respects the loading_retries limit when errors occur during data push to materialized views for StorageS3 and StorageAzureQueue, preventing indefinite retries.

Why it matters

Previously, errors occurring during data push to materialized views using StorageS3 or StorageAzureQueue were retried indefinitely, which could lead to resource exhaustion or blocking issues. This feature limits the number of retries according to the loading_retries setting, improving stability and control over error handling.

How to use it

Users can control the retry behavior by setting the loading_retries parameter in their configuration or session settings. The system will then retry up to that limit on errors during push operations to materialized views using StorageS3 or StorageAzureQueue, stopping further retries after the limit is reached.