Error map

Deadlock Deadlock found when trying to get lock; try restarting transaction

SQL · layer 5, Data

Open the full error page →

Centre: this error. First ring: errors it is linked with (9). Outer ring: what those are linked with. Colours show the layer of a request each error belongs to. Click any dot to re-centre the map on it; hover to follow its connections. The centre dot opens the error page.

Deadlock — Deadlock found when trying to get lock; try restarting transaction (SQL)Deadlock1062 — MySQL ERROR 1062 (23000): Duplicate entry for key (MySQL)1062ORA-00054 — ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired (SQL)ORA-000542006 — MySQL ERROR 2006 (HY000): MySQL server has gone away (MySQL)2006Lock wait timeout — Lock wait timeout exceeded; try restarting transaction (MySQL 1205) (SQL)Lock wait timeout25P02 — ERROR: current transaction is aborted, commands ignored until end of transaction block (PostgreSQL)25P02SQLITE_BUSY — sqlite3.OperationalError: database is locked (SQLITE_BUSY) (SQL)SQLITE_BUSYError acquiring the state lock — Terraform: Error: Error acquiring the state lock — ConditionalCheckFailedException / state blob is already locked (Terraform)Error acquiring the…1213 — MySQL ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction (MySQL)121340001 — ERROR: could not serialize access due to concurrent update (PostgreSQL)400011452 — MySQL ERROR 1452: Cannot add or update a child row: a foreign key constraint fails (MySQL)1452409 — HTTP 409 Conflict (HTTP)409Subquery returns more than 1 row — Subquery returns more than 1 row (MySQL 1242) / more than one row returned by a subquery used as an expression (SQL)Subquery returns mo…ORA-00942 — ORA-00942: table or view does not exist (SQL)ORA-00942ORA-00904 — ORA-00904: "X": invalid identifier (SQL)ORA-00904ORA-00001 — ORA-00001: unique constraint (SCHEMA.PK_X) violated (SQL)ORA-000011045 — MySQL ERROR 1045 (28000): Access denied for user (MySQL)10452002 — MySQL ERROR 2002 (HY000): Can't connect to local MySQL server through socket (MySQL)2002Communications link failure — com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure (Java)Communications link…1040 — MySQL ERROR 1040 (08004): Too many connections (MySQL)1040HikariCP timeout — HikariPool-1 - Connection is not available, request timed out after 30000ms (Java)HikariCP timeout57014 — ERROR: canceling statement due to statement timeout (PostgreSQL)57014idle-in-transaction timeout — FATAL: terminating connection due to idle-in-transaction timeout (PostgreSQL)idle-in-transaction…08P01 — ERROR: bind message supplies 2 parameters, but prepared statement requires 1 (PostgreSQL)08P01SQLite FK failed — sqlite3.IntegrityError: FOREIGN KEY constraint failed (SQL)SQLite FK failedreadonly database — sqlite3.OperationalError: attempt to write a readonly database (SQL)readonly databaseunable to open database — sqlite3.OperationalError: unable to open database file (SQL)unable to open data…Too many re-renders — Error: Too many re-renders. React limits the number of renders to prevent an infinite loop. (React)Too many re-rendersIllegalStateException — java.lang.IllegalStateException (Java)IllegalStateExcepti…read-only property — TypeError: Cannot assign to read only property 'x' of object (JavaScript)read-only propertyConcurrentModificationException — java.util.ConcurrentModificationException (Java)ConcurrentModificat…412 — HTTP 412 Precondition Failed (HTTP)412428 — HTTP 428 Precondition Required (HTTP)428

Directly related (9)

1062MySQL

MySQL ERROR 1062 (23000): Duplicate entry for key

An INSERT/UPDATE would create a duplicate value in a PRIMARY or UNIQUE key.

ORA-00054SQL

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

DDL or a NOWAIT lock couldn’t get the lock because another session holds it.

2006MySQL

MySQL ERROR 2006 (HY000): MySQL server has gone away

The connection to MySQL was closed — usually by a timeout or a packet larger than `max_allowed_packet`.

Lock wait timeoutSQL

Lock wait timeout exceeded; try restarting transaction (MySQL 1205)

A query waited too long for a row lock held by another transaction and gave up.

25P02PostgreSQL

ERROR: current transaction is aborted, commands ignored until end of transaction block

An earlier statement in the same transaction failed; PostgreSQL rejects everything until you ROLLBACK.

