Increase delay between SQL connection retry attempts

What is a one sentence summary of your feature request?

Add a longer delay between retry attempts to reduce failures caused by transient SQL connection errors.

Please describe your idea in detail. What is your problem, why do you feel this idea is the best solution, etc.

During processing tasks, transient SQL connection errors can occasionally occur due to temporary network issues. The current retry logic immediately performs two retries in quick succession (less than one second apart), which often fails to mitigate the issue:

Microsoft.Data.SqlClient.SqlException (0x80131904): A transport-level error has occurred when receiving results from the server. (provider: TCP Provider, error: 2 - Connection was terminated)

Add a longer delay between retry attempts would increase the likelihood of a successful reconnection when a transient issue is involved.

How do you currently solve the challenges you have by not having this feature?

It is necessary to restart the job execution manually.

2 Likes

Hi @raphael Thanks for the feedback! We’ve added a ticket for this improvement, and we’ll update this post as it moves through the process. :slight_smile: