microsoft / microsoft/durabletask-mssql

Azure SQL transient error

Open
#182 3 comments 0 reactions 1 assignee View on GitHub

@cgillum is already working on this.

Since Aug 29, 2023.

enhancement good first issue help wanted
Dominant language
C#
Stars
105
Forks
36
PR merge metrics
No merged PRs in 30d

Description

We occasionally encounter a transient Azure SQL error 47073 (see definition below) in our DF application. Our IT department is investigating root cause. It can hit any DF in our app. Is this a candidate to add to the transient errors list for automatic retry? Could additional error codes be configurable?

We could add custom retry handlers to activity and sub-orchestrator functions, but that doesn't address the other cases (entities, external events, etc). Other suggestions for handling such an error (other than wrapping every DF call in a try/catch)?

Reason: Unable to set Deny Public Network Access to Yes since there is no private endpoint enabled to access the server. Please set up private endpoints and retry the operation (https://learn.microsoft.com/azure/sql-database/sql-database-private-endpoint-overview#how-to-set-up-private-link-for-azure-sql-database).

Contributor guide

No contributing guide indexed for this repository

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.