March 26, 2013 at 1:42 am
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
March 26, 2013 at 2:08 am
http://msdn.microsoft.com/en-IN/library/ms177413%28v=sql.105%29.aspx
details can be found here
March 26, 2013 at 8:26 am
Is there a permanent solution to prevent time out expired.
March 27, 2013 at 4:29 am
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.
March 21, 2014 at 1:27 pm
This apparently been fixed in SQL 2012 SP1 CU4.
FIX: Error 1222 when you use Service Broker in SQL Server 2012
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply