Copied to clipboard

Flag this post as spam?

This post will be reported to the moderators as potential spam to be looked at


  • Tim Zander 2 posts 22 karma points
    Jul 02, 2020 @ 20:08
    Tim Zander
    0

    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.

  • Tim Zander 2 posts 22 karma points
    Jul 10, 2020 @ 15:02
    Tim Zander
    0

    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?

Please Sign in or register to post replies

Write your reply to:

Draft