Top "Database-deadlocks" questions

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

SQL server update statements cause deadlocks

I have an application which is running multiple sql statements simultaneously in different threads, causing various deadlocks which all seem …

sql-server-2005 sql-update database-deadlocks
mysql CREATE temporary table + Transaction causes deadlock

I have the complex query that creates a temporary table that can take 5 seconds to run or more. This seems …

php mysql transactions database-deadlocks
Database Deadlock in SELECT FOR UPDATE

I'm getting deadlock intermittently in my application. My application has 1 table e.g EMPLOYEE (ID (PK), NAME, SAL) and there …

sql sql-update database-deadlocks
How to simulate deadlock in PostgreSQL?

I am new for PostgreSQL. I want to simulate deadlock for this schedule: How to simulate deadlock in PostgreSQL? Is …

postgresql concurrency deadlock database-deadlocks
Deadlock involving foreign key constraint

I would like to understand better a mechanism of locking in postgres. Let's say that tree can have apples (via …

postgresql deadlock database-deadlocks
Retry on deadlock for MySQL / SQLAlchemy

I have searched for quite some time now and can't found a solution to my problem. We are using SQLAlchemy …

python mysql sqlalchemy database-deadlocks
Avoiding PostgreSQL deadlocks when performing bulk update and delete operations

We have a single table which does not have references to any other tables. ┬────────────┬─────────────┬───────────────┬───────────────╮ │id_A(bigint)│id_B(bigint) │…

database postgresql concurrency deadlock database-deadlocks