Search

Service Broker internal activation error message by Men Peng

Active

10
0
Sign in
 to vote
Type: Bug
ID: 775483
Opened: 12/30/2012 9:49:40 PM
Access Restriction: Public
0
Workaround(s)
10
User(s) can reproduce this bug
I am using SQL Server 2012 Enterprise SP1 and I am getting lots of the following error message in SQL error logs:

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 required.

I have tried restarting the server but the error comes back as soon as the server is rebooted.
Details (expand)

Product Language

English

Version

SQL Server 2012 - Enterprise Edition

Category

SQL Engine

Operating System

Windows Server 2012 Datacenter

Operating System Language

US English

Steps to Reproduce

Continuously generated

Actual Results

Nil

Expected Results

Nil

Platform

X64

Virtualization

Other (e.g. VM Ware, specify in Description)
File Attachments
0 attachments
Sign in to post a comment.
Posted by Marco Carozzi on 1/17/2013 at 5:13 AM
I have exactly the same issue in the same conditions; Service Broker does what it should but this error is disrupting my error log; anyway to stop it ?
Same Service Broker structure works properly on a wide number of other instances, from 2005 to 2008 R2.
Many thanks

         Marco
Sign in to post a workaround.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement