Error map

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

SQL Β· layer 5, Data

Open the full error page β†’

Centre: this error. First ring: errors it is linked with (8). 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-02291 β€” ORA-02291: integrity constraint (SCHEMA.FK_NAME) violated - parent key not found (SQL)ORA-02291ORA-00001 β€” ORA-00001: unique constraint (SCHEMA.PK_X) violated (SQL)ORA-0000123503 β€” ERROR: insert or update on table "x" violates foreign key constraint "fk" β€” Key (user_id)=(5) is not present in table "users" (PostgreSQL)235033726 β€” 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-00020 β€” ORA-00020: maximum number of processes (150) exceeded (SQL)ORA-00020ORA-02292 β€” ORA-02292: integrity constraint (SCHEMA.FK_NAME) violated - child record found (SQL)ORA-022921062 β€” 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)145223505 β€” PostgreSQL: ERROR: duplicate key value violates unique constraint (PostgreSQL)235051451 β€” MySQL ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (MySQL)14512BP01 β€” 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)547TRUNCATE β€” Cannot truncate a table referenced by a FOREIGN KEY constraint (SQL)TRUNCATESQLite 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)transactionHibernate 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)10221048 β€” MySQL ERROR 1048 (23000): Column 'x' cannot be null (MySQL)1048ExpiredToken β€” 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-00942EADDRINUSE β€” Error: listen EADDRINUSE: address already in use :::3000 (Node.js)EADDRINUSEEPIPE β€” Error: write EPIPE (Node.js)EPIPEmaxBuffer exceeded β€” RangeError [ERR_CHILD_PROCESS_STDIO_MAXBUFFER]: stdout maxBuffer length exceeded (Node.js)maxBuffer exceededretention β€” Cloud Storage: Object is subject to the bucket's retention policy and cannot be deleted (Google Cloud / Firebase)retention

Directly related (8)

Two steps away (22)

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.

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.

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.

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

TRUNCATESQL

Cannot truncate a table referenced by a FOREIGN KEY constraint

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

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.

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.

1048MySQL

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

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.

EADDRINUSENode.js

Error: listen EADDRINUSE: address already in use :::3000

Another process is already listening on that port.

EPIPENode.js

Error: write EPIPE

Node wrote to a pipe or socket whose other end was already closed.

maxBuffer exceededNode.js

RangeError [ERR_CHILD_PROCESS_STDIO_MAXBUFFER]: stdout maxBuffer length exceeded

child_process.exec/execSync produced more output than its buffer allows (default 1 MB).

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.