Donate SIGN UP

Deadlock victims

Avatar Image
Jugglering | 22:14 Sun 26th Oct 2008 | Technology
2 Answers
I have just noticed this whilst wandering around the sillybank:-

"Microsoft OLE DB Provider for SQL Server error '80004005'
Transaction (Process ID 87) was deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
/Toolkit/answ.asp, line 1514"

Now, not being a computer programmer, I have no idea what it all means, does anyone else know ?
Gravatar

Answers

1 to 2 of 2rss feed

Best Answer

No best answer has yet been selected by Jugglering. Once a best answer has been selected, it will be shown here.

For more on marking an answer as the "Best Answer", please visit our FAQ.
two separate processes are trying to lock the same item or resource at the same time for their own exclusive use and neither is gonna back down.

it's normally an indexing problem in the database so any queries thrown at it are being seriously delayed by following redundant links in the index.

Personally though I know Bu@@er all about MS SQL (My database experience is filemaker pro).so have no idea how they'd solve it :)
It means that two people did exactly the same thing at exactly the same time and you have been chosen (randomly) as the victim. Just do whatever you were doing again, it should be fine.

1 to 2 of 2rss feed

Do you know the answer?

Deadlock victims

Answer Question >>

Related Questions

Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.