An exception has been raised that is likely due to a transient failure

sql-azure
Tags: #<Tag:0x00007f499f318d88>

#1

I am upgrading to 1.7.0. Following migration guide. Local SQL is running okay, while deploying to azure I am getting spammed with:

System.InvalidOperationException
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. <— Resource ID : 1. The request limit for the database is 60 and has been reached. See ‘http://go.microsoft.com/fwlink/?LinkId=267637’ for assistance.

How can I solve this now?


#2

Also getting lot of traces
Entity Framework Core 2.2.4-servicing-10062 initialized 'ApplicationDbContext' using provider 'Microsoft.EntityFrameworkCore.SqlServer' with options: MaxPoolSize=128

Does it have something to do with setting: QueuePollInterval = TimeSpan.Zero

How can I solve this now?


#3

I got my app service back running by removing provided SqlServerStorageOptions() in docs.
I am not sure why docs are recommending following settings:
new SqlServerStorageOptions
{
CommandBatchMaxTimeout = TimeSpan.FromMinutes(5),
SlidingInvisibilityTimeout = TimeSpan.FromMinutes(5),
QueuePollInterval = TimeSpan.Zero,
UseRecommendedIsolationLevel = true,
UsePageLocksOnDequeue = true,
DisableGlobalLocks = true
}));

while default options for SqlServerStorageOptions are completely different…