I am upgrading to 1.7.0. Following migration guide. Local SQL is running okay, while deploying to azure I am getting spammed with:
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.
I got my app service back running by removing provided SqlServerStorageOptions() in docs.
I am not sure why docs are recommending following settings:
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…