Could anyone help me understand the deadlock graph posted below? and, maybe, the reason behind the deadlock? Any help is very appreciated. Thank you.
2008-03-31 04:32:06.40 spid4s Deadlock encountered .... Printing deadlock information
2008-03-31 04:32:06.40 spid4s Wait-for graph
2008-03-31 04:32:06.40 spid4s
2008-03-31 04:32:06.40 spid4s Node:1
2008-03-31 04:32:06.41 spid4s OBJECT: 10:357576312:0 CleanCnt:4 Mode:S Flags: 0x0
2008-03-31 04:32:06.41 spid4s Grant List 0:
2008-03-31 04:32:06.41 spid4s Owner:0x0B4775E 0 Mode: S Flg:0x0 Ref:2 Life:00000000 SPID:89 ECID:0 XactLockInfo: 0x4310109C
2008-03-31 04:32:06.41 spid4s SPID: 89 ECID: 0 Statement Type: UPDATE Line #: 1
2008-03-31 04:32:06.41 spid4s Input Buf: Language Event: (@P0 nvarchar(4000), @P1 nvarchar(4000), @P2 bigint,@P3 bigint)/* update org.fefsystems. gnt.core.impl.e ntities.GNTUser Settings */ update GNTUserSettings set name= @P0 , scriptText= @P1 , gntUser= @P2 where id= @P3
2008-03-31 04:32:06.41 spid4s Grant List 1:
2008-03-31 04:32:06.41 spid4s Requested By:
2008-03-31 04:32:06.41 spid4s ResType:LockOwn er Stype:'OR'Xdes: 0x2B672960 Mode: IX SPID:80 BatchID:0 ECID:0 TaskProxy:(0x35 8E0374) Value:0x7a936c0 Cost:(0/0)
2008-03-31 04:32:06.41 spid4s
2008-03-31 04:32:06.41 spid4s Node:2
2008-03-31 04:32:06.41 spid4s OBJECT: 10:357576312:0 CleanCnt:4 Mode:S Flags: 0x0
2008-03-31 04:32:06.41 spid4s Grant List 0:
2008-03-31 04:32:06.41 spid4s Owner:0x0A8F1A4 0 Mode: S Flg:0x0 Ref:2 Life:00000000 SPID:80 ECID:0 XactLockInfo: 0x2B672984
2008-03-31 04:32:06.41 spid4s SPID: 80 ECID: 0 Statement Type: UPDATE Line #: 1
2008-03-31 04:32:06.41 spid4s Input Buf: Language Event: (@P0 nvarchar(4000), @P1 nvarchar(4000), @P2 bigint,@P3 bigint)/* update org.fefsystems. gnt.core.impl.e ntities.GNTUser Settings */ update GNTUserSettings set name= @P0 , scriptText= @P1 , gntUser= @P2 where id= @P3
2008-03-31 04:32:06.41 spid4s Grant List 1:
2008-03-31 04:32:06.41 spid4s Requested By:
2008-03-31 04:32:06.41 spid4s ResType:LockOwn er Stype:'OR'Xdes: 0x43101078 Mode: IX SPID:89 BatchID:0 ECID:0 TaskProxy:(0x5C 124374) Value:0x88c1560 Cost:(0/0)
2008-03-31 04:32:06.41 spid4s
2008-03-31 04:32:06.41 spid4s Victim Resource Owner:
2008-03-31 04:32:06.41 spid4s ResType:LockOwn er Stype:'OR'Xdes: 0x43101078 Mode: IX SPID:89 BatchID:0 ECID:0 TaskProxy:(0x5C 124374) Value:0x88c1560 Cost:(0/0)
2008-03-31 04:32:06.43 spid16s deadlock-list
2008-03-31 04:32:06.43 spid16s deadlock victim=process5 e92e8
2008-03-31 04:32:06.43 spid16s process-list
2008-03-31 04:32:06.43 spid16s process id=process5e92e 8 taskpriority=0 logused=0 waitresource=OB JECT: 10:357576312:0 waittime=4250 ownerId=4898803 transactionname =implicit_trans action lasttranstarted =2008-03-31T04:32:01.917 XDES=0x43101078 lockMode=IX schedulerid=1 kpid=12524 status=suspende d spid=89 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarte d=2008-03-31T04:32:02.167 lastbatchcomple ted=2008-03-31T04:32:02.150 clientapp=jTDS hostname=SERVER 01 hostpid=123 loginname=gntus r isolationlevel= read committed (2) xactid=4898803 currentdb=10 lockTimeout=429 4967295 clientoption1=6 71088672 clientoption2=1 28058
2008-03-31 04:32:06.43 spid16s executionStack
2008-03-31 04:32:06.43 spid16s frame procname=adhoc line=1 stmtstart=256 sqlhandle=0x020 000009d1f1e0927 2e09efbab895c46 f1e281bc77d4164
2008-03-31 04:32:06.43 spid16s update GNTUserSettings set name= @P0 , scriptText= @P1 , gntUser= @P2 where id= @P3
2008-03-31 04:32:06.43 spid16s inputbuf
2008-03-31 04:32:06.43 spid16s (@P0 nvarchar(4000), @P1 nvarchar(4000), @P2 bigint,@P3 bigint)/* update org.fefsystems. gnt.core.impl.e ntities.GNTUser Settings */ update GNTUserSettings set name= @P0 , scriptText= @P1 , gntUser= @P2 where id= @P3
2008-03-31 04:32:06.43 spid16s process id=process5e94c 8 taskpriority=0 logused=0 waitresource=OB JECT: 10:357576312:0 waittime=4328 ownerId=4898766 transactionname =implicit_trans action lasttranstarted =2008-03-31T04:32:01.730 XDES=0x2b672960 lockMode=IX schedulerid=1 kpid=4284 status=suspende d spid=80 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarte d=2008-03-31T04:32:02.087 lastbatchcomple ted=2008-03-31T04:32:02.057 clientapp=jTDS hostname=SERVER 01 hostpid=123 loginname=gntus r isolationlevel= read committed (2) xactid=4898766 currentdb=10 lockTimeout=429 4967295 clientoption1=6 71088672 clientoption2=1 28058
2008-03-31 04:32:06.43 spid16s executionStack
2008-03-31 04:32:06.43 spid16s frame procname=adhoc line=1 stmtstart=256 sqlhandle=0x020 000009d1f1e0927 2e09efbab895c46 f1e281bc77d4164
2008-03-31 04:32:06.43 spid16s update GNTUserSettings set name= @P0 , scriptText= @P1 , gntUser= @P2 where id= @P3
2008-03-31 04:32:06.43 spid16s inputbuf
2008-03-31 04:32:06.43 spid16s (@P0 nvarchar(4000), @P1 nvarchar(4000), @P2 bigint,@P3 bigint)/* update org.fefsystems. gnt.core.impl.e ntities.GNTUser Settings */ update GNTUserSettings set name= @P0 , scriptText= @P1 , gntUser= @P2 where id= @P3
2008-03-31 04:32:06.43 spid16s resource-list
2008-03-31 04:32:06.43 spid16s objectlock lockPartition=0 objid=357576312 subresource=FUL L dbid=10 objectname=gntd b.dbo.GNTUserSe ttings id=lock426dec0 mode=S associatedObjec tId=357576312
2008-03-31 04:32:06.43 spid16s owner-list
2008-03-31 04:32:06.43 spid16s owner id=process5e92e 8 mode=S
2008-03-31 04:32:06.43 spid16s owner id=process5e94c 8 mode=S
2008-03-31 04:32:06.43 spid16s waiter-list
2008-03-31 04:32:06.43 spid16s waiter id=process5e94c 8 mode=IX requestType=con vert
2008-03-31 04:32:06.43 spid16s waiter id=process5e92e 8 mode=IX requestType=con vert
2008-03-31 04:32:06.40 spid4s Deadlock encountered .... Printing deadlock information
2008-03-31 04:32:06.40 spid4s Wait-for graph
2008-03-31 04:32:06.40 spid4s
2008-03-31 04:32:06.40 spid4s Node:1
2008-03-31 04:32:06.41 spid4s OBJECT: 10:357576312:0 CleanCnt:4 Mode:S Flags: 0x0
2008-03-31 04:32:06.41 spid4s Grant List 0:
2008-03-31 04:32:06.41 spid4s Owner:0x0B4775E 0 Mode: S Flg:0x0 Ref:2 Life:00000000 SPID:89 ECID:0 XactLockInfo: 0x4310109C
2008-03-31 04:32:06.41 spid4s SPID: 89 ECID: 0 Statement Type: UPDATE Line #: 1
2008-03-31 04:32:06.41 spid4s Input Buf: Language Event: (@P0 nvarchar(4000), @P1 nvarchar(4000), @P2 bigint,@P3 bigint)/* update org.fefsystems. gnt.core.impl.e ntities.GNTUser Settings */ update GNTUserSettings set name= @P0 , scriptText= @P1 , gntUser= @P2 where id= @P3
2008-03-31 04:32:06.41 spid4s Grant List 1:
2008-03-31 04:32:06.41 spid4s Requested By:
2008-03-31 04:32:06.41 spid4s ResType:LockOwn er Stype:'OR'Xdes: 0x2B672960 Mode: IX SPID:80 BatchID:0 ECID:0 TaskProxy:(0x35 8E0374) Value:0x7a936c0 Cost:(0/0)
2008-03-31 04:32:06.41 spid4s
2008-03-31 04:32:06.41 spid4s Node:2
2008-03-31 04:32:06.41 spid4s OBJECT: 10:357576312:0 CleanCnt:4 Mode:S Flags: 0x0
2008-03-31 04:32:06.41 spid4s Grant List 0:
2008-03-31 04:32:06.41 spid4s Owner:0x0A8F1A4 0 Mode: S Flg:0x0 Ref:2 Life:00000000 SPID:80 ECID:0 XactLockInfo: 0x2B672984
2008-03-31 04:32:06.41 spid4s SPID: 80 ECID: 0 Statement Type: UPDATE Line #: 1
2008-03-31 04:32:06.41 spid4s Input Buf: Language Event: (@P0 nvarchar(4000), @P1 nvarchar(4000), @P2 bigint,@P3 bigint)/* update org.fefsystems. gnt.core.impl.e ntities.GNTUser Settings */ update GNTUserSettings set name= @P0 , scriptText= @P1 , gntUser= @P2 where id= @P3
2008-03-31 04:32:06.41 spid4s Grant List 1:
2008-03-31 04:32:06.41 spid4s Requested By:
2008-03-31 04:32:06.41 spid4s ResType:LockOwn er Stype:'OR'Xdes: 0x43101078 Mode: IX SPID:89 BatchID:0 ECID:0 TaskProxy:(0x5C 124374) Value:0x88c1560 Cost:(0/0)
2008-03-31 04:32:06.41 spid4s
2008-03-31 04:32:06.41 spid4s Victim Resource Owner:
2008-03-31 04:32:06.41 spid4s ResType:LockOwn er Stype:'OR'Xdes: 0x43101078 Mode: IX SPID:89 BatchID:0 ECID:0 TaskProxy:(0x5C 124374) Value:0x88c1560 Cost:(0/0)
2008-03-31 04:32:06.43 spid16s deadlock-list
2008-03-31 04:32:06.43 spid16s deadlock victim=process5 e92e8
2008-03-31 04:32:06.43 spid16s process-list
2008-03-31 04:32:06.43 spid16s process id=process5e92e 8 taskpriority=0 logused=0 waitresource=OB JECT: 10:357576312:0 waittime=4250 ownerId=4898803 transactionname =implicit_trans action lasttranstarted =2008-03-31T04:32:01.917 XDES=0x43101078 lockMode=IX schedulerid=1 kpid=12524 status=suspende d spid=89 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarte d=2008-03-31T04:32:02.167 lastbatchcomple ted=2008-03-31T04:32:02.150 clientapp=jTDS hostname=SERVER 01 hostpid=123 loginname=gntus r isolationlevel= read committed (2) xactid=4898803 currentdb=10 lockTimeout=429 4967295 clientoption1=6 71088672 clientoption2=1 28058
2008-03-31 04:32:06.43 spid16s executionStack
2008-03-31 04:32:06.43 spid16s frame procname=adhoc line=1 stmtstart=256 sqlhandle=0x020 000009d1f1e0927 2e09efbab895c46 f1e281bc77d4164
2008-03-31 04:32:06.43 spid16s update GNTUserSettings set name= @P0 , scriptText= @P1 , gntUser= @P2 where id= @P3
2008-03-31 04:32:06.43 spid16s inputbuf
2008-03-31 04:32:06.43 spid16s (@P0 nvarchar(4000), @P1 nvarchar(4000), @P2 bigint,@P3 bigint)/* update org.fefsystems. gnt.core.impl.e ntities.GNTUser Settings */ update GNTUserSettings set name= @P0 , scriptText= @P1 , gntUser= @P2 where id= @P3
2008-03-31 04:32:06.43 spid16s process id=process5e94c 8 taskpriority=0 logused=0 waitresource=OB JECT: 10:357576312:0 waittime=4328 ownerId=4898766 transactionname =implicit_trans action lasttranstarted =2008-03-31T04:32:01.730 XDES=0x2b672960 lockMode=IX schedulerid=1 kpid=4284 status=suspende d spid=80 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarte d=2008-03-31T04:32:02.087 lastbatchcomple ted=2008-03-31T04:32:02.057 clientapp=jTDS hostname=SERVER 01 hostpid=123 loginname=gntus r isolationlevel= read committed (2) xactid=4898766 currentdb=10 lockTimeout=429 4967295 clientoption1=6 71088672 clientoption2=1 28058
2008-03-31 04:32:06.43 spid16s executionStack
2008-03-31 04:32:06.43 spid16s frame procname=adhoc line=1 stmtstart=256 sqlhandle=0x020 000009d1f1e0927 2e09efbab895c46 f1e281bc77d4164
2008-03-31 04:32:06.43 spid16s update GNTUserSettings set name= @P0 , scriptText= @P1 , gntUser= @P2 where id= @P3
2008-03-31 04:32:06.43 spid16s inputbuf
2008-03-31 04:32:06.43 spid16s (@P0 nvarchar(4000), @P1 nvarchar(4000), @P2 bigint,@P3 bigint)/* update org.fefsystems. gnt.core.impl.e ntities.GNTUser Settings */ update GNTUserSettings set name= @P0 , scriptText= @P1 , gntUser= @P2 where id= @P3
2008-03-31 04:32:06.43 spid16s resource-list
2008-03-31 04:32:06.43 spid16s objectlock lockPartition=0 objid=357576312 subresource=FUL L dbid=10 objectname=gntd b.dbo.GNTUserSe ttings id=lock426dec0 mode=S associatedObjec tId=357576312
2008-03-31 04:32:06.43 spid16s owner-list
2008-03-31 04:32:06.43 spid16s owner id=process5e92e 8 mode=S
2008-03-31 04:32:06.43 spid16s owner id=process5e94c 8 mode=S
2008-03-31 04:32:06.43 spid16s waiter-list
2008-03-31 04:32:06.43 spid16s waiter id=process5e94c 8 mode=IX requestType=con vert
2008-03-31 04:32:06.43 spid16s waiter id=process5e92e 8 mode=IX requestType=con vert