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.
0
votes
1answer
132 views
How do you avoid a deadlock on the primary key of a table? [closed]
So I have a deadlock that looks like this. Both sides of the deadlock complain about the the primary key clustered index.
<deadlock-list>
<deadlock victim="processec49b8">
...
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 ...
0
votes
1answer
353 views
SQL Server 2008, database completely locked
Our database becomes completely locked, and it seems that many tables not related to each other are locked at once. When this happens, it becomes locked for approximately 2 minutes, and when this ...
0
votes
1answer
89 views
how to avoid deadlock while updating 2 rows in mysql [duplicate]
This is a interview problem.
There is a perl program that updates the database, and it could run in different processes.
One process may execute a transaction like: update row A -> update row B -> ...
-3
votes
2answers
602 views
SQL Server - How many type of timeout can happen, and how?
When working with SQL Server, there can be multiple application host accessing it, and each application can have one or many connection. Each connection can potentially have multiple transaction ...
