A situation caused by two or more processes being unable to proceed (and thus release their locks) because they are blocked by locks on resources held by the other process.
3
votes
1answer
150 views
Deadlock free MERGE-alike in MySQL?
I am trying to implement some parts of MERGE in the MySQL driver in Drupal. Of course, Drupal has something but in truth it only works because the most frequent MERGE issuer just eats exceptions.
So, ...
1
vote
1answer
60 views
dead lock when updating
Update Operation.TrTable
Set RecordId = RecordTABLE.newRecordId
From Operation.TrTable tr
Inner Join (
SELECT r.Id AS newRecordId, r.KeyM AS MappingKey
From ...
0
votes
1answer
66 views
Deadlock : Behaviour of NOLOCK
We are running into deadlocks when we run concurrent instances of following query :
BEGIN TRAN
IF NOT EXISTS (SELECT TOP 1 * FROM Table1 WITH (NOLOCK) WHERE Col1 = Val1 AND Col2 = Val2)
BEGIN
...
0
votes
1answer
116 views
How I prevent deadlock occurrence in my application?
I am developing an LMS application in PHP framework(Codeigniter 2.1.0). I am using MySQL database.
All the tables in the database have innodb engine. I also created indexes on each tables.
Now I am ...
2
votes
0answers
125 views
Can 2 tables lock each other if concurrent read/update do not affect same rows? pagelocks off
Can 2 tables cause a deadlock, if the pagelocks are off, and the rows are not related.
E.g.
Query 1 runs for a few seconds
Select * from Orders where CustomerID = 1 and DateOrdered between @D1 and ...
2
votes
0answers
245 views
SQL Server 2008 R2 - Deadlock Trace, Need Help Understanding It
I really need help on understanding this deadlock, i've already replaced the values,
mind if anyone helps me interpreting where my deadlocks are coming from?
What does e_waitpipegetrow mean?
btw, i'm ...
1
vote
0answers
39 views
Concurrent Access causing deadlock on the same table
Transaction 1 : SELECT distinct column_id from grid where row_id = @P0
Transaction 2 : INSERT INTO grid (grid_id, row_id, column_id)
In this table grid grid_id is primary key clustered.
...
1
vote
0answers
107 views
Why Am I Getting Deadlock - Please Read Trace
can anyone help me?
i'm getting deadlock on this trace, i'm using symmetricds and i can't understand why i'm getting a deadlock on a certain table.
I'm using sql server 2008 r2, ...
1
vote
0answers
158 views
SQL Server 2008 R2 DeadLock on query Notification
for the first time, I'm running into a deadlock on ...The deadlock graph doesn't help me much except the fact the query notification system seems to responsible.
<resource-list>
...
0
votes
0answers
56 views
Table Constraint causing deadlock
I have a table. When two transactions are inserting a large no of rows into table grid I am getting a deadlock due to INSERT/SELECT. So INSERT query has X lock on clustered index but since i am doing ...
0
votes
0answers
45 views
Deadlocks in Small Table
Our application is seeing deadlocks while inserting records into a table shortly after installation, while the table is small. These deadlocks eventually go away as the table fills up.
The ...
0
votes
0answers
87 views
innodb deadlock on different tables
I am using mysql 5.5.28.
I would like to ask a question about the nature of deadlocks in innodb engine.
I monitor deadlock with pt-deadlock-logger.
Recently I found deadlock of two transactions to ...
