# MySQL ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction

**Code:** `1213` · **Category:** MySQL · **Seen on:** MySQL

MySQL detected a deadlock between two transactions and rolled one back.

## Meaning

The SQL-level page explains deadlocks generally; for MySQL, SHOW ENGINE INNODB STATUS shows the latest deadlock with both statements.

## Common causes

- Rows locked in different orders
- Missing indexes causing gap locks
- Long transactions

## Quick fix

1. Retry the transaction
2. Access rows in a consistent order
3. Add indexes

## Detailed fix by platform

### MySQL

1. `SHOW ENGINE INNODB STATUS\G`

## How to diagnose

1. **Statements** — Which two?
2. **Recent change** — Did it start after a deploy, upgrade, or configuration change? Compare with the last working version.

---
Source: [WhatIsMyError](https://whatismyerror.com/errors/mysql/1213-deadlock-found-mysql)