SQLITE_BUSYSQL

sqlite3.OperationalError: database is locked (SQLITE_BUSY)

Another connection holds a write lock on the SQLite file, and this one gave up waiting.

Error acquiring the state lockTerraform

Terraform: Error: Error acquiring the state lock — ConditionalCheckFailedException / state blob is already locked

Another Terraform run holds the state lock, or a previous run crashed and left the lock behind.

1213MySQL

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

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

40001PostgreSQL

ERROR: could not serialize access due to concurrent update

A REPEATABLE READ/SERIALIZABLE transaction conflicted with a concurrent one and must be retried.

Two steps away (23)

1452MySQL

MySQL ERROR 1452: Cannot add or update a child row: a foreign key constraint fails

You inserted/updated a row whose foreign key value doesn’t exist in the referenced parent table.

409HTTP

HTTP 409 Conflict

The request conflicts with the current state of the resource — e.g. a duplicate or an edit based on an outdated version.

Subquery returns more than 1 rowSQL

Subquery returns more than 1 row (MySQL 1242) / more than one row returned by a subquery used as an expression

A subquery used where a single value is expected (`= (SELECT …)`) returned several rows.

ORA-00942SQL

ORA-00942: table or view does not exist

Oracle can’t see the table — it doesn’t exist, is in another schema, or you lack privileges on it.

ORA-00904SQL

ORA-00904: "X": invalid identifier

A column name in the statement doesn’t exist (or is misquoted).

ORA-00001SQL

ORA-00001: unique constraint (SCHEMA.PK_X) violated

An insert/update duplicated a value in a unique or primary key constraint.

1045MySQL

MySQL ERROR 1045 (28000): Access denied for user

MySQL rejected the login — wrong password, wrong user/host combination, or the user doesn’t exist.

2002MySQL

MySQL ERROR 2002 (HY000): Can't connect to local MySQL server through socket

The client couldn’t reach the MySQL server — it isn’t running, or the client is looking for the socket/port in the wrong place.

Communications link failureJava

com.mysql.cj.jdbc.exceptions.CommunicationsException: Communications link failure

The MySQL JDBC driver couldn’t reach the database (or the connection dropped).

1040MySQL

MySQL ERROR 1040 (08004): Too many connections

MySQL reached `max_connections` and refuses new clients.

HikariCP timeoutJava

HikariPool-1 - Connection is not available, request timed out after 30000ms

The connection pool was exhausted — all connections were busy for 30 seconds.

57014PostgreSQL

ERROR: canceling statement due to statement timeout

A query ran longer than statement_timeout and PostgreSQL cancelled it.

idle-in-transaction timeoutPostgreSQL

FATAL: terminating connection due to idle-in-transaction timeout

A session opened a transaction and sat idle longer than idle_in_transaction_session_timeout.

08P01PostgreSQL

ERROR: bind message supplies 2 parameters, but prepared statement requires 1

The number of query parameters sent doesn’t match the $1, $2 … placeholders in the SQL.

SQLite FK failedSQL

sqlite3.IntegrityError: FOREIGN KEY constraint failed

An insert/update/delete violated a foreign key in SQLite (with PRAGMA foreign_keys=ON).

readonly databaseSQL

sqlite3.OperationalError: attempt to write a readonly database

The process can’t write to the SQLite file or its directory.

unable to open databaseSQL

sqlite3.OperationalError: unable to open database file

SQLite couldn’t open or create the database file — wrong path or missing/unwritable directory.

Too many re-rendersReact

Error: Too many re-renders. React limits the number of renders to prevent an infinite loop.

A state update runs during render, which triggers another render, which updates state again — forever.

IllegalStateExceptionJava

java.lang.IllegalStateException

A method was called when the object wasn’t in the right state for it.

read-only propertyJavaScript

TypeError: Cannot assign to read only property 'x' of object

Code tried to modify a frozen object, a getter-only property, or immutable state.

ConcurrentModificationExceptionJava

java.util.ConcurrentModificationException

A collection was modified while being iterated (even in a single thread).

412HTTP

HTTP 412 Precondition Failed

A conditional request header (If-Match, If-Unmodified-Since) didn’t match the current state of the resource.

428HTTP

HTTP 428 Precondition Required

The server requires a conditional request (If-Match / If-Unmodified-Since) to prevent lost updates, and you didn’t send one.