queue messaging in sql error log

Question

queue messaging in sql error log

JP10

SSCarpal Tunnel

Points: 4372
More actions
August 27, 2018 at 10:53 am

#362615

Hello,
Can somebody explain these messages what they mean and how to get rid of them? Do we just need to stop and start the sql queues? Appreciate the help.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Michael L John One Orange Chip Points: 27060 More actions · Answer 1

The exact error from the logs would be very helpful to provide some insight.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

JP10 SSCarpal Tunnel Points: 4372 More actions · Answer 2

Ah yes sorry here is the message.

The queue 1845581613 in database 6 has activation enabled and contains unlocked messages but no RECEIVE has been executed for 1113349 seconds.

Michael L John One Orange Chip Points: 27060 More actions · Answer 3

Have you queried sys.dm_broker_queue_monitors?
Doing a google search, for this error, there appears to be numerous causes of this error.

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

JP10 SSCarpal Tunnel Points: 4372 More actions · Answer 4

yes I have ran that query and i have some that says INACTIVE and NOTIFIED.

Sue_H SSC Guru Points: 90860 More actions · Answer 5

JP10 - Monday, August 27, 2018 11:39 AM
yes I have ran that query and i have some that says INACTIVE and NOTIFIED.

There are different things that could cause this - refer to the troubleshooting section in this article (and read the rest of it as well, very informative):
Understanding Queue Monitors

Also try the steps towards the end of this article to recycle the queue monitor.

Sue

Michael L John One Orange Chip Points: 27060 More actions · Answer 6

Sue_H - Monday, August 27, 2018 11:55 AM
JP10 - Monday, August 27, 2018 11:39 AM
yes I have ran that query and i have some that says INACTIVE and NOTIFIED.
There are different things that could cause this - refer to the troubleshooting section in this article (and read the rest of it as well, very informative):
Understanding Queue Monitors
Also try the steps towards the end of this article to recycle the queue monitor.
Sue

Beat me to it!

Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/

Sue_H SSC Guru Points: 90860 More actions · Answer 7

Michael L John - Monday, August 27, 2018 12:10 PM
Beat me to it!

You know what they say about great minds.... 🙂

Sue

JP10 SSCarpal Tunnel Points: 4372 More actions · Answer 8

Hello guys thanks for the help. I just disabled and enabled the queues and that seemed to take the messages away. Recycling the queues helped I guess for now (crossing finers) Thanks again!