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 |
|
mprolli
Starting Member
24 Posts |
 Posted - 2004-12-21 : 16:03:40
|
| Has anyone ever received this message before? One of my users got it when they cancelled an operation from a third party reporting tool.ODBC SQL Server Driver][SQL Server]Transaction (Process ID 120) was deadlocked on {thread | communication buffer} resources with another process and has been chosen as the deadlock victim. Rerun the transaction.Let us rise up and be thankful, for if we didn't learn a lot today, at least we learned a little, and if we didn't learn a little, at least we didn't get sick, and if we got sick, at least we didn't die; so, let us all be thankful. --Buddha |
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2004-12-21 : 16:18:34
|
| This occurs when there is a contention for a resource within the database. Two users have mutually locked each other out from gaining access to the resource. This condition is called a deadlock. When this occurs, the SQL Server will detect it and pick one of the contenders as the victim. The victim is denied access and is made to release any resources that were locked. The error is returned to the victim.To recover from this condition, do exactly as directed - "Rerun the transaction."To prevent or at least minimize the likelihood of this occuring there are some things that can be attempted at the programming level. See BOL for details under "Deadlocks".HTH=================================================================Sometimes I wonder whether the world is being run by smart people who are putting us on or by imbeciles who really mean it. -Mark Twain, author and humorist (1835-1910) |
 |
|
|
mprolli
Starting Member
24 Posts |
Posted - 2004-12-22 : 10:19:16
|
| Thanks Bustaz, I figured that is was something like that, but when I looked up that error, I found info about Clustered SQL databases, and I don't have anything like that set up.. But, thanks for the Info!!!...Let us rise up and be thankful, for if we didn't learn a lot today, at least we learned a little, and if we didn't learn a little, at least we didn't get sick, and if we got sick, at least we didn't die; so, let us all be thankful. --Buddha |
|
|
|
Bustaz Kool
Master Smack Fu Yak Hacker
1834 Posts |
Posted - 2004-12-22 : 13:35:01
|
| You can get daedlock regardless of whether you have clustering configured or not. The example in BOL walks you through that.HTH=================================================================Sometimes I wonder whether the world is being run by smart people who are putting us on or by imbeciles who really mean it. -Mark Twain, author and humorist (1835-1910) |
|
|
|
|
|
|
|
|
Unknown Error