Error map

SQL0803N Db2 SQL0803N: One or more values in the INSERT or UPDATE statement violate a unique index (SQLSTATE 23505)

SQL Β· layer 5, Data

Open the full error page β†’

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

SQL0803N β€” Db2 SQL0803N: One or more values in the INSERT or UPDATE statement violate a unique index (SQLSTATE 23505) (SQL)SQL0803NORA-00001 β€” ORA-00001: unique constraint (SCHEMA.PK_X) violated (SQL)ORA-000012627 β€” SQL Server: Violation of PRIMARY KEY constraint 'x'. Cannot insert duplicate key in object 'y'. (Msg 2627) (SQL)2627aggregate in WHERE β€” ERROR: aggregate functions are not allowed in WHERE (use HAVING) / MySQL 1111 Invalid use of group function (SQL)aggregate in WHERESQLite UNIQUE failed β€” sqlite3.IntegrityError: UNIQUE constraint failed: users.email (SQL)SQLite UNIQUE failedSQL0204N β€” Db2 SQL0204N: "SCHEMA.TABLE" is an undefined name (SQLSTATE 42704) (SQL)SQL0204Ncartesian β€” Query returns far too many rows: accidental Cartesian product (missing JOIN condition) (SQL)cartesianSQL0911N β€” Db2 SQL0911N: The current transaction has been rolled back because of a deadlock or timeout (reason code 68) (SQL)SQL0911N1062 β€” MySQL ERROR 1062 (23000): Duplicate entry for key (MySQL)1062SQLite NOT NULL failed β€” sqlite3.IntegrityError: NOT NULL constraint failed: table.column (SQL)SQLite NOT NULL fai…ORA-00942 β€” ORA-00942: table or view does not exist (SQL)ORA-00942245 β€” 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)5441064 β€” 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 BY23505 β€” PostgreSQL: ERROR: duplicate key value violates unique constraint (PostgreSQL)23505readonly database β€” sqlite3.OperationalError: attempt to write a readonly database (SQL)readonly databaseORA-01400 β€” ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE"."COLUMN") (SQL)ORA-014001146 β€” MySQL ERROR 1146 (42S02): Table 'db.table' doesn't exist (MySQL)11461054 β€” MySQL ERROR 1054 (42S22): Unknown column in 'field list' (MySQL)105442P01 β€” PostgreSQL: ERROR: relation "x" does not exist (PostgreSQL)42P0157014 β€” 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 queriesDeadlock β€” 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 timeout1205 β€” SQL Server Msg 1205: Transaction was deadlocked on lock resources and has been chosen as the deadlock victim (SQL)1205

Directly related (7)

Two steps away (21)

1062MySQL

MySQL ERROR 1062 (23000): Duplicate entry for key

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

SQLite NOT NULL failedSQL

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

A NULL went into a NOT NULL column in SQLite.

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.

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.

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.

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.

readonly databaseSQL

sqlite3.OperationalError: attempt to write a readonly database

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

ORA-01400SQL

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

A NULL was inserted into a NOT NULL column.

1146MySQL

MySQL ERROR 1146 (42S02): Table 'db.table' doesn't exist

The query references a table that MySQL can’t find in that database.

1054MySQL

MySQL ERROR 1054 (42S22): Unknown column in 'field list'

The query references a column that doesn’t exist in the table (or an unquoted string being read as a column).

42P01PostgreSQL

PostgreSQL: ERROR: relation "x" does not exist

The table/view isn’t found β€” missing migration, wrong schema, or a case-sensitive quoted name.

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.

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.

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.