-
Not specified
Does any body has any ideas what the trace flag (3605). We try to test the deadlock in SQL Server 7 but we do not see the error file. The following trace flags was turn on. No error was return but we got the deadlock message. If you have encounter this problem and have solution for it, please share with me. Thank you
Please cc directly to me also:
lamnguyen@platsoft.com
This is the simulate the problem:
dbcc tracestatus(-1)
TraceFlag Status
----------- -----------
1204 1
1205 1
1208 1
1704 1
3604 1
3605 1
first process:
begin tran
update mytitle
set title_id = `abcd`
where title_id = `bu1111`
waitfor delay `00:00:20`
update mytitle
set title_id = `abcd`
where title_id = `bu1032`
commit tran
go
Error return but we cannot see in the server trace flag (3605)
Server: Msg 1205, Level 13, State 17
Your transaction (process ID #20) was deadlocked with another process and has been chosen as the deadlock victim. Rerun your transaction.
Second processes:
begin tran
update mytitle
set title_id = `abcd`
where title_id = `bu1032`
waitfor delay `00:00:20`
update mytitle
set title_id = `abcd`
where title_id = `bu1111`
commit tran
go
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|