Transaction ERROR

AlexG · Post by **AlexG** » Mon Sep 08, 2008 1:49 am

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?

Post by **mazhar** » Mon Sep 08, 2008 2:08 am

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?

AlexG · Post by **AlexG** » Mon Sep 08, 2008 2:23 am

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?

Post by **mazhar** » Mon Sep 08, 2008 2:47 am

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.

Post by **mazhar** » Tue Sep 09, 2008 2:02 am

Here is another thread discussing the same problem
viewtopic.php?f=42&t=7862

AbleCommerce Shopping Cart Software

Transaction ERROR

Transaction ERROR

Re: Transaction ERROR

Re: Transaction ERROR

Re: Transaction ERROR

Re: Transaction ERROR