Top "Database-deadlocks" questions

In databases, when multiple processes alter the same table or row, each can lock a table or row.

Working around MySQL error "Deadlock found when trying to get lock; try restarting transaction"

I have a MySQL table with about 5,000,000 rows that are being constantly updated in small ways by parallel Perl processes …

mysql deadlock database-deadlocks
How to kill/Terminate all running process on Sql Server 2008

After executing this query on master db ,it is giving me all running process on all databases, is there any …

sql-server-2008 database-deadlocks
What is the difference between "wait-die" and "wound-wait" deadlock prevention algorithms?

What is the difference between wait-die and wound-wait algorithms? It seems that both of these deadlock prevention techniques are doing …

database deadlock database-deadlocks
What is a deadlock in a database?

What is a deadlock in SQL Server and when it arises? What are the issues with deadlock and how to …

database sql-server-2005 deadlock database-deadlocks
Query is locking tables, can't kill that process

I have a query locking tables in MySQL (using InnoDB): UPDATE table SET status = 2 WHERE status = 3 This query caused a …

mysql deadlock database-deadlocks kill-process
SqlException: Deadlock

I have these two exceptions generated when I try to get data from SQL database in C#: System.Data.SqlClient.…

c# sql deadlock database-deadlocks
Implementing retry logic for deadlock exceptions

I've implemented a generic repository and was wondering if there is a smart way to implement a retry logic in …

c# entity-framework try-catch repository-pattern database-deadlocks
What does "lock | communication buffer resources" mean?

I have an error log which reports a deadlock: Transaction (Process ID 55) was deadlocked on lock | communication buffer resources with …

sql-server sql-server-2008 deadlock database-deadlocks
C3p0 APPARENT DEADLOCK exception

I keep getting this exception in my Tomcat log: com.mchange.v2.async.ThreadPoolAsynchronousRunner$DeadlockDetector run WARNING: com.mchange.v2.…

mysql hibernate c3p0 database-deadlocks
How is Hibernate deciding order of update/insert/delete

Let's first forget about Hibernate. Assume that I have two tables, A & B. Two transactions are updating same records …

hibernate deadlock database-deadlocks