Advertisement

07.23.2008 at 11:16AM PDT, ID: 23589569 | Points: 250
[x]
Attachment Details

Sql Server Deadlock

Asked by spscorp in MS SQL Server

Our application has started experiencing a deadlock situation and this is what we got from sql server trace log.

Can somebody please help us interpreting it and finding the query which is responsible for the deadlock?Start Free Trial 
1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:
27:
28:
29:
30:
31:
32:
33:
34:
35:
36:
37:
38:
39:
40:
41:
42:
43:
44:
45:
46:
47:
48:
49:
50:
51:
52:
53:
54:
55:
56:
57:
58:
59:
60:
61:
62:
63:
64:
65:
66:
67:
68:
69:

2008-07-23 13:17:07.55 	spid4	ResType:LockOwner Stype:'OR' Mode: U SPID:62 ECID:0 Ec:(0x5CF73528) Value:0x638
2008-07-23 13:17:07.55 	spid4	Victim Resource Owner:
2008-07-23 13:17:07.55 	spid4	ResType:LockOwner Stype:'OR' Mode: U SPID:62 ECID:0 Ec:(0x5CF73528) Value:0x638
2008-07-23 13:17:07.55 	spid4	Requested By: 
2008-07-23 13:17:07.55 	spid4	Input Buf: Language Event: INSERT INTO SalesTransaction (FKGolfCourseID,UniqueS
2008-07-23 13:17:07.55 	spid4	SPID: 58 ECID: 0 Statement Type: UPDATE Line #: 7
2008-07-23 13:17:07.55 	spid4	Owner:0x1c4d1180 Mode: U        Flg:0x0 Ref:0 Life:00000001 SPID:58 ECID:0
2008-07-23 13:17:07.55 	spid4	Grant List 1::
2008-07-23 13:17:07.55 	spid4	KEY: 8:940582439:27 (080069c32651) CleanCnt:2 Mode: U Flags: 0x0
2008-07-23 13:17:07.55 	spid4	Node:2
2008-07-23 13:17:07.55 	spid4	
2008-07-23 13:17:07.55 	spid4	ResType:LockOwner Stype:'OR' Mode: U SPID:58 ECID:0 Ec:(0x1B021528) Value:0x1a8
2008-07-23 13:17:07.55 	spid4	Requested By: 
2008-07-23 13:17:07.55 	spid4	Input Buf: Language Event: INSERT INTO SalesTransaction (FKGolfCourseID,UniqueS
2008-07-23 13:17:07.55 	spid4	SPID: 62 ECID: 0 Statement Type: UPDATE Line #: 7
2008-07-23 13:17:07.55 	spid4	Owner:0x1b1e1380 Mode: X        Flg:0x0 Ref:0 Life:02000000 SPID:62 ECID:0
2008-07-23 13:17:07.55 	spid4	Grant List 0::
2008-07-23 13:17:07.55 	spid4	KEY: 8:940582439:27 (080093cd6cd5) CleanCnt:2 Mode: X Flags: 0x0
2008-07-23 13:17:07.55 	spid4	Node:1
2008-07-23 13:17:07.55 	spid4	
2008-07-23 13:17:07.55 	spid4	Wait-for graph
2008-07-23 13:17:07.55 	spid4	
2008-07-23 13:17:07.55 	spid4	...
2008-07-23 13:17:05.04 	spid4	ResType:LockOwner Stype:'OR' Mode: U SPID:115 ECID:0 Ec:(0x6A9FD528) Value:0x61
2008-07-23 13:17:05.04 	spid4	Victim Resource Owner:
2008-07-23 13:17:05.04 	spid4	ResType:LockOwner Stype:'OR' Mode: U SPID:115 ECID:0 Ec:(0x6A9FD528) Value:0x61
2008-07-23 13:17:05.04 	spid4	Requested By: 
2008-07-23 13:17:05.04 	spid4	Input Buf: Language Event: INSERT INTO SalesTransaction (FKGolfCourseID,UniqueS
2008-07-23 13:17:05.04 	spid4	SPID: 58 ECID: 0 Statement Type: UPDATE Line #: 7
2008-07-23 13:17:05.04 	spid4	Owner:0x1c4d1180 Mode: U        Flg:0x0 Ref:0 Life:00000001 SPID:58 ECID:0
2008-07-23 13:17:05.04 	spid4	Grant List 1::
2008-07-23 13:17:05.04 	spid4	KEY: 8:940582439:27 (080069c32651) CleanCnt:2 Mode: U Flags: 0x0
2008-07-23 13:17:05.04 	spid4	Node:2
2008-07-23 13:17:05.04 	spid4	
2008-07-23 13:17:05.04 	spid4	ResType:LockOwner Stype:'OR' Mode: U SPID:58 ECID:0 Ec:(0x1B021528) Value:0x1b0
2008-07-23 13:17:05.04 	spid4	Requested By: 
2008-07-23 13:17:05.04 	spid4	Input Buf: Language Event: INSERT INTO SalesTransaction (FKGolfCourseID,UniqueS
2008-07-23 13:17:05.04 	spid4	SPID: 115 ECID: 0 Statement Type: UPDATE Line #: 7
2008-07-23 13:17:05.04 	spid4	Owner:0x74d82360 Mode: X        Flg:0x0 Ref:0 Life:02000000 SPID:115 ECID:0
2008-07-23 13:17:05.04 	spid4	Grant List 0::
2008-07-23 13:17:05.04 	spid4	KEY: 8:940582439:27 (08000dcdc619) CleanCnt:2 Mode: X Flags: 0x0
2008-07-23 13:17:05.04 	spid4	Node:1
2008-07-23 13:17:05.04 	spid4	
2008-07-23 13:17:05.04 	spid4	Wait-for graph
2008-07-23 13:17:05.04 	spid4	
2008-07-23 13:17:05.04 	spid4	...
2008-07-23 13:17:00.05 	spid4	ResType:LockOwner Stype:'OR' Mode: U SPID:62 ECID:0 Ec:(0x5CF73528) Value:0x74b
2008-07-23 13:17:00.05 	spid4	Victim Resource Owner:
2008-07-23 13:17:00.05 	spid4	ResType:LockOwner Stype:'OR' Mode: U SPID:62 ECID:0 Ec:(0x5CF73528) Value:0x74b
2008-07-23 13:17:00.05 	spid4	Requested By: 
2008-07-23 13:17:00.05 	spid4	Input Buf: Language Event: INSERT INTO SalesTransaction (FKGolfCourseID,UniqueS
2008-07-23 13:17:00.05 	spid4	SPID: 58 ECID: 0 Statement Type: UPDATE Line #: 7
2008-07-23 13:17:00.05 	spid4	Owner:0x1be0cae0 Mode: X        Flg:0x0 Ref:0 Life:02000000 SPID:58 ECID:0
2008-07-23 13:17:00.05 	spid4	Grant List 1::
2008-07-23 13:17:00.05 	spid4	KEY: 8:940582439:27 (080014c40313) CleanCnt:2 Mode: X Flags: 0x0
2008-07-23 13:17:00.05 	spid4	Node:2
2008-07-23 13:17:00.05 	spid4	
2008-07-23 13:17:00.05 	spid4	ResType:LockOwner Stype:'OR' Mode: U SPID:58 ECID:0 Ec:(0x1B021528) Value:0x1c4
2008-07-23 13:17:00.05 	spid4	Requested By: 
2008-07-23 13:17:00.05 	spid4	Input Buf: Language Event: INSERT INTO SalesTransaction (FKGolfCourseID,UniqueS
2008-07-23 13:17:00.05 	spid4	SPID: 62 ECID: 0 Statement Type: UPDATE Line #: 7
2008-07-23 13:17:00.05 	spid4	Owner:0x74177be0 Mode: X        Flg:0x0 Ref:0 Life:02000001 SPID:62 ECID:0
2008-07-23 13:17:00.05 	spid4	Grant List 0::
2008-07-23 13:17:00.05 	spid4	KEY: 8:940582439:27 (080069c32651) CleanCnt:2 Mode: X Flags: 0x0
2008-07-23 13:17:00.05 	spid4	Node:1
2008-07-23 13:17:00.05 	spid4	
2008-07-23 13:17:00.05 	spid4	Wait-for graph
2008-07-23 13:17:00.05 	spid4	
2008-07-23 13:17:00.05 	spid4	...
 
Keywords: Sql Server Deadlock
Title
1 deadlocks
2 why is this a deadlock?
3 deadlock in SQL Server 2000
4 deadlocks
5 SQL Server 2000 Deadlock
6 Deadlock Victim
 
Loading Advertisement...
 
[+][-]07.23.2008 at 11:21AM PDT, ID: 22072234

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 11:22AM PDT, ID: 22072253

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.23.2008 at 11:24AM PDT, ID: 22072272

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]07.25.2008 at 10:32AM PDT, ID: 22090637

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]07.25.2008 at 10:34AM PDT, ID: 22090654

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628