Error map

2627 SQL Server: Violation of PRIMARY KEY constraint 'x'. Cannot insert duplicate key in object 'y'. (Msg 2627)

SQL · layer 5, Data

Open the full error page →

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

2627 — SQL Server: Violation of PRIMARY KEY constraint 'x'. Cannot insert duplicate key in object 'y'. (Msg 2627) (SQL)26271062 — MySQL ERROR 1062 (23000): Duplicate entry for key (MySQL)10628115 — 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)544ORA-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)DbUpdateExceptionSQLite UNIQUE failed — sqlite3.IntegrityError: UNIQUE constraint failed: users.email (SQL)SQLite UNIQUE failed245 — SQL Server: Conversion failed when converting the varchar value 'x' to data type int. (Msg 245) (SQL)245Execution Timeout Expired — SQL Server: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding. (SQL)Execution Timeout E…102 — SQL Server: Incorrect syntax near 'x'. (Msg 102) (SQL)102ALREADY_EXISTS — API Error: Resource already exists (ALREADY_EXISTS / resource_already_exists / 409) (API)ALREADY_EXISTScertificate chain not trusted — SQL Server: The certificate chain was issued by an authority that is not trusted. (SQL)certificate chain n…ORA-01400 — ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE"."COLUMN") (SQL)ORA-014001452 — MySQL ERROR 1452: Cannot add or update a child row: a foreign key constraint fails (MySQL)1452Deadlock — Deadlock found when trying to get lock; try restarting transaction (SQL)Deadlock409 — HTTP 409 Conflict (HTTP)40922003 — ERROR: numeric field overflow — A field with precision 5, scale 2 must round to an absolute value less than 10^3 (PostgreSQL)2200318456 — SQL Server: Login failed for user 'x'. (Error 18456) (SQL)18456208 — SQL Server: Invalid object name 'x'. (Msg 208) (SQL)208207 — SQL Server: Invalid column name 'x'. (Msg 207) (SQL)2078152 / 2628 — SQL Server: String or binary data would be truncated in table 'x', column 'y'. (Msg 2628) (SQL)8152 / 2628Network-related error — SQL Server: A network-related or instance-specific error occurred while establishing a connection to SQL Server. (provider: Named Pipes Provider, error: 40 / TCP Provider, error: 26) (SQL)Network-related err…SQLite 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-00942ORA-00904 — ORA-00904: "X": invalid identifier (SQL)ORA-00904JsonException object cycle — JsonException: A possible object cycle was detected (.NET)JsonException objec…23505 — PostgreSQL: ERROR: duplicate key value violates unique constraint (PostgreSQL)23505Hibernate ConstraintViolationException — org.hibernate.exception.ConstraintViolationException: could not execute statement (Java)Hibernate Constrain…readonly database — sqlite3.OperationalError: attempt to write a readonly database (SQL)readonly database22P02 — ERROR: invalid input syntax for type integer: "abc" (PostgreSQL)22P02547 — SQL Server: The INSERT statement conflicted with the FOREIGN KEY constraint 'x'. (Msg 547) (SQL)547ORA-01722 — ORA-01722: invalid number (SQL)ORA-01722Lock wait timeout — Lock wait timeout exceeded; try restarting transaction (MySQL 1205) (SQL)Lock wait timeout57014 — ERROR: canceling statement due to statement timeout (PostgreSQL)57014Endpoint request timed out — API Gateway: {"message": "Endpoint request timed out"} (504 after 29 seconds) (AWS)Endpoint request ti…1064 — 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 BY1022 — MySQL ERROR 1022 (23000): Can't write; duplicate key in table (MySQL)10221048 — MySQL ERROR 1048 (23000): Column 'x' cannot be null (MySQL)10481451 — MySQL ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (MySQL)1451CERTIFICATE_VERIFY_FAILED — SSL: CERTIFICATE_VERIFY_FAILED / unable to get local issuer certificate (API)CERTIFICATE_VERIFY_…tlsv1 alert protocol version — SSL error: tlsv1 alert protocol version / unsupported protocol / no protocols available (API)tlsv1 alert protoco…Pending validation — ACM certificate stuck in Pending validation (AWS)Pending validation23502 — ERROR: null value in column "x" of relation "y" violates not-null constraint (PostgreSQL)23502ORA-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-00054

