Transaction (Process ID) was deadlocked on lock resources with another process and has been chose
来源:互联网 发布:php 中文变量名 编辑:程序博客网 时间:2024/05/17 19:14
最近在做多线程处理sql server2008某个表中的数据时,在Update记录的时候出现了【Transaction (Process ID 146) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction】显示的错误,百思不得其解,还以为是程序中应用了lock的原因导致死锁呢,后来发现不是这么回事,是我处理的表没有设置主键,而更新时是根据主键进行更新的。
又仔细一想,是因为我更新的这个表是通过sql server2008自带的导入表的功能倒过来了,原来的表是有主键的,但是通过导入方式过来的新表确实没有主键的,这个问题不太清楚,如果提前知道,设置好主键就不会出现这样的问题了。
- Transaction (Process ID) was deadlocked on lock resources with another process and has been chose
- Transaction (Process ID ) was deadlocked on lock resources with another process and has been chosen
- Process Resources
- Process ID and special processes
- get android process id and thread id
- All About Process On Value and Process On Help
- All About Process On Value and Process On Help
- Web site worker process has been terminated by IIS
- process on
- Agile Development with ICONIX Process: People, Process, and Pragmatism
- How to launch another process in sandbox on Mac
- WebLogic Server (WLS) Hangs With Deadlocked Socket Close() and Poll() Threads on AIX 【转】
- Business Process Modeling and Simulation with UML
- There was a problem with reindexing process 解决方法
- was active for 79985 milliseconds and has been removed automaticaly.
- 解决VTune错误PMU resources currently being used by another profiling tool or process
- zombie process and orphan process
- zombie process and orphan process
- 在64位服务器上安装oracle 32位客户端只能被编译为x86的程序连接
- 1087(Super jumpinng ,jumping ,jumping)
- 一个计算机爱好者的不完整回忆(二十二)完美软件
- 异常火爆的趣味编程网站Codecademy获1000万美元融资,网站的中文版已上线
- ArcGIS Desktop 10 系统要求
- Transaction (Process ID) was deadlocked on lock resources with another process and has been chose
- android JNI企业级简单实现步骤
- Linq To Sql常用方法使用总结
- UML
- 在linux中用C语言实现ping命令的部分功能
- 全国各省市区域经纬度表
- Android: R cannot be resolved to a variable
- AutoCAD二次开发之.net API学习笔记(2)
- android JNI简单的java调C