none
Error: 1222, State: 51. Lock request time out period exceeded. This is an informational message only. No user action is required.

    Question

  • Our production database upgrade from SQL Server 2008 R2 to SQL Server 2012 SP1 recently.

    And the active tasks are still increasing, we have 690000 active tasks now.

    find that many error message:

    Date 8/18/2013 7:01:11 PM
    Log SQL Server (Current - 8/18/2013 7:16:00 PM)
    Source spid35s
    Message
    An error occurred in Service Broker internal activation while trying to scan the user queue 'Queue Name' for its status. Error: 1222, State: 51. Lock request time out period exceeded. This is an informational message only. No user action is required.

    Does the Service Broker queue will cause this?

    Monday, August 19, 2013 6:07 AM

Answers

  • Hi吴一晴,

    Based on the information in the error log, I suggest installing Cumulative Update 4 for SQL Server 2012 SP1. For more detail information, you can refer to the following link:

    FIX: Error 1222 when you use Service Broker in SQL Server 2012
    http://support.microsoft.com/kb/2837910/en-us


    Allen Li
    TechNet Community Support

    • Marked as answer by GrantWu2013 Tuesday, August 20, 2013 9:34 AM
    Tuesday, August 20, 2013 5:39 AM
    Moderator

All replies

  • Hi吴一晴,

    Based on the information in the error log, I suggest installing Cumulative Update 4 for SQL Server 2012 SP1. For more detail information, you can refer to the following link:

    FIX: Error 1222 when you use Service Broker in SQL Server 2012
    http://support.microsoft.com/kb/2837910/en-us


    Allen Li
    TechNet Community Support

    • Marked as answer by GrantWu2013 Tuesday, August 20, 2013 9:34 AM
    Tuesday, August 20, 2013 5:39 AM
    Moderator
  • Thanks Allen Li,

    The amount of tasks is another bug of SQL Server 2012, More detail refer to below link:

    FIX: A memory leak occurs when you enable AlwaysOn Availability Groups or SQL Server failover cluster in Microsoft SQL Server 2012

    http://support.microsoft.com/kb/2877100


    Tuesday, August 20, 2013 5:55 AM