Error map

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

PostgreSQL · 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.

23502 — ERROR: null value in column "x" of relation "y" violates not-null constraint (PostgreSQL)23502unknown field — strict decoding error: unknown field "spec.template.spec.containers[0].ports[0].protocl" (Kubernetes)unknown field22P02 uuid — ERROR: invalid input syntax for type uuid: "x" (PostgreSQL)22P02 uuidDbUpdateException — DbUpdateException: An error occurred while saving the entity changes. See the inner exception for details. (.NET)DbUpdateException22P02 — ERROR: invalid input syntax for type integer: "abc" (PostgreSQL)22P02invalid_type — API Error: Invalid type — expected integer, received string (API)invalid_typeinvalid_date — API Error: Invalid date format — expected ISO 8601 (YYYY-MM-DDTHH:mm:ssZ) (API)invalid_dateerror converting YAML to JSON — error converting YAML to JSON: yaml: line 12: did not find expected key (Kubernetes)error converting YA…Document failed validation — MongoDB: MongoServerError: Document failed validation (code 121) (MongoDB)Document failed val…23503 — ERROR: insert or update on table "x" violates foreign key constraint "fk" — Key (user_id)=(5) is not present in table "users" (PostgreSQL)23503invalid_value — API Error: Invalid parameter value — must be one of the allowed values / out of range (API)invalid_value23505 — PostgreSQL: ERROR: duplicate key value violates unique constraint (PostgreSQL)2350523503 parent — ERROR: update or delete on table "users" violates foreign key constraint on table "orders" — Key (id)=(5) is still referenced (PostgreSQL)23503 parent422 — HTTP 422 Unprocessable Content (HTTP)4221406 — MySQL ERROR 1406: Data too long for column (MySQL)1406NumberFormatException — java.lang.NumberFormatException: For input string: "x" (Java)NumberFormatExcepti…1264 — MySQL ERROR 1264 (22003): Out of range value for column 'x' at row 1 (MySQL)12641366 — MySQL ERROR 1366 (HY000): Incorrect integer value: '' for column 'x' at row 1 (MySQL)1366CastError ObjectId — CastError: Cast to ObjectId failed for value "x" (type string) at path "_id" (Node.js)CastError ObjectId1062 — MySQL ERROR 1062 (23000): Duplicate entry for key (MySQL)10621452 — MySQL ERROR 1452: Cannot add or update a child row: a foreign key constraint fails (MySQL)1452JsonException object cycle — JsonException: A possible object cycle was detected (.NET)JsonException objec…1690 — MySQL ERROR 1690 (22003): BIGINT UNSIGNED value is out of range (MySQL)169023514 — ERROR: new row for relation "x" violates check constraint "y" (PostgreSQL)2351422001 — ERROR: value too long for type character varying(255) (PostgreSQL)22001400 — HTTP 400 Bad Request (HTTP)400IllegalArgumentException — java.lang.IllegalArgumentException (Java)IllegalArgumentExce…MethodArgumentNotValidException — MethodArgumentNotValidException: Validation failed for argument [0] (Java)MethodArgumentNotVa…DateTimeParseException — java.time.format.DateTimeParseException: Text '31/12/2024' could not be parsed at index 2 (Java)DateTimeParseExcept…Unparseable date — java.text.ParseException: Unparseable date: "x" (Java)Unparseable dateinvalid time value — RangeError: Invalid time value (JavaScript)invalid time valuecompose validation — docker compose: services.x Additional property y is not allowed / yaml: line N: mapping values are not allowed (Docker)compose validation1048 — MySQL ERROR 1048 (23000): Column 'x' cannot be null (MySQL)1048Mongoose ValidationError — ValidationError: User validation failed: email: Path `email` is required. (Node.js)Mongoose Validation…1146 — 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)42P011451 — MySQL ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails (MySQL)145142P10 — ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification (PostgreSQL)42P10ALREADY_EXISTS — API Error: Resource already exists (ALREADY_EXISTS / resource_already_exists / 409) (API)ALREADY_EXISTSPydantic ValidationError — pydantic_core._pydantic_core.ValidationError: 1 validation error for Model (Python)Pydantic Validation…parameter_missing — API Error: Missing required parameter (parameter_missing / "x" is required) (API)parameter_missingadditionalProperties — API Error: Request failed schema validation (must NOT have additional properties / Additional properties are not allowed) (API)additionalProperties409 — HTTP 409 Conflict (HTTP)409Hibernate ConstraintViolationException — org.hibernate.exception.ConstraintViolationException: could not execute statement (Java)Hibernate Constrain…E11000 duplicate key — MongoServerError: E11000 duplicate key error collection: db.users index: email_1 dup key (Node.js)E11000 duplicate key

Directly related (12)

unknown fieldKubernetes

strict decoding error: unknown field "spec.template.spec.containers[0].ports[0].protocl"

The manifest contains a field the API schema doesn’t know — a typo, wrong indentation, or a field from another API version.

22P02 uuidPostgreSQL

ERROR: invalid input syntax for type uuid: "x"

A value that isn’t a valid UUID was compared with or inserted into a uuid column.

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…

22P02PostgreSQL

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

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

invalid_typeAPI

API Error: Invalid type — expected integer, received string

A request field has the wrong data type — a string where the API expects a number, a number where it expects a boolean, an object…

invalid_dateAPI

API Error: Invalid date format — expected ISO 8601 (YYYY-MM-DDTHH:mm:ssZ)

A date or timestamp in the request isn’t in the format the API expects — usually ISO 8601 with a time zone, or a Unix timestamp.

error converting YAML to JSONKubernetes

error converting YAML to JSON: yaml: line 12: did not find expected key

The manifest isn’t valid YAML — usually indentation, a tab character, or an unquoted special character.

Document failed validationMongoDB

MongoDB: MongoServerError: Document failed validation (code 121)

The collection has a JSON Schema validator and the inserted/updated document doesn’t satisfy 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.

invalid_valueAPI

API Error: Invalid parameter value — must be one of the allowed values / out of range

The field has the right type but a value the API doesn’t allow — not in the list of accepted options, too small or large, too lon…

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.

23503 parentPostgreSQL

ERROR: update or delete on table "users" violates foreign key constraint on table "orders" — Key (id)=(5) is still referenced

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

Two steps away (33)

422HTTP

HTTP 422 Unprocessable Content

The request is well-formed, but the data fails validation (e.g. invalid email, missing required field).

1406MySQL

MySQL ERROR 1406: Data too long for column

The value is longer than the column allows (e.g. 300 characters into VARCHAR(255)), and strict mode rejects it instead of truncat…

NumberFormatExceptionJava

java.lang.NumberFormatException: For input string: "x"

A string couldn’t be parsed as a number — it’s empty, has spaces/commas, is too large, or isn’t numeric.

1264MySQL

MySQL ERROR 1264 (22003): Out of range value for column 'x' at row 1

A number is too large (or negative for UNSIGNED) for the column type.

1366MySQL

MySQL ERROR 1366 (HY000): Incorrect integer value: '' for column 'x' at row 1

An empty string or non-numeric text was inserted into an INT column under strict mode.

CastError ObjectIdNode.js

CastError: Cast to ObjectId failed for value "x" (type string) at path "_id"

A value that isn’t a valid 24-hex-character ObjectId was used in an _id query.

1062MySQL

MySQL ERROR 1062 (23000): Duplicate entry for key

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

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.

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…

1690MySQL

MySQL ERROR 1690 (22003): BIGINT UNSIGNED value is out of range

Arithmetic on UNSIGNED columns produced a negative result.

23514PostgreSQL

ERROR: new row for relation "x" violates check constraint "y"

A value failed a CHECK constraint (e.g. price > 0, status IN (…)).

22001PostgreSQL

ERROR: value too long for type character varying(255)

A string exceeds the column’s varchar length.

400HTTP

HTTP 400 Bad Request

The server could not understand the request because its syntax, headers or body are malformed or invalid.

IllegalArgumentExceptionJava

java.lang.IllegalArgumentException

A method rejected an argument value as invalid.

MethodArgumentNotValidExceptionJava

MethodArgumentNotValidException: Validation failed for argument [0]

Bean Validation (@Valid with @NotNull, @Email, @Size…) rejected the request body.

DateTimeParseExceptionJava

java.time.format.DateTimeParseException: Text '31/12/2024' could not be parsed at index 2

A java.time parse call got text that doesn’t match the expected format.

Unparseable dateJava

java.text.ParseException: Unparseable date: "x"

SimpleDateFormat couldn’t parse the string with its pattern.

invalid time valueJavaScript

RangeError: Invalid time value

A Date is invalid (NaN), and toISOString() or a formatting library couldn’t format it.

compose validationDocker

docker compose: services.x Additional property y is not allowed / yaml: line N: mapping values are not allowed

The compose file is invalid YAML or uses a key Compose doesn’t recognise at that level (usually an indentation mistake).

1048MySQL

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

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

Mongoose ValidationErrorNode.js

ValidationError: User validation failed: email: Path `email` is required.

A document failed Mongoose schema validation before saving.

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.

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.

42P10PostgreSQL

ERROR: there is no unique or exclusion constraint matching the ON CONFLICT specification

INSERT … ON CONFLICT (cols) names columns that don’t have a matching unique index/constraint.

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.

Pydantic ValidationErrorPython

pydantic_core._pydantic_core.ValidationError: 1 validation error for Model

Data didn’t match a Pydantic model — a field is missing, has the wrong type, or fails a constraint.

parameter_missingAPI

API Error: Missing required parameter (parameter_missing / "x" is required)

The API rejected the request because a field it requires — in the query string, path, headers or JSON body — wasn’t sent or was e…

additionalPropertiesAPI

API Error: Request failed schema validation (must NOT have additional properties / Additional properties are not allowed)

The JSON body doesn’t match the endpoint’s schema — an unknown property, wrong nesting, or a missing required object.

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.

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

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.