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
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.
Directly related (7)
ORA-00001: unique constraint (SCHEMA.PK_X) violated
An insert/update duplicated a value in a unique or primary key constraint.
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.
ERROR: aggregate functions are not allowed in WHERE (use HAVING) / MySQL 1111 Invalid use of group function
An aggregate (SUM, COUNT, AVG) was used in WHERE, which filters rows before grouping.
sqlite3.IntegrityError: UNIQUE constraint failed: users.email
An insert/update duplicated a value in a UNIQUE or PRIMARY KEY column in SQLite.
Db2 SQL0204N: "SCHEMA.TABLE" is an undefined name (SQLSTATE 42704)
Db2 can't find the table, view or other object, or the schema qualifier is wrong.
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.
Db2 SQL0911N: The current transaction has been rolled back because of a deadlock or timeout (reason code 68)
Db2 rolled the transaction back because it hit a lock timeout (68) or a deadlock (2).
Two steps away (21)
MySQL ERROR 1062 (23000): Duplicate entry for key
An INSERT/UPDATE would create a duplicate value in a PRIMARY or UNIQUE key.
sqlite3.IntegrityError: NOT NULL constraint failed: table.column
A NULL went into a NOT NULL column in SQLite.
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.
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.
SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115)
A value or calculation exceeds the target data typeβs range.
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.
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.
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.
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.
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.
sqlite3.OperationalError: attempt to write a readonly database
The process canβt write to the SQLite file or its directory.
ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE"."COLUMN")
A NULL was inserted into a NOT NULL column.
MySQL ERROR 1146 (42S02): Table 'db.table' doesn't exist
The query references a table that MySQL canβt find in that database.
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).
PostgreSQL: ERROR: relation "x" does not exist
The table/view isnβt found β missing migration, wrong schema, or a case-sensitive quoted name.
ERROR: canceling statement due to statement timeout
A query ran longer than statement_timeout and PostgreSQL cancelled it.
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.
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.
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 timeout exceeded; try restarting transaction (MySQL 1205)
A query waited too long for a row lock held by another transaction and gave up.
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.
Map another error
Popular: 500400403ORA-009331064Critical errorFileNotFoundException assemblyTypeError