Invalid XML in Extended Events xml_deadlock_report output - by Jonathan Kehayias

Status : 

  Fixed<br /><br />
		This item has been fixed in the current or upcoming version of this product.<br /><br />
		A more detailed explanation for the resolution of this particular item may have been provided in the comments section.


5
0
Sign in
to vote
ID 404168 Comments
Status Closed Workarounds
Type Bug Repros 3
Opened 1/22/2009 10:42:39 PM
Access Restriction Public

Description

The xml_deadlock_report provides an invalid xml document in the value output.
Sign in to post a comment.
Posted by John Bell on 11/5/2010 at 7:33 AM
This problem is also in SQL Server 2008 R2 and fixed in CU1
Posted by debettap on 9/30/2010 at 11:43 AM
This issue was fixed in SQL Server 2008 SP1 CU6 (see http://support.microsoft.com/kb/978629 for details).

Thanks,

Peter DeBetta
Posted by Microsoft on 1/27/2009 at 8:46 AM
Thanks for bringing this to our attention. This issue is a side effect of changes made in the deadlock monitor for SQL 2008. The event raised via XEvent reflects the change in the deadlock XML that multiple victims per cycle can be found, where as SQL 2005 and before could only find one victim per cycle.

Unfortunately there is a problem in the xml generation that a block of XML is omitted. We are aggressively perusing a fix for this issue.

Thanks,
Jerome Halmans
SQLOS
Posted by Jonathan Kehayias on 1/22/2009 at 10:47 PM
I uploaded scripts to produce a deadlock. First run the setup script, then run the Updater in one query window and the selector in another. Use the query included in the description below to retrieve the deadlock reports from XEvents.

I also included the output graph from sql trace and from XEvents as txt files for this problem.