Error map

COMMIT Changes disappear: transaction never committed (autocommit off, missing COMMIT)

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.

COMMIT — Changes disappear: transaction never committed (autocommit off, missing COMMIT) (SQL)COMMITLock wait timeout — Lock wait timeout exceeded; try restarting transaction (MySQL 1205) (SQL)Lock wait timeoutidle-in-transaction timeout — FATAL: terminating connection due to idle-in-transaction timeout (PostgreSQL)idle-in-transaction…isolation — Inconsistent results inside a transaction: non-repeatable and phantom reads (isolation level) (SQL)isolation3902 — SQL Server Msg 3902: The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION (SQL)3902cartesian — Query returns far too many rows: accidental Cartesian product (missing JOIN condition) (SQL)cartesianCASE — CASE expression returns mixed types: conversion failed / types cannot be matched (SQL)CASECOUNT — COUNT(column) ignores NULLs: counts differ from COUNT(*) (SQL)COUNT266 — SQL Server Msg 266: Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements (SQL)266transaction — SQLite: cannot start a transaction within a transaction (SQL)transactionSpanner — Spanner: Session not found / ABORTED: transaction was aborted — retry the transaction (Google Cloud / Firebase)Spannercontention — Firestore: 10 ABORTED: Too much contention on these documents. Please try again. (Google Cloud / Firebase)contention2006 — MySQL ERROR 2006 (HY000): MySQL server has gone away (MySQL)2006Deadlock — Deadlock found when trying to get lock; try restarting transaction (SQL)Deadlock1040 — MySQL ERROR 1040 (08004): Too many connections (MySQL)1040522 — Cloudflare Error 522: Connection Timed Out (Cloudflare)522524 — Cloudflare Error 524: A Timeout Occurred (Cloudflare)524ETIMEDOUT — API Request Timed Out (ETIMEDOUT / ReadTimeout / timeout of 30000ms exceeded) (API)ETIMEDOUTConcurrentModificationException — java.util.ConcurrentModificationException (Java)ConcurrentModificat…InterruptedException — java.lang.InterruptedException (sleep interrupted) (Java)InterruptedExceptionTimeoutException — java.util.concurrent.TimeoutException (Java)TimeoutException1213 — 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)4000125P02 — ERROR: current transaction is aborted, commands ignored until end of transaction block (PostgreSQL)25P0257014 — ERROR: canceling statement due to statement timeout (PostgreSQL)57014out of shared memory — ERROR: out of shared memory — HINT: You might need to increase max_locks_per_transaction. (PostgreSQL)out of shared memoryN+1 queries — Performance: N+1 query problem (one query per row in a loop) (SQL)N+1 queriesAttributeError — AttributeError: 'X' object has no attribute 'y' (Python)AttributeErrorClassCastException — java.lang.ClassCastException: class A cannot be cast to class B (Java)ClassCastExceptionERR_INVALID_ARG_TYPE — TypeError [ERR_INVALID_ARG_TYPE]: The "path" argument must be of type string. Received undefined (Node.js)ERR_INVALID_ARG_TYPEaggregate in WHERE — ERROR: aggregate functions are not allowed in WHERE (use HAVING) / MySQL 1111 Invalid use of group function (SQL)aggregate in WHERE= NULL — WHERE col = NULL returns no rows (use IS NULL) (SQL)= NULLNOT IN — NOT IN (subquery) returns no rows because the subquery contains NULL (SQL)NOT IN1205 — SQL Server Msg 1205: Transaction was deadlocked on lock resources and has been chosen as the deadlock victim (SQL)1205209 — SQL Server Msg 209: Ambiguous column name (SQL)209GitHub trigger — Cloud Build trigger doesn't fire or fails: GitHub connection/app not installed or repository not linked (Google Cloud / Firebase)GitHub triggerSQLITE_BUSY — sqlite3.OperationalError: database is locked (SQLITE_BUSY) (SQL)SQLITE_BUSYSQLite UNIQUE failed — sqlite3.IntegrityError: UNIQUE constraint failed: users.email (SQL)SQLite UNIQUE failedSQLite NOT NULL failed — sqlite3.IntegrityError: NOT NULL constraint failed: table.column (SQL)SQLite NOT NULL fai…Firestore: DEADLINE_EXCEEDED / UNAVAILABLE — Firestore: 4 DEADLINE_EXCEEDED: Deadline exceeded / 14 UNAVAILABLE: The service is currently unavailable (Google Cloud / Firebase)Firestore: DEADLINE…retry-limit-exceeded — Firebase Storage: storage/retry-limit-exceeded — Max retry time for operation exceeded (Google Cloud / Firebase)retry-limit-exceededFirestore: Document exceeds the maximum size of 1,048,576 bytes — Firestore: 3 INVALID_ARGUMENT: The value of property "data" is longer than 1048487 bytes / Document exceeds the maximum size (Google Cloud / Firebase)Firestore: Document…ALREADY_EXISTS — Firestore: 6 ALREADY_EXISTS — document already exists (create() on an existing document) (Google Cloud / Firebase)ALREADY_EXISTShotspotting — Firestore write latency/errors: hotspotting from sequential document IDs or indexed fields (Google Cloud / Firebase)hotspotting

Directly related (11)

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.

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.

isolationSQL

Inconsistent results inside a transaction: non-repeatable and phantom reads (isolation level)

Two reads in the same transaction see different data because another transaction committed in between.

3902SQL

SQL Server Msg 3902: The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION

A COMMIT (or ROLLBACK 3903) ran when no transaction was open, often after an earlier error rolled everything back.

cartesianSQL

Query returns far too many rows: accidental Cartesian product (missing JOIN condition)

Two tables were joined without a condition, so every row of one pairs with every row of the other.

CASESQL

