Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ErrorLog Found in sql server 2012 Expand / Collapse
Author
Message
Posted Tuesday, March 26, 2013 1:42 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 5:34 AM
Points: 26, Visits: 470
Hi ,


I found the below error in my error log in sql server 2012 . Kindly advice.


Error:
-----

An error occurred in Service Broker internal activation while trying to scan the user queue 'msdb.dbo.InternalMailQueue' for its status. Error: 1222, State: 51. Lock request time out period exceeded. This is an informational message only. No user action is

Can anyone let me the impact of this as it is an production server. Kindly let me know it ASAP.

Regards
Vishal
Post #1435294
Posted Tuesday, March 26, 2013 2:08 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Thursday, June 12, 2014 2:04 PM
Points: 1,789, Visits: 1,014
http://msdn.microsoft.com/en-IN/library/ms177413%28v=sql.105%29.aspx

details can be found here


Jayanth Kurup
Post #1435303
Posted Tuesday, March 26, 2013 8:26 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Today @ 5:34 AM
Points: 26, Visits: 470
Is there a permanent solution to prevent time out expired.
Post #1435528
Posted Wednesday, March 27, 2013 4:29 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, May 15, 2014 1:52 AM
Points: 5, Visits: 94
There is no permanent solution as such at database server level.

As per the above link:
Implementing an error handler that traps error message 1222 allows an application to handle the time-out situation and take remedial action, such as: automatically resubmitting the statement that was blocked or rolling back the entire transaction.

Its not recommended to change the LOCK_TIMEOUT value at server level.
You can try to change it for a specific connection or transaction submitted.
Post #1435817
Posted Friday, March 21, 2014 1:27 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 21, 2014 1:25 PM
Points: 1, Visits: 57
This apparently been fixed in SQL 2012 SP1 CU4.

FIX: Error 1222 when you use Service Broker in SQL Server 2012
http://support.microsoft.com/kb/2837910
Post #1553648
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse