System.Data.SqlClient.SqlException (0x80131904): Lock request time out period exceeded.
I am seeing over 1500 of these errors per day recently.
It often causes problems for members logging in, but it also happens at other places.
Umbraco 8.5.5, database is Azure SQL with Premium P2 250DTU
I am able to reduce the number of these areas by changing the database scale(which seems to reduce memory usage on Azure SQL instance. ) however in a few minutes I am back to seeing errors.
Umbraco is running on premise on VM with 8 cores and 16GB RAM.
When looking into the database queries we are seeing the following query having the longest cumulative wait time:
'SELECT value FROM umbracoLock WITH (REPEATABLEREAD) WHERE if=@0'
The max wait time for this query is 28701ms, average wait time is 132.61ms
I have looked at other similar questions and applied their solutions(I checked that my max worker process is 1, 'restarting' the sql process by changing scale)
I'm not sure that it would be appropriate to increase this timeout, or what could be done to reduce how long this is taking. Does anyone have any suggestions?
System.Data.SqlClient.SqlException (0x80131904): Lock request time out period exceeded.
I am seeing over 1500 of these errors per day recently.
It often causes problems for members logging in, but it also happens at other places.
Umbraco 8.5.5, database is Azure SQL with Premium P2 250DTU
I am able to reduce the number of these areas by changing the database scale(which seems to reduce memory usage on Azure SQL instance. ) however in a few minutes I am back to seeing errors.
Umbraco is running on premise on VM with 8 cores and 16GB RAM.
When looking into the database queries we are seeing the following query having the longest cumulative wait time: 'SELECT value FROM umbracoLock WITH (REPEATABLEREAD) WHERE if=@0'
The max wait time for this query is 28701ms, average wait time is 132.61ms
I have looked at other similar questions and applied their solutions(I checked that my max worker process is 1, 'restarting' the sql process by changing scale)
Any assistance is appreciated.
An update, this seems to be corresponding with execution times in umbracoLock taking over 1.8s(which is the hardcoded timeout ( https://github.com/umbraco/Umbraco-CMS/blob/d45ef632f186e6b4c08ba93ca7f2ac64ffaccb39/src/Umbraco.Core/Persistence/SqlSyntax/SqlServerSyntaxProvider.cs#L254 )
I'm not sure that it would be appropriate to increase this timeout, or what could be done to reduce how long this is taking. Does anyone have any suggestions?
Did you guys ever get a resolution to this, happening a lot since 8.9
We are seeing this in 8.14 on Azure, anyone else?
Have a look at this directly related issue:
https://github.com/umbraco/Umbraco-CMS/issues/9594
is working on a reply...