Page 1 of 1
Transaction ERROR
Posted: Mon Sep 08, 2008 1:49 am
by AlexG
I've received thas error in View Error Log :
Transaction (Process ID 63) was deadlocked on {lock} resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
Please explain me what is that and how to fix it?
Re: Transaction ERROR
Posted: Mon Sep 08, 2008 2:08 am
by mazhar
Most probably it will be the case of two queries running simultaneously that are trying to update the same record - and re-running one of them will solve the issue. What is occurrence frequency of this error?
Re: Transaction ERROR
Posted: Mon Sep 08, 2008 2:23 am
by AlexG
mazhar wrote:Most probably it will be the case of two queries running simultaneously that are trying to update the same record - and re-running one of them will solve the issue. What is occurrence frequency of this error?
It's first time! But how to re-running it?
Re: Transaction ERROR
Posted: Mon Sep 08, 2008 2:47 am
by mazhar
i am unable to pin point its source. It could be something happened at server end. Try to reproduce it and figure out operation that cause it.
Re: Transaction ERROR
Posted: Tue Sep 09, 2008 2:02 am
by mazhar
Here is another thread discussing the same problem
viewtopic.php?f=42&t=7862