Error map
date format Dates mixed up: dd/mm/yyyy vs mm/dd/yyyy, ISO 8601 recommended
SQL · 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: 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.
perl: warning: Setting locale failed / bash: warning: setlocale: LC_ALL: cannot change locale
Your session asks for a locale (often forwarded by SSH from your Mac/PC) that isn’t generated on the server.
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.
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.
ORA-01861: literal does not match format string
A date/time string doesn't exactly match the format mask used to parse it.
NOT IN (subquery) returns no rows because the subquery contains NULL
If the list or subquery for NOT IN contains a single NULL, the whole condition is UNKNOWN and no rows come back.
Money/decimal values rounded wrongly: FLOAT precision and DECIMAL scale mistakes
Sums of FLOAT/REAL values drift (0.1 + 0.2 != 0.3), or a DECIMAL column rounds values you inserted.
Timestamps off by hours: timezone, UTC and DST conversion mistakes
Stored times appear shifted by 5 or 8 hours, or events shift around daylight saving changes.
LIKE matches too much: _ and % are wildcards (escape them)
Searching for text containing `_` or `%` returns unexpected rows because LIKE treats them as wildcards.
LIMIT/TOP without ORDER BY returns different rows each time
Without ORDER BY the database may return rows in any order, so "first 10" changes between runs or after maintenance.
Cannot truncate a table referenced by a FOREIGN KEY constraint
TRUNCATE is refused because another table has a foreign key pointing to it.
Two steps away (33)
RangeError: Invalid time value
A Date is invalid (NaN), and toISOString() or a formatting library couldn’t format it.
MySQL ERROR 1690 (22003): BIGINT UNSIGNED value is out of range
Arithmetic on UNSIGNED columns produced a negative result.
ERROR: invalid input syntax for type integer: "abc"
A string couldn’t be converted to the column’s type (integer, numeric, boolean, date…).
bash: command not found
The shell can’t find an executable with that name in any directory on your PATH.
ssh: connect to host x port 22: Connection refused
The server answered, but nothing is listening on the SSH port — sshd isn’t running, it uses another port, or a firewall actively…
ssh: connect to host x port 22: Connection timed out
SSH packets get no reply — a firewall/security group drops them, the server is off, or the IP is wrong.
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.
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…
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.
java.util.InputMismatchException (Scanner)
Scanner.nextInt()/nextDouble() read a token that isn’t that type.
ValueError: invalid literal for int() with base 10: 'abc'
int() received a string that isn’t a whole number — empty, decimal, whitespace or text.
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.
System.FormatException: Input string was not in a correct format
int.Parse/decimal.Parse/Convert.ToInt32 got a string that isn’t a valid number — empty, contains text, or uses another culture’s…
ORA-01843: not a valid month
A date string couldn't be parsed because the month part doesn't match the expected format.
ORA-00001: unique constraint (SCHEMA.PK_X) violated
An insert/update duplicated a value in a unique or primary key constraint.
ORA-01722: invalid number
Oracle tried to convert a string to a number and failed.
ORA-00018: maximum number of sessions exceeded
The database reached its SESSIONS limit, so no new connection can be created.
Subquery returns more than 1 row (MySQL 1242) / more than one row returned by a subquery used as an expression
A subquery used where a single value is expected (`= (SELECT …)`) returned several rows.
WHERE col = NULL returns no rows (use IS NULL)
Comparing anything to NULL with = or never matches, because the result is UNKNOWN, not true.
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.
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.
SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115)
A value or calculation exceeds the target data type’s range.
CASE expression returns mixed types: conversion failed / types cannot be matched
The branches of a CASE expression produce incompatible data types (text and number, date and string).
COUNT(column) ignores NULLs: counts differ from COUNT(*)
`COUNT(col)` counts only non-NULL values, while `COUNT(*)` counts rows, so totals don't match.
Too many values in an IN list / too many parameters (limit exceeded)
A huge `IN (...)` list or too many bound parameters exceeds a database limit.
Query slow because of an implicit type conversion or function on the column (index not used)
Comparing a column to a different type, or wrapping it in a function, stops the database using the index.
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.
ORDER BY items must appear in the select list if SELECT DISTINCT is specified
With DISTINCT, the database can only sort by columns that are part of the selected result.
Pagination gets slower on later pages (large OFFSET scans and discards rows)
`LIMIT 20 OFFSET 200000` reads and throws away 200,000 rows before returning the page.
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.
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.
Map another error
Popular: 500400403ORA-009331064Critical errorFileNotFoundException assemblyTypeError