Error map
22P02 ERROR: invalid input syntax for type integer: "abc"
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)
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.
ERROR: null value in column "x" of relation "y" violates not-null constraint
An INSERT/UPDATE put NULL into a NOT NULL column.
ERROR: value too long for type character varying(255)
A string exceeds the column’s varchar length.
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.
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: 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.
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…
MySQL ERROR 1690 (22003): BIGINT UNSIGNED value is out of range
Arithmetic on UNSIGNED columns produced a negative result.
Two steps away (34)
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.
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 1048 (23000): Column 'x' cannot be null
An INSERT/UPDATE put NULL into a NOT NULL column.
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.
ERROR: date/time field value out of range: "31/12/2024" — HINT: Perhaps you need a different "datestyle" setting.
PostgreSQL parsed a date in the wrong order (DMY vs MDY) or got an impossible value.
ERROR: malformed array literal: "x"
A value sent to an array column isn’t in PostgreSQL array syntax ({a,b}).
ERROR: column "x" is of type integer but expression is of type text — HINT: You will need to rewrite or cast the expression.
An INSERT/UPDATE supplies a value of a different type than the column, and PostgreSQL won’t cast implicitly.
SQL Server: Login failed for user 'x'. (Error 18456)
SQL Server rejected the login — wrong password, wrong authentication mode, or a disabled/missing login.
SQL Server: Invalid object name 'x'. (Msg 208)
The table/view doesn’t exist in the current database or schema.
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.
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.
ERROR: new row for relation "x" violates check constraint "y"
A value failed a CHECK constraint (e.g. price > 0, status IN (…)).
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: operator does not exist: integer = text
A comparison or operation mixes types PostgreSQL won’t implicitly convert.
SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115)
A value or calculation exceeds the target data type’s range.
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.
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.
java.lang.ArithmeticException: / by zero
Integer division or modulo by zero.
MySQL ERROR 1292 (22007): Incorrect datetime value: 'x' for column 'y'
A string couldn’t be converted to DATE/DATETIME — wrong format, empty string, or a zero date in strict mode.
Map another error
Popular: 4035004000xC000007BTypeErrorCritical error404NullPointerException