CASE expression returns mixed types: conversion failed / types cannot be matched

The branches of a CASE expression produce incompatible data types (text and number, date and string).

COUNTSQL

COUNT(column) ignores NULLs: counts differ from COUNT(*)

`COUNT(col)` counts only non-NULL values, while `COUNT(*)` counts rows, so totals don't match.

266SQL

SQL Server Msg 266: Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements

A stored procedure or trigger exited with a different @@TRANCOUNT than it started with.

transactionSQL

SQLite: cannot start a transaction within a transaction

BEGIN was issued while a transaction was already open on the same connection.

SpannerGoogle Cloud / Firebase

Spanner: Session not found / ABORTED: transaction was aborted — retry the transaction

Spanner killed an idle session or aborted a transaction because of lock conflicts, and the client must retry.

contentionGoogle Cloud / Firebase

Firestore: 10 ABORTED: Too much contention on these documents. Please try again.

Many transactions or writes hit the same document, so Firestore aborted yours.

Two steps away (32)

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

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.

1040MySQL

MySQL ERROR 1040 (08004): Too many connections

MySQL reached `max_connections` and refuses new clients.

522Cloudflare

Cloudflare Error 522: Connection Timed Out

Cloudflare’s TCP connection to your origin timed out — the origin didn’t answer at all.

524Cloudflare

Cloudflare Error 524: A Timeout Occurred

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

ETIMEDOUTAPI

API Request Timed Out (ETIMEDOUT / ReadTimeout / timeout of 30000ms exceeded)

The client gave up waiting — either for the connection to open or for the response to arrive.

ConcurrentModificationExceptionJava

java.util.ConcurrentModificationException

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

InterruptedExceptionJava

java.lang.InterruptedException (sleep interrupted)

A blocked thread (sleep, wait, join, queue take) was interrupted by another thread.

TimeoutExceptionJava

java.util.concurrent.TimeoutException

A Future.get(timeout) or async operation didn’t complete in the allowed time.

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.

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.

57014PostgreSQL

ERROR: canceling statement due to statement timeout

A query ran longer than statement_timeout and PostgreSQL cancelled it.

out of shared memoryPostgreSQL

ERROR: out of shared memory — HINT: You might need to increase max_locks_per_transaction.

A transaction took more locks than the lock table can hold — usually touching many tables/partitions at once.

N+1 queriesSQL

Performance: N+1 query problem (one query per row in a loop)

Code runs one query to load a list, then one more query per item — hundreds of queries per page.

AttributeErrorPython

AttributeError: 'X' object has no attribute 'y'

You accessed an attribute or method that doesn’t exist on that object type.

ClassCastExceptionJava

java.lang.ClassCastException: class A cannot be cast to class B

An object was cast to a type it isn’t.

ERR_INVALID_ARG_TYPENode.js

TypeError [ERR_INVALID_ARG_TYPE]: The "path" argument must be of type string. Received undefined

A Node API got an argument of the wrong type — usually undefined because an env var or config value is missing.

aggregate in WHERESQL

ERROR: aggregate functions are not allowed in WHERE (use HAVING) / MySQL 1111 Invalid use of group function

An aggregate (SUM, COUNT, AVG) was used in WHERE, which filters rows before grouping.

= NULLSQL

WHERE col = NULL returns no rows (use IS NULL)

Comparing anything to NULL with = or never matches, because the result is UNKNOWN, not true.

NOT INSQL

NOT IN (subquery) returns no rows because the subquery contains NULL

If the list or subquery for NOT IN contains a single NULL, the whole condition is UNKNOWN and no rows come back.

1205SQL

SQL Server Msg 1205: Transaction was deadlocked on lock resources and has been chosen as the deadlock victim

Two sessions each hold locks the other needs, so SQL Server rolled one of them back.

209SQL

SQL Server Msg 209: Ambiguous column name

A column exists in more than one table of the query and isn't qualified.

GitHub triggerGoogle Cloud / Firebase

Cloud Build trigger doesn't fire or fails: GitHub connection/app not installed or repository not linked

A push or PR doesn't start a build, or the trigger shows a connection error with GitHub.

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.

SQLite UNIQUE failedSQL

sqlite3.IntegrityError: UNIQUE constraint failed: users.email

An insert/update duplicated a value in a UNIQUE or PRIMARY KEY column in SQLite.

SQLite NOT NULL failedSQL

sqlite3.IntegrityError: NOT NULL constraint failed: table.column

A NULL went into a NOT NULL column in SQLite.

Firestore: DEADLINE_EXCEEDED / UNAVAILABLEGoogle Cloud / Firebase

Firestore: 4 DEADLINE_EXCEEDED: Deadline exceeded / 14 UNAVAILABLE: The service is currently unavailable

A Firestore request timed out or could not reach the service — contention, hot documents, large operations or network issues.

retry-limit-exceededGoogle Cloud / Firebase

Firebase Storage: storage/retry-limit-exceeded — Max retry time for operation exceeded

An upload or download kept failing until the SDK's retry window (default 2 minutes for uploads) ran out.

Firestore: Document exceeds the maximum size of 1,048,576 bytesGoogle Cloud / Firebase

Firestore: 3 INVALID_ARGUMENT: The value of property "data" is longer than 1048487 bytes / Document exceeds the maximum size

A single Firestore document (all fields combined) went beyond the 1 MiB limit.

ALREADY_EXISTSGoogle Cloud / Firebase

Firestore: 6 ALREADY_EXISTS — document already exists (create() on an existing document)

`create()` or a transaction tried to create a document at a path that is already taken.

hotspottingGoogle Cloud / Firebase

Firestore write latency/errors: hotspotting from sequential document IDs or indexed fields

Writes get slow or fail when many documents with monotonically increasing IDs or indexed values land in the same key range.