Error map

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

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.

SQLite NOT NULL failed — sqlite3.IntegrityError: NOT NULL constraint failed: table.column (SQL)SQLite NOT …readonly database — sqlite3.OperationalError: attempt to write a readonly database (SQL)readonly databaseORA-00001 — ORA-00001: unique constraint (SCHEMA.PK_X) violated (SQL)ORA-00001DbUpdateException — DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. (.NET)DbUpdateException23502 — ERROR: null value in column "x" of relation "y" violates not-null constraint (PostgreSQL)23502SQLite UNIQUE failed — sqlite3.IntegrityError: UNIQUE constraint failed: users.email (SQL)SQLite UNIQUE failed2627 — SQL Server: Violation of PRIMARY KEY constraint 'x'. Cannot insert duplicate key in object 'y'. (Msg 2627) (SQL)2627ALREADY_EXISTS — API Error: Resource already exists (ALREADY_EXISTS / resource_already_exists / 409) (API)ALREADY_EXISTSmalformed database — sqlite3.DatabaseError: database disk image is malformed (SQL)malformed databaseORA-01400 — ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE"."COLUMN") (SQL)ORA-01400EACCES — Linux: Permission denied (Linux)EACCESSQLITE_BUSY — sqlite3.OperationalError: database is locked (SQLITE_BUSY) (SQL)SQLITE_BUSYSQLite no such column — sqlite3.OperationalError: no such column: x (SQL)SQLite no such colu…1062 — MySQL ERROR 1062 (23000): Duplicate entry for key (MySQL)1062ORA-00942 — ORA-00942: table or view does not exist (SQL)ORA-00942ORA-00904 — ORA-00904: "X": invalid identifier (SQL)ORA-009041452 — MySQL ERROR 1452: Cannot add or update a child row: a foreign key constraint fails (MySQL)1452JsonException object cycle — JsonException: A possible object cycle was detected (.NET)JsonException objec…23505 — PostgreSQL: ERROR: duplicate key value violates unique constraint (PostgreSQL)235051048 — MySQL ERROR 1048 (23000): Column 'x' cannot be null (MySQL)104823503 — ERROR: insert or update on table "x" violates foreign key constraint "fk" — Key (user_id)=(5) is not present in table "users" (PostgreSQL)2350323503 parent — ERROR: update or delete on table "users" violates foreign key constraint on table "orders" — Key (id)=(5) is still referenced (PostgreSQL)23503 parent245 — SQL Server: Conversion failed when converting the varchar value 'x' to data type int. (Msg 245) (SQL)2458115 — SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115) (SQL)8115544 — SQL Server: Cannot insert explicit value for identity column in table 'x' when IDENTITY_INSERT is set to OFF. (SQL)544409 — HTTP 409 Conflict (HTTP)409Hibernate ConstraintViolationException — org.hibernate.exception.ConstraintViolationException: could not execute statement (Java)Hibernate Constrain…1022 — MySQL ERROR 1022 (23000): Can't write; duplicate key in table (MySQL)1022corrupt 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…SQLite FK failed — sqlite3.IntegrityError: FOREIGN KEY constraint failed (SQL)SQLite FK failedORA-00933 — ORA-00933: SQL command not properly ended (SQL)ORA-00933ORA-00054 — ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired (SQL)ORA-00054ORA-06512 — ORA-06512: at "SCHEMA.PROC", line N (SQL)ORA-06512

Directly related (9)

Two steps away (24)

EACCESLinux

Linux: Permission denied

Your user (or the service user) lacks read/write/execute permission on a file, directory or one of its parents.

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

1062MySQL

MySQL ERROR 1062 (23000): Duplicate entry for key

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

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

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.

JsonException object cycle.NET

JsonException: A possible object cycle was detected

System.Text.Json found a reference loop (e.g. Order → Customer → Orders → …) while serialising, usually from EF Core navigation p…

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.

1048MySQL

MySQL ERROR 1048 (23000): Column 'x' cannot be null

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

23503PostgreSQL

ERROR: insert or update on table "x" violates foreign key constraint "fk" — Key (user_id)=(5) is not present in table "users"

The row references a parent row that doesn’t exist.

23503 parentPostgreSQL

ERROR: update or delete on table "users" violates foreign key constraint on table "orders" — Key (id)=(5) is still referenced

You tried to delete a row that other rows still reference.

245SQL

SQL Server: Conversion failed when converting the varchar value 'x' to data type int. (Msg 245)

SQL Server tried to convert text to a number (often implicitly) and hit a non-numeric value.

8115SQL

SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115)

A value or calculation exceeds the target data type’s range.

544SQL

SQL Server: Cannot insert explicit value for identity column in table 'x' when IDENTITY_INSERT is set to OFF.

An INSERT supplied a value for an IDENTITY column.

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.

Hibernate ConstraintViolationExceptionJava

org.hibernate.exception.ConstraintViolationException: could not execute statement

The database rejected an insert/update because of a constraint (unique, foreign key, not null).

1022MySQL

MySQL ERROR 1022 (23000): Can't write; duplicate key in table

An ALTER/CREATE produced a duplicate key or constraint name — often a foreign key name that already exists in the database.

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.

SQLite FK failedSQL

sqlite3.IntegrityError: FOREIGN KEY constraint failed

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

ORA-00933SQL

ORA-00933: SQL command not properly ended

Oracle found extra clauses or syntax it doesn’t support at the end of a statement.

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.

ORA-06512SQL

ORA-06512: at "SCHEMA.PROC", line N

A stack-trace line from PL/SQL — the real error is the ORA- code above it.