SQLServer Deadlock. Need help - 未名空间MITBBS历史存档

国际科技财经博客移民网络热点娱乐民生时事公众号

Redian新闻

>未名空间

>Database - 数据库

SQLServer Deadlock. Need help

SQLServer Deadlock. Need help# Database - 数据库

f*e2008-01-15 08:01

1 楼

Server: SQLServer 2000
Deadlock Log:
Deadlock encountered .... Printing deadlock information
2008-01-14 12:28:35.90 spid2
2008-01-14 12:28:35.90 spid2 Wait-for graph
2008-01-14 12:28:35.90 spid2
2008-01-14 12:28:35.90 spid2 Node:1
2008-01-14 12:28:35.90 spid2 KEY: 5:743673697:5 (9c04f775c7cf) CleanCnt:
1 Mode: X Flags: 0x0
2008-01-14 12:28:35.90 spid2 Grant List 0::
2008-01-14 12:28:35.90 spid2 Owner:0x474ebaa0 Mode: X Flg:0x0
Ref:0 Life:02000000 SPID:62 EC

w*e2008-01-15 08:01

2 楼

Key -- 5:743673697:5是指database_id = 5, object_id = 743673697,
and nonclustered index = 5
建议你用: set transaction isolation level read uncommitted
or 用table hint.