Directly related (12)

1062MySQL

MySQL ERROR 1062 (23000): Duplicate entry for key

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

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.

ORA-00001SQL

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

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

DbUpdateException.NET

DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details.

SaveChanges failed in the database; the inner exception (SqlException/PostgresException) has the real reason — constraint violati…

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.

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.

Execution Timeout ExpiredSQL

SQL Server: Execution Timeout Expired. The timeout period elapsed prior to completion of the operation or the server is not responding.

The command ran longer than the client’s CommandTimeout (default 30 seconds).

102SQL

SQL Server: Incorrect syntax near 'x'. (Msg 102)

T-SQL couldn’t parse the statement near the shown token.

ALREADY_EXISTSAPI

API Error: Resource already exists (ALREADY_EXISTS / resource_already_exists / 409)

The create request was refused because an object with the same unique identity — name, email, external ID — already exists.

certificate chain not trustedSQL

SQL Server: The certificate chain was issued by an authority that is not trusted.

The client requires an encrypted connection and doesn’t trust SQL Server’s (often self-signed) certificate.

ORA-01400SQL

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

A NULL was inserted into a NOT NULL column.

Two steps away (34)

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.

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.

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.

22003PostgreSQL

ERROR: numeric field overflow — A field with precision 5, scale 2 must round to an absolute value less than 10^3

A number doesn’t fit the column’s numeric(precision, scale) or integer range.

18456SQL

SQL Server: Login failed for user 'x'. (Error 18456)

SQL Server rejected the login — wrong password, wrong authentication mode, or a disabled/missing login.

208SQL

SQL Server: Invalid object name 'x'. (Msg 208)

The table/view doesn’t exist in the current database or schema.

207SQL

SQL Server: Invalid column name 'x'. (Msg 207)

SQL Server can’t find the column — typo, missing migration, or a string in double quotes with QUOTED_IDENTIFIER ON.

8152 / 2628SQL

SQL Server: String or binary data would be truncated in table 'x', column 'y'. (Msg 2628)

A value is longer than the column allows.

Network-related errorSQL

SQL Server: A network-related or instance-specific error occurred while establishing a connection to SQL Server. (provider: Named Pipes Provider, error: 40 / TCP Provider, error: 26)

The client couldn’t reach the SQL Server instance — wrong server name/instance, TCP disabled, firewall, or SQL Browser not runnin…

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.

ORA-00904SQL

ORA-00904: "X": invalid identifier

A column name in the statement doesn’t exist (or is misquoted).

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.

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

readonly databaseSQL

sqlite3.OperationalError: attempt to write a readonly database

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

22P02PostgreSQL

ERROR: invalid input syntax for type integer: "abc"

A string couldn’t be converted to the column’s type (integer, numeric, boolean, date…).

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

ORA-01722SQL

ORA-01722: invalid number

Oracle tried to convert a string to a number and failed.

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.

57014PostgreSQL

ERROR: canceling statement due to statement timeout

A query ran longer than statement_timeout and PostgreSQL cancelled it.

Endpoint request timed outAWS

API Gateway: {"message": "Endpoint request timed out"} (504 after 29 seconds)

The backend (usually Lambda) didn’t respond within API Gateway’s integration timeout (29 seconds by default for REST APIs).

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.

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.

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.

CERTIFICATE_VERIFY_FAILEDAPI

SSL: CERTIFICATE_VERIFY_FAILED / unable to get local issuer certificate

The client couldn’t verify the server’s TLS certificate chain, so it refused the HTTPS connection.

tlsv1 alert protocol versionAPI

SSL error: tlsv1 alert protocol version / unsupported protocol / no protocols available

The client and server couldn’t agree on a TLS version or cipher, so the HTTPS handshake failed before any HTTP was exchanged.

Pending validationAWS

ACM certificate stuck in Pending validation

ACM is waiting to see the DNS (or email) validation record — it wasn’t created, was created in the wrong DNS zone, or has a typo.

23502PostgreSQL

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

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

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.