Error map
23514 ERROR: new row for relation "x" violates check constraint "y"
PostgreSQL · layer 5, Data
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.
Directly related (12)
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.
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.
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: 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…
ERROR: null value in column "x" of relation "y" violates not-null constraint
An INSERT/UPDATE put NULL into a NOT NULL column.
ERROR: invalid input syntax for type integer: "abc"
A string couldn’t be converted to the column’s type (integer, numeric, boolean, date…).
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…
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 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.
MongoDB: MongoServerError: Document failed validation (code 121)
The collection has a JSON Schema validator and the inserted/updated document doesn’t satisfy it.
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.
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…
Two steps away (35)
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.
MySQL ERROR 1093 (HY000): You can't specify target table 'x' for update in FROM clause
An UPDATE/DELETE uses a subquery that reads from the same table, which MySQL doesn’t allow directly.
MySQL ERROR 1175 (HY000): You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column
MySQL Workbench’s safe updates mode blocked an UPDATE/DELETE without a key-based WHERE.
HTTP 422 Unprocessable Content
The request is well-formed, but the data fails validation (e.g. invalid email, missing required field).
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…
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.
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.
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: 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.
MySQL ERROR 1062 (23000): Duplicate entry for key
An INSERT/UPDATE would create a duplicate value in a PRIMARY or UNIQUE key.
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: 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…
MySQL ERROR 1048 (23000): Column 'x' cannot be null
An INSERT/UPDATE put NULL into a NOT NULL column.
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.
sqlite3.IntegrityError: NOT NULL constraint failed: table.column
A NULL went into a NOT NULL column in SQLite.
MySQL ERROR 1690 (22003): BIGINT UNSIGNED value is out of range
Arithmetic on UNSIGNED columns produced a negative result.
ERROR: value too long for type character varying(255)
A string exceeds the column’s varchar length.
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.
HTTP 400 Bad Request
The server could not understand the request because its syntax, headers or body are malformed or invalid.
java.lang.IllegalArgumentException
A method rejected an argument value as invalid.
MethodArgumentNotValidException: Validation failed for argument [0]
Bean Validation (@Valid with @NotNull, @Email, @Size…) rejected the request body.
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.
java.text.ParseException: Unparseable date: "x"
SimpleDateFormat couldn’t parse the string with its pattern.
RangeError: Invalid time value
A Date is invalid (NaN), and toISOString() or a formatting library couldn’t format it.
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).
ValidationError: User validation failed: email: Path `email` is required.
A document failed Mongoose schema validation before saving.
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.
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.
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.
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.
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…
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.
API Error: Invalid ID format (not a valid UUID / malformed identifier)
An ID in the URL or body doesn’t have the shape the API expects — a malformed UUID, wrong prefix, or an ID mangled by encoding or…
Map another error
Popular: 4035004000xC000007BTypeErrorCritical error404NullPointerException