Error map

ORA-02292 ORA-02292: integrity constraint (SCHEMA.FK_NAME) violated - child record found

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.

ORA-02292 β€” ORA-02292: integrity constraint (SCHEMA.FK_NAME) violated - child record found (SQL)ORA-02292ORA-00001 β€” ORA-00001: unique constraint (SCHEMA.PK_X) violated (SQL)ORA-000011451 β€” MySQL ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (MySQL)1451TRUNCATE β€” Cannot truncate a table referenced by a FOREIGN KEY constraint (SQL)TRUNCATE3726 β€” SQL Server Msg 3726: Could not drop object because it is referenced by a FOREIGN KEY constraint (SQL)3726PRAGMA foreign_keys β€” SQLite foreign keys not enforced: PRAGMA foreign_keys is OFF by default (SQL)PRAGMA foreign_keysforeign key order β€” Foreign key violation caused by insert order or circular references (SQL)foreign key orderORA-00018 β€” ORA-00018: maximum number of sessions exceeded (SQL)ORA-00018ORA-02291 β€” ORA-02291: integrity constraint (SCHEMA.FK_NAME) violated - parent key not found (SQL)ORA-02291retention β€” Cloud Storage: Object is subject to the bucket's retention policy and cannot be deleted (Google Cloud / Firebase)retention1062 β€” MySQL ERROR 1062 (23000): Duplicate entry for key (MySQL)1062SQLite 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…1452 β€” MySQL ERROR 1452: Cannot add or update a child row: a foreign key constraint fails (MySQL)14521005 β€” MySQL ERROR 1005 (HY000): Can't create table (errno: 150 "Foreign key constraint is incorrectly formed") (MySQL)10051022 β€” MySQL ERROR 1022 (23000): Can't write; duplicate key in table (MySQL)102223505 β€” PostgreSQL: ERROR: duplicate key value violates unique constraint (PostgreSQL)23505Hibernate ConstraintViolationException β€” org.hibernate.exception.ConstraintViolationException: could not execute statement (Java)Hibernate Constrain…1048 β€” MySQL ERROR 1048 (23000): Column 'x' cannot be null (MySQL)10482BP01 β€” ERROR: cannot drop table x because other objects depend on it (PostgreSQL)2BP01547 β€” SQL Server: The INSERT statement conflicted with the FOREIGN KEY constraint 'x'. (Msg 547) (SQL)547515 β€” SQL Server Msg 515: Cannot insert the value NULL into column 'X', table 'Y'; column does not allow nulls (SQL)515SQLite FK failed β€” sqlite3.IntegrityError: FOREIGN KEY constraint failed (SQL)SQLite FK failedreadonly database β€” sqlite3.OperationalError: attempt to write a readonly database (SQL)readonly databasetransaction β€” SQLite: cannot start a transaction within a transaction (SQL)transactionE11000 duplicate key β€” MongoServerError: E11000 duplicate key error collection: db.users index: email_1 dup key (Node.js)E11000 duplicate keyPrisma P2002 β€” PrismaClientKnownRequestError P2002: Unique constraint failed on the fields: (`email`) (Node.js)Prisma P200223502 β€” ERROR: null value in column "x" of relation "y" violates not-null constraint (PostgreSQL)23502ExpiredToken β€” AWS: ExpiredToken β€” The security token included in the request is expired (AWS)ExpiredTokensession_start() β€” Warning: session_start(): Session cannot be started after headers have already been sent (PHP)session_start()ORA-00942 β€” ORA-00942: table or view does not exist (SQL)ORA-0094223503 β€” ERROR: insert or update on table "x" violates foreign key constraint "fk" β€” Key (user_id)=(5) is not present in table "users" (PostgreSQL)23503ORA-00020 β€” ORA-00020: maximum number of processes (150) exceeded (SQL)ORA-00020403: does not have storage.objects.get access β€” Cloud Storage: 403 Forbidden β€” user@example.com does not have storage.objects.get access to the Google Cloud Storage object (Google Cloud / Firebase)403: does not have …NoSuchBucket / 404 The specified bucket does not exist β€” Cloud Storage: 404 Not Found β€” The specified bucket does not exist / No such object: bucket/object (Google Cloud / Firebase)NoSuchBucket / 404 …UBLA β€” Cloud Storage: Cannot use ACL API to update object β€” uniform bucket-level access is enabled (Google Cloud / Firebase)UBLA

Directly related (9)

ORA-00001SQL

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

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

1451MySQL

MySQL ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails

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

TRUNCATESQL

Cannot truncate a table referenced by a FOREIGN KEY constraint

TRUNCATE is refused because another table has a foreign key pointing to it.

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.

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…

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.

ORA-00018SQL

ORA-00018: maximum number of sessions exceeded

The database reached its SESSIONS limit, so no new connection can be created.

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.

retentionGoogle Cloud / Firebase

Cloud Storage: Object is subject to the bucket's retention policy and cannot be deleted

A retention policy or object hold protects the object until its retention period ends.

Two steps away (26)

1062MySQL

MySQL ERROR 1062 (23000): Duplicate entry for key

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

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.

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.

1005MySQL

MySQL ERROR 1005 (HY000): Can't create table (errno: 150 "Foreign key constraint is incorrectly formed")

A foreign key definition is invalid β€” the referenced column’s type, index or charset doesn’t match.

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.

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.

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

1048MySQL

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

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

2BP01PostgreSQL

ERROR: cannot drop table x because other objects depend on it

Views, foreign keys or other objects depend on what you’re dropping.

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

515SQL

SQL Server Msg 515: Cannot insert the value NULL into column 'X', table 'Y'; column does not allow nulls

An INSERT or UPDATE tried to put NULL into a NOT NULL column that has no default.

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.

transactionSQL

SQLite: cannot start a transaction within a transaction

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

E11000 duplicate keyNode.js

MongoServerError: E11000 duplicate key error collection: db.users index: email_1 dup key

An insert/update violated a unique index in MongoDB.

Prisma P2002Node.js

PrismaClientKnownRequestError P2002: Unique constraint failed on the fields: (`email`)

A Prisma create/update violated a unique constraint.

23502PostgreSQL

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

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

ExpiredTokenAWS

AWS: ExpiredToken β€” The security token included in the request is expired

Temporary AWS credentials (STS/SSO/assumed role) have expired.

session_start()PHP

Warning: session_start(): Session cannot be started after headers have already been sent

session_start() ran after output was sent, so PHP can’t set the session cookie.

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.

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.

ORA-00020SQL

ORA-00020: maximum number of processes (150) exceeded

The instance reached its PROCESSES limit, so new connections are refused.

403: does not have storage.objects.get accessGoogle Cloud / Firebase

Cloud Storage: 403 Forbidden β€” user@example.com does not have storage.objects.get access to the Google Cloud Storage object

The identity making the request has no read permission on that bucket or object.

NoSuchBucket / 404 The specified bucket does not existGoogle Cloud / Firebase

Cloud Storage: 404 Not Found β€” The specified bucket does not exist / No such object: bucket/object

The bucket or object name in your request doesn't exist (typo, deleted, wrong project, or a leading slash issue).

UBLAGoogle Cloud / Firebase

Cloud Storage: Cannot use ACL API to update object β€” uniform bucket-level access is enabled

The bucket uses IAM only, so ACL calls (`makePublic`, `predefinedAcl`) are rejected.