Lightning: Suggest Adding a Retry Mechanism When Querying for Duplicate Records to Resolve

## Enhancement
To resolve duplicate records, Lightning relies on a SELECT query to retrieve the necessary information from a metadata table. However, errors may occur during this process, such as 'Error 1105: sync load stats timeout'. Ignoring such errors can result in unresolved duplicates and potential data corruption. To address this issue, we suggest implementing a retry mechanism for the query to ensure that all duplicate data is resolved. A backoff policy could be applied to the retry process to improve the robustness of the duplicate resolution logic. This improvement will minimize the chance of errors.