Skip to main content
J
jim16
Participant
April 7, 2006
Question

Deadlock MX7 Problems

  • April 7, 2006
  • 2 replies
  • 445 views
We are running MX7 on microsoft windows server 2000 and using ms SQL, the user section has not writes to the database, only reads. We have run into a problem with SQL deadlocks. This is the error we get in the runtime logs:
deadlocked on lock resources with another process and has been chosen as the deadlock victim. Rerun the transaction.
01/26 16:34:46 Information [jrpp-1234] - client variable JDBC STORE - retry 1

We tried changing some of the client variable purges but still run into the same problem. Has anyone else had this problem or know how to sove it?

Thanks
This topic has been closed for replies.

2 replies

A
Anonymous
August 1, 2006
Other than correcting your code (what you should anyway), you should modify your SQL Select statement to have NOLOCK option. This will prevent "deadlock victim" situation.

Cheers, Marin
A
Anonymous
July 31, 2006
I haven't had this problem, but if you have a deadlock, there must be a problem in your code. One thread is waiting for a lock held by another thread; and the other thread is waiting for a lock held by the first thread. (You can also get a deadlock with more than two threads involved.)

Check your code carefully.
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices