Error map

transaction SQLite: cannot start a transaction within a transaction

SQL · layer 5, Data

Open the full error page →

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

transaction — SQLite: cannot start a transaction within a transaction (SQL)transactionSQLite syntax error — sqlite3.OperationalError: near "x": syntax error (SQL)SQLite syntax errorunable to open database — sqlite3.OperationalError: unable to open database file (SQL)unable to open data…Deadlock — Deadlock found when trying to get lock; try restarting transaction (SQL)DeadlockLock wait timeout — Lock wait timeout exceeded; try restarting transaction (MySQL 1205) (SQL)Lock wait timeoutSQLITE_BUSY — sqlite3.OperationalError: database is locked (SQLITE_BUSY) (SQL)SQLITE_BUSYSQLite UNIQUE failed — sqlite3.IntegrityError: UNIQUE constraint failed: users.email (SQL)SQLite UNIQUE failedSQLite FK failed — sqlite3.IntegrityError: FOREIGN KEY constraint failed (SQL)SQLite FK failedmalformed database — sqlite3.DatabaseError: database disk image is malformed (SQL)malformed databaseSQLite NOT NULL failed — sqlite3.IntegrityError: NOT NULL constraint failed: table.column (SQL)SQLite NOT NULL fai…PRAGMA foreign_keys — SQLite foreign keys not enforced: PRAGMA foreign_keys is OFF by default (SQL)PRAGMA foreign_keysisolation — Inconsistent results inside a transaction: non-repeatable and phantom reads (isolation level) (SQL)isolationCOMMIT — Changes disappear: transaction never committed (autocommit off, missing COMMIT) (SQL)COMMIT1064 — MySQL ERROR 1064 (42000): You have an error in your SQL syntax (MySQL)1064ambiguous column — Column reference is ambiguous / Column 'id' in field list is ambiguous (MySQL 1052) (SQL)ambiguous columnGROUP BY — Column must appear in the GROUP BY clause / isn't in GROUP BY (MySQL 1055 only_full_group_by) (SQL)GROUP BYFileNotFoundError — FileNotFoundError: [Errno 2] No such file or directory: 'data.csv' (Python)FileNotFoundErrorSQLite no such column — sqlite3.OperationalError: no such column: x (SQL)SQLite no such colu…readonly database — sqlite3.OperationalError: attempt to write a readonly database (SQL)readonly database1062 — MySQL ERROR 1062 (23000): Duplicate entry for key (MySQL)10622006 — MySQL ERROR 2006 (HY000): MySQL server has gone away (MySQL)20061213 — MySQL ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction (MySQL)12131040 — 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)57014ORA-00054 — ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired (SQL)ORA-00054Error acquiring the state lock — Terraform: Error: Error acquiring the state lock — ConditionalCheckFailedException / state blob is already locked (Terraform)Error acquiring the…1205 — SQL Server Msg 1205: Transaction was deadlocked on lock resources and has been chosen as the deadlock victim (SQL)120523505 — PostgreSQL: ERROR: duplicate key value violates unique constraint (PostgreSQL)235052627 — SQL Server: Violation of PRIMARY KEY constraint 'x'. Cannot insert duplicate key in object 'y'. (Msg 2627) (SQL)2627ORA-00001 — ORA-00001: unique constraint (SCHEMA.PK_X) violated (SQL)ORA-000011452 — MySQL ERROR 1452: Cannot add or update a child row: a foreign key constraint fails (MySQL)1452547 — SQL Server: The INSERT statement conflicted with the FOREIGN KEY constraint 'x'. (Msg 547) (SQL)547database or disk is full — SQLite: database or disk is full (SQLITE_FULL) (SQL)database or disk is…corrupt object — error: object file .git/objects/x is empty / fatal: loose object is corrupt (Git)corrupt object126 incorrect key file — MySQL ERROR 126 (HY000): Incorrect key file for table; try to repair it (MySQL)126 incorrect key f…ORA-00600 — ORA-00600: internal error code, arguments: [...] (SQL)ORA-0060023502 — ERROR: null value in column "x" of relation "y" violates not-null constraint (PostgreSQL)23502ORA-01400 — ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE"."COLUMN") (SQL)ORA-01400ALREADY_EXISTS — API Error: Resource already exists (ALREADY_EXISTS / resource_already_exists / 409) (API)ALREADY_EXISTSforeign key order — Foreign key violation caused by insert order or circular references (SQL)foreign key order3726 — SQL Server Msg 3726: Could not drop object because it is referenced by a FOREIGN KEY constraint (SQL)3726ORA-02291 — ORA-02291: integrity constraint (SCHEMA.FK_NAME) violated - parent key not found (SQL)ORA-02291ConcurrentModificationException — java.util.ConcurrentModificationException (Java)ConcurrentModificat…InterruptedException — java.lang.InterruptedException (sleep interrupted) (Java)InterruptedExceptionTimeoutException — java.util.concurrent.TimeoutException (Java)TimeoutExceptionidle-in-transaction timeout — FATAL: terminating connection due to idle-in-transaction timeout (PostgreSQL)idle-in-transaction…cartesian — 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)CASE

Directly related (12)

SQLite syntax errorSQL

sqlite3.OperationalError: near "x": syntax error

SQLite couldn’t parse the statement; the token after “near” is where it stopped.

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.

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.

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.

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 FK failedSQL

sqlite3.IntegrityError: FOREIGN KEY constraint failed

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

malformed databaseSQL

sqlite3.DatabaseError: database disk image is malformed

The SQLite file is corrupted.

SQLite NOT NULL failedSQL

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

A NULL went into a NOT NULL column in SQLite.

PRAGMA foreign_keysSQL

SQLite foreign keys not enforced: PRAGMA foreign_keys is OFF by default

Child rows can reference missing parents, and ON DELETE CASCADE doesn't run, because foreign key enforcement is disabled per conn…

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.

COMMITSQL

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

Data inserted or updated "works" in your session but isn't there for others, or is gone after reconnecting.

Two steps away (36)

1064MySQL

MySQL ERROR 1064 (42000): You have an error in your SQL syntax

MySQL couldn’t parse the query. The text after “near” shows where parsing failed.

ambiguous columnSQL

Column reference is ambiguous / Column 'id' in field list is ambiguous (MySQL 1052)

A column name exists in more than one joined table, so the database doesn’t know which one you mean.

GROUP BYSQL

Column must appear in the GROUP BY clause / isn't in GROUP BY (MySQL 1055 only_full_group_by)

You selected a column that is neither grouped nor aggregated, so the result would be ambiguous.

FileNotFoundErrorPython

FileNotFoundError: [Errno 2] No such file or directory: 'data.csv'

Python couldn’t find the file at that path — usually because relative paths resolve from the working directory, not the script.

SQLite no such columnSQL

sqlite3.OperationalError: no such column: x

SQLite can’t find the column — missing migration, typo, or a string written in double quotes.

readonly databaseSQL

sqlite3.OperationalError: attempt to write a readonly database

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

1062MySQL

MySQL ERROR 1062 (23000): Duplicate entry for key

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

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

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.

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.

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.

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.

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.

23505PostgreSQL

PostgreSQL: ERROR: duplicate key value violates unique constraint

An INSERT/UPDATE would create a duplicate in a UNIQUE or PRIMARY KEY column — or the id sequence is behind the existing data.

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.

ORA-00001SQL

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

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

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.

547SQL

SQL Server: The INSERT statement conflicted with the FOREIGN KEY constraint 'x'. (Msg 547)

The row references a parent that doesn’t exist (or a DELETE would orphan children).

database or disk is fullSQL

SQLite: database or disk is full (SQLITE_FULL)

SQLite couldn't allocate more space: the disk, quota or a configured size limit is full.

corrupt objectGit

error: object file .git/objects/x is empty / fatal: loose object is corrupt

The local Git object database is corrupted — usually after a crash, disk full or sync tool interference.

126 incorrect key fileMySQL

MySQL ERROR 126 (HY000): Incorrect key file for table; try to repair it

MySQL can’t use a table’s index file — usually a full tmp disk during a query, or MyISAM corruption.

ORA-00600SQL

ORA-00600: internal error code, arguments: [...]

Oracle hit an unexpected internal condition (a bug, corruption or hardware/OS problem).

23502PostgreSQL

ERROR: null value in column "x" of relation "y" violates not-null constraint

An INSERT/UPDATE put NULL into a NOT NULL column.

ORA-01400SQL

ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE"."COLUMN")

A NULL was inserted into a NOT NULL column.

ALREADY_EXISTSAPI

API Error: Resource already exists (ALREADY_EXISTS / resource_already_exists / 409)

The create request was refused because an object with the same unique identity — name, email, external ID — already exists.

foreign key orderSQL

Foreign key violation caused by insert order or circular references

Rows must be inserted parent-first, and two tables that reference each other need deferred constraints or nullable columns.

3726SQL

SQL Server Msg 3726: Could not drop object because it is referenced by a FOREIGN KEY constraint

You tried to drop a table that other tables still reference.

ORA-02291SQL

ORA-02291: integrity constraint (SCHEMA.FK_NAME) violated - parent key not found

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

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.

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.

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