Error map

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

SQL · layer 5, Data

Open the full error page →

Centre: this error. First ring: errors it is linked with (11). 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.

Lock wait timeout — Lock wait timeout exceeded; try restarting transaction (MySQL 1205) (SQL)Lock wait t…57014 — ERROR: canceling statement due to statement timeout (PostgreSQL)57014HikariCP timeout — HikariPool-1 - Connection is not available, request timed out after 30000ms (Java)HikariCP timeoutORA-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)20061040 — MySQL ERROR 1040 (08004): Too many connections (MySQL)104025P02 — ERROR: current transaction is aborted, commands ignored until end of transaction block (PostgreSQL)25P02SQLITE_BUSY — sqlite3.OperationalError: database is locked (SQLITE_BUSY) (SQL)SQLITE_BUSYExecution Timeout Expired — SQL Server: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (SQL)Execution Timeout E…Error acquiring the state lock — Terraform: Error: Error acquiring the state lock — ConditionalCheckFailedException / state blob is already locked (Terraform)Error acquiring the…Deadlock — Deadlock found when trying to get lock; try restarting transaction (SQL)Deadlock1213 — MySQL ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction (MySQL)1213504 — HTTP 504 Gateway Timeout (HTTP)504524 — Cloudflare Error 524: A Timeout Occurred (Cloudflare)524304 — HTTP 304 Not Modified (HTTP)3042002 — 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…1049 — MySQL ERROR 1049 (42000): Unknown database 'x' (MySQL)1049ORA-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)10451153 — MySQL ERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet' bytes (MySQL)11532003 — MySQL ERROR 2003 (HY000): Can't connect to MySQL server on 'host:3306' (111) (MySQL)2003DB connection — WordPress: Error Establishing a Database Connection (WordPress)DB connectionEMFILE — Too many open files (EMFILE) (Linux)EMFILE1114 — MySQL ERROR 1114 (HY000): The table 'x' is full (MySQL)1114idle-in-transaction timeout — FATAL: terminating connection due to idle-in-transaction timeout (PostgreSQL)idle-in-transaction…40001 — ERROR: could not serialize access due to concurrent update (PostgreSQL)4000108P01 — 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…18456 — SQL Server: Login failed for user 'x'. (Error 18456) (SQL)18456207 — SQL Server: Invalid column name 'x'. (Msg 207) (SQL)2072627 — SQL Server: Violation of PRIMARY KEY constraint 'x'. Cannot insert duplicate key in object 'y'. (Msg 2627) (SQL)2627409 — HTTP 409 Conflict (HTTP)409Too 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…1062 — MySQL ERROR 1062 (23000): Duplicate entry for key (MySQL)1062

Directly related (11)

57014PostgreSQL

ERROR: canceling statement due to statement timeout

A query ran longer than statement_timeout and PostgreSQL cancelled it.

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.

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`.

1040MySQL

MySQL ERROR 1040 (08004): Too many connections

MySQL reached `max_connections` and refuses new clients.

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.

Execution Timeout ExpiredSQL

SQL Server: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

The command ran longer than the client’s CommandTimeout (default 30 seconds).

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.

DeadlockSQL

Deadlock found when trying to get lock; try restarting transaction

Two transactions waited on each other’s locks; the database killed one so the other could continue.

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.

Two steps away (28)

504HTTP

HTTP 504 Gateway Timeout

A proxy or gateway waited too long for the upstream server to respond and gave up.

524Cloudflare

Cloudflare Error 524: A Timeout Occurred

Cloudflare connected to the origin, but the origin didn’t send an HTTP response within 100 seconds.

304HTTP

HTTP 304 Not Modified

The cached copy is still valid, so the server sends no body and the client reuses its cache.

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).

1049MySQL

MySQL ERROR 1049 (42000): Unknown database 'x'

The database named in the connection doesn’t exist on that server.

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.

1153MySQL

MySQL ERROR 1153 (08S01): Got a packet bigger than 'max_allowed_packet' bytes

A single statement or row exceeded max_allowed_packet — big BLOBs, huge INSERTs or large dump lines.

2003MySQL

MySQL ERROR 2003 (HY000): Can't connect to MySQL server on 'host:3306' (111)

The client couldn’t reach MySQL over TCP — server down, wrong host/port, firewall, or MySQL bound to localhost only.

DB connectionWordPress

WordPress: Error Establishing a Database Connection

WordPress can’t connect to its MySQL/MariaDB database with the credentials in wp-config.php, or the database server is down.

EMFILELinux

Too many open files (EMFILE)

The process hit its file-descriptor limit — sockets, files and pipes all count.

1114MySQL

MySQL ERROR 1114 (HY000): The table 'x' is full

MySQL couldn’t extend the table — disk full, a size limit, or a MEMORY table hitting max_heap_table_size.

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.

40001PostgreSQL

ERROR: could not serialize access due to concurrent update

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

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.

18456SQL

SQL Server: Login failed for user 'x'. (Error 18456)

SQL Server rejected the login — wrong password, wrong authentication mode, or a disabled/missing login.

207SQL

SQL Server: Invalid column name 'x'. (Msg 207)

SQL Server can’t find the column — typo, missing migration, or a string in double quotes with QUOTED_IDENTIFIER ON.

2627SQL

SQL Server: Violation of PRIMARY KEY constraint 'x'. Cannot insert duplicate key in object 'y'. (Msg 2627)

An insert duplicated a primary key or unique constraint value.

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.

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.

1062MySQL

MySQL ERROR 1062 (23000): Duplicate entry for key

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