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 4 posts 24 karma points
    Jul 02, 2020 @ 20:08
    Tim Zander

    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 4 posts 24 karma points
    Jul 10, 2020 @ 15:02
    Tim Zander

    An update, this seems to be corresponding with execution times in umbracoLock taking over 1.8s(which is the hardcoded timeout ( )

    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?

  • Simon steed 375 posts 687 karma points
    Jan 28, 2021 @ 13:08
    Simon steed

    Did you guys ever get a resolution to this, happening a lot since 8.9

  • No1sBothered 7 posts 27 karma points
    Jun 23, 2021 @ 15:07

    We are seeing this in 8.14 on Azure, anyone else?

  • Leon Lindeberg 12 posts 103 karma points
    Jun 24, 2021 @ 07:36
    Leon Lindeberg

    Have a look at this directly related issue:

Please Sign in or register to post replies

Write your reply to: