Deadlock found when trying to get a lock

Asked By Ronald R Eagle 10 points N/A Posted on - 10/31/2013

Hi,

I am getting the following error message when I try to do a batch insert of about 700 floats. I just get this annoying problem when try to restart the transaction. How can I fix this issue? Have any idea to resolve the following matter? I would be grateful to you. Thanks in advance.

RightNow CX-fout

Deadlock found when trying to get lock; try restarting transaction

• Status: Open
• Question Views: 1057
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: Software Others

Answered By Jackson Wilson 0 points N/A #175858

Deadlock found when trying to get a lock

Hi,

This situation occurs when two transaction hold on each other to again lock. So, concurrent transactions never try to update a row which creates deadlock.

T1: lock x, then y

T 2: lock y, then x

To avoid the deadlock, change the queries such that transactions would lock at same order.

T 1: locks key x, locks key y;

T 2: locks key x, locks key y;

There can also be problem of missing indexes. Always make sure to have indexes on foreign or primary keys. If not done this way, this could result in table lock instead of row lock.

About Jackson Wilson

Questions
0

Answers
100

Best Answers
17

• Vote Up 0 Vote Down

• Posted on - 11/02/2013
• Question Category: Software Others