By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,378 Members | 1,286 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,378 IT Pros & Developers. It's quick & easy.

Deadlock problem

P: 1
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:0x0B4775E0 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.entities.GNTUserSetti ngs */ 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:LockOwner Stype:'OR'Xdes:0x2B672960 Mode: IX SPID:80 BatchID:0 ECID:0 TaskProxy:(0x358E0374) 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:0x0A8F1A40 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.entities.GNTUserSetti ngs */ 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:LockOwner Stype:'OR'Xdes:0x43101078 Mode: IX SPID:89 BatchID:0 ECID:0 TaskProxy:(0x5C124374) 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:LockOwner Stype:'OR'Xdes:0x43101078 Mode: IX SPID:89 BatchID:0 ECID:0 TaskProxy:(0x5C124374) 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=process5e92e8
2008-03-31 04:32:06.43 spid16s process-list
2008-03-31 04:32:06.43 spid16s process id=process5e92e8 taskpriority=0 logused=0 waitresource=OBJECT: 10:357576312:0 waittime=4250 ownerId=4898803 transactionname=implicit_transaction lasttranstarted=2008-03-31T04:32:01.917 XDES=0x43101078 lockMode=IX schedulerid=1 kpid=12524 status=suspended spid=89 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2008-03-31T04:32:02.167 lastbatchcompleted=2008-03-31T04:32:02.150 clientapp=jTDS hostname=SERVER01 hostpid=123 loginname=gntusr isolationlevel=read committed (2) xactid=4898803 currentdb=10 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128058
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=0x020000009d1f1e09272e09efbab895c46f1e28 1bc77d4164
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.entities.GNTUserSetti ngs */ update GNTUserSettings set name= @P0 , scriptText= @P1 , gntUser= @P2 where id= @P3
2008-03-31 04:32:06.43 spid16s process id=process5e94c8 taskpriority=0 logused=0 waitresource=OBJECT: 10:357576312:0 waittime=4328 ownerId=4898766 transactionname=implicit_transaction lasttranstarted=2008-03-31T04:32:01.730 XDES=0x2b672960 lockMode=IX schedulerid=1 kpid=4284 status=suspended spid=80 sbid=0 ecid=0 priority=0 transcount=2 lastbatchstarted=2008-03-31T04:32:02.087 lastbatchcompleted=2008-03-31T04:32:02.057 clientapp=jTDS hostname=SERVER01 hostpid=123 loginname=gntusr isolationlevel=read committed (2) xactid=4898766 currentdb=10 lockTimeout=4294967295 clientoption1=671088672 clientoption2=128058
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=0x020000009d1f1e09272e09efbab895c46f1e28 1bc77d4164
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.entities.GNTUserSetti ngs */ 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=FULL dbid=10 objectname=gntdb.dbo.GNTUserSettings id=lock426dec0 mode=S associatedObjectId=357576312
2008-03-31 04:32:06.43 spid16s owner-list
2008-03-31 04:32:06.43 spid16s owner id=process5e92e8 mode=S
2008-03-31 04:32:06.43 spid16s owner id=process5e94c8 mode=S
2008-03-31 04:32:06.43 spid16s waiter-list
2008-03-31 04:32:06.43 spid16s waiter id=process5e94c8 mode=IX requestType=convert
2008-03-31 04:32:06.43 spid16s waiter id=process5e92e8 mode=IX requestType=convert
Mar 31 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

Sign in to post your reply or Sign up for a free account.