Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CSK
Constraint Violating Yak Guru
489 Posts |
 Posted - 2006-05-30 : 01:14:06
|
| Dear all,Here I am Using spid for temporary tables.i got deadlock while using more than one user.!Here I am reducing Isolation level also Set transaction isolation level read committed If Exists ( Select 'x' from bgt_afe_tmp (nolock) WHERE spid = @@SPID) Begin DELETE bgt_afe_tmp WHERE spid = @@SPID End Set transaction isolation level read uncommittedPlease help me do avoid this deadlockthe Deadlock Details isDeadlock encountered .... Printing deadlock information2006-05-30 10:25:25.38 spid4 2006-05-30 10:25:25.38 spid4 Wait-for graph2006-05-30 10:25:25.38 spid4 2006-05-30 10:25:25.38 spid4 Node:12006-05-30 10:25:25.38 spid4 RID: 9:1:296763:0 CleanCnt:2 Mode: X Flags: 0x22006-05-30 10:25:25.38 spid4 Grant List 1::2006-05-30 10:25:25.38 spid4 Owner:0x19f7f3a0 Mode: X Flg:0x0 Ref:0 Life:02000001 SPID:54 ECID:02006-05-30 10:25:25.38 spid4 SPID: 54 ECID: 0 Statement Type: DELETE Line #: 5422006-05-30 10:25:25.38 spid4 Input Buf: Language Event: Begin TranEXEC common..bgt_bes_coa_afe_cc_rtr 'UNRWACON' , NULL , 'BGT' , 'BES' , '0-4010' , '0CG02' , 'GF' , NULL , NULL , NULL , NULL , 'A' , NULL , 'BIE2006-07'ThanksKK |
|
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2006-05-30 : 09:56:31
|
| Is you application issuing a BEGIN TRAN or is it in your stored procedure? I don't see a COMMIT or ROLLBACK,is that because the of the deadlock or are you missing that (very necessary) piece of code? Post the entire SP code.Be One with the OptimizerTG |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-05-30 : 10:00:54
|
| http://sql-server-performance.com/deadlocks.aspMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
|
|
Deadlock