Share via

Since SQL Server 14.0.3430.2 update, lock_timeout delay is divided by 2

Sebastien Flaesch 21 Reputation points
2022-03-29T09:41:04.923+00:00

Hello!

In our Linux machine, we have update SQL Server 2017 to version 14.0.3430.2 and since this version, the lock_timeout seems to be divided by ~2 when waiting for locks...

Is this a know issue?

[f4gl@dirac ~]$ uname -a
Linux dirac.strasbourg.4js.com 3.10.0-862.el7.x86_64 #1 SMP Wed Mar 21 18:14:51 EDT 2018 x86_64 x86_64 x86_64 GNU/Linux

Seb!

187856-screen1.png

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,361 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,601 questions
0 comments
Accepted answer
  1. AmeliaGu-MSFT 13,971 Reputation points Microsoft Vendor
    2022-03-30T05:46:30.677+00:00

    Hi SebastienFlaesch-0302,
    Welcome to Microsoft Q&A.

    In our Linux machine, we have update SQL Server 2017 to version 14.0.3430.2 and since this version, the lock_timeout seems to be divided by ~2 when waiting for locks.

    Sorry that I don’t have the Linux environment for testing currently.
    Based on your results, I recommend you submit it to the Microsoft feedback at this link https://feedback.azure.com/d365community/forum/04fe6ee0-3b25-ec11-b6e6-000d3a4f0da0
    Your feedback is valuable for Microsoft to improve the level of products and service. Appreciate for your understanding.

    Best Regards,
    Amelia

    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

2 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Sebastien Flaesch 21 Reputation points
    2022-03-29T12:54:21.777+00:00

    Just tested with SQL Server 2019 / 15.0.4198.2 on Windows OS: The timeout error occurs after ~5.30 seconds

  2. Sebastien Flaesch 21 Reputation points
    2022-04-06T08:51:17.16+00:00

    Hum......

    I have posted the issue on feedback.azure.com as suggested:

    https://feedback.azure.com/d365community/idea/317358d3-edaf-ec11-a81c-0022484ee92d

    But got no answer... is anyone reading these?

    Seb