SSB – Handling and Removing Poison Messages

最新推荐文章于 2024-09-19 10:25:23 发布

weixin_33887443

最新推荐文章于 2024-09-19 10:25:23 发布

阅读量81

点赞数

本文介绍了Service Broker如何自动检测及处理毒消息，并解释了毒消息并非损坏的消息，而是应用程序无法成功处理的消息。当包含接收语句的事务回滚五次时，Service Broker会禁用所有受影响的队列。

SSB – Handling and Removing Poison Messages<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

A poison message is a message containing information that an application cannot successfully process. A poison message is not a corrupt message, and may not be an invalid request.

Service Broker provides automatic poison message detection. When a transaction that contains a RECEIVE statement rolls back five times, Service Broker disables all queues that the transaction received message from, by automatically setting the QUEUE STATUS to OFF. In addition, Service Broker generates an event of type Broker: Queue Disabled.

Excerpted from the following URLs, MSDN. Click on the links to get more detail.

References:

1. Removing Poison Messages, http://msdn2.microsoft.com/en-us/library/ms166137.aspx

2. Handling Poison Messages, http://msdn2.microsoft.com/en-us/library/ms171592.aspx