morganbr
commented
5 years ago A later exception suggested a fix: An exception has been raised that is likely due to a transient failure. Consider enabling transient error resiliency by adding 'EnableRetryOnFailure()' to the 'UseSqlServer' call.
We're hitting periodic SQL exceptions connecting to the SQL server like this:
{OriginalFormat}: An error occurred using the connection to database '{database}' on server '{server}'. Account Id:
Application version: 1.0.0.0
AspNetCoreEnvironment: Production
Auth user Id:
Browser version:
CategoryName: Microsoft.EntityFrameworkCore.Database.Connection
City: Redmond
Client IP address: 0.0.0.0
Cloud role instance: RD2818787C5EDD
Cloud role name: puzzlehunt
Country or region: United States
database: puzzleserver
Device model:
Device type: PC
Event time: 3/29/2019, 3:41:47 PM
Exception: System.Data.SqlClient.SqlException (0x80131904): Database 'puzzleserver' on server 'puzzlehunt' is not currently available. Please retry the connection later. If the problem persists, contact customer support, and provide them the session tracing ID of '040FC663-B4AD-4585-821E-6E337DA501EE'.
...
Exception type: System.Data.SqlClient.SqlException
Failed method: System.Data.SqlClient.SqlInternalConnectionTds..ctor
Operating system:
Operation Id: 60ad57af-4b76089a032039c6
Operation name: GET /Teams/List
Parent Id: |60ad57af-4b76089a032039c6.
Problem Id: System.Data.SqlClient.SqlException at System.Data.SqlClient.SqlInternalConnectionTds..ctor
Sample Rate: 100
SDK version: aspnet5c:2.3.0
server: tcp:puzzlehunt.database.windows.net,1433
Session Id:
Severity level: Error
Source of synthetic traffic:
State or province: Washington
Telemetry type: exception
User Id:
View this instance in the Azure portal<\a> View similar exceptions in this time range<\a>