Skip to end of metadata
Go to start of metadata

Sample output for traceflag 1204:

 

00:0006:00000:00018:2013/12/23 15:57:47.23 server  Deadlock Id 1 detected Deadlock Id 1 detected. 1 deadlock chain(s) involved.

Deadlock Id 1: Process (Familyid 0, Spid 19, Suid 1) was executing a UPDATE command in the procedure '*ss1635564802_2033547888ss*' at line 1 at nested level 1. Deadlock Id 1: Process 19 was involved in application 'isql'. Deadlock Id 1: Process 19 was involved on host name 'bret-sun2'. Deadlock Id 1: Process 19 was involved in transaction '$user_transaction'. SQL Text: update t1 set x = 5

Executing procedure: *ss1635564802_2033547888ss* Subordinate SQL Text: update t1 set x = 5 Deadlock Id 1: Process (Familyid 0, Spid 18, Suid 1) was executing a UPDATE command in the procedure '*ss1651564859_2050324848ss*' at line 1 at nested level 1. Deadlock Id 1: Process 18 was involved in application 'isql'. Deadlock Id 1: Process 18 was involved on host name 'bret-sun2'. Deadlock Id 1: Process 18 was involved in transaction '$user_transaction'. SQL Text: update t2 set x = 6

Executing procedure: *ss1651564859_2050324848ss* Subordinate SQL Text: update t2 set x = 6 Deadlock Id 1: Process (Familyid 0, Spid 18) was waiting for a 'update page' lock on page 889 of table 't2' in database 'tempdb' but process (Familyid 0, Spid 19) already held a 'exclusive page' lock on it. Deadlock Id 1: Process (Familyid 0, Spid 19) was waiting for a 'update page' lock on page 881 of table 't1' in database 'tempdb' but process (Familyid 0, Spid 18) already held a 'exclusive page' lock on it.

Deadlock Id 1: Process (Familyid 0, Spid 19) was chosen as the victim. Victim process host = `bret-sun2', user = `sa' program name = `isql' host processes = `8518' .

End of deadlock information.

 

 

  • No labels