Error map

date format Dates mixed up: dd/mm/yyyy vs mm/dd/yyyy, ISO 8601 recommended

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.

date format — Dates mixed up: dd/mm/yyyy vs mm/dd/yyyy, ISO 8601 recommended (SQL)date format22008 — ERROR: date/time field value out of range: "31/12/2024" — HINT: Perhaps you need a different "datestyle" setting. (PostgreSQL)22008Setting locale failed — perl: warning: Setting locale failed / bash: warning: setlocale: LC_ALL: cannot change locale (Linux)Setting locale fail…1292 — MySQL ERROR 1292 (22007): Incorrect datetime value: 'x' for column 'y' (MySQL)1292DateTimeParseException — 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 dateORA-01861 — ORA-01861: literal does not match format string (SQL)ORA-01861NOT IN — NOT IN (subquery) returns no rows because the subquery contains NULL (SQL)NOT INDECIMAL — Money/decimal values rounded wrongly: FLOAT precision and DECIMAL scale mistakes (SQL)DECIMALtimezone — Timestamps off by hours: timezone, UTC and DST conversion mistakes (SQL)timezoneLIKE — LIKE matches too much: _ and % are wildcards (escape them) (SQL)LIKELIMIT — LIMIT/TOP without ORDER BY returns different rows each time (SQL)LIMITTRUNCATE — Cannot truncate a table referenced by a FOREIGN KEY constraint (SQL)TRUNCATEinvalid time value — RangeError: Invalid time value (JavaScript)invalid time value1690 — MySQL ERROR 1690 (22003): BIGINT UNSIGNED value is out of range (MySQL)169022P02 — ERROR: invalid input syntax for type integer: "abc" (PostgreSQL)22P02command not found — bash: command not found (Linux)command not foundssh port 22 Connection refused — ssh: connect to host x port 22: Connection refused (Linux)ssh port 22 Connect…ssh port 22 Connection timed out — ssh: connect to host x port 22: Connection timed out (Linux)ssh port 22 Connect…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)1366invalid_type — API Error: Invalid type — expected integer, received string (API)invalid_typeNumberFormatException — java.lang.NumberFormatException: For input string: "x" (Java)NumberFormatExcepti…InputMismatchException — java.util.InputMismatchException (Scanner) (Java)InputMismatchExcept…ValueError — ValueError: invalid literal for int() with base 10: 'abc' (Python)ValueErrorinvalid_date — API Error: Invalid date format — expected ISO 8601 (YYYY-MM-DDTHH:mm:ssZ) (API)invalid_dateInput string was not in a correct format — System.FormatException: Input string was not in a correct format (.NET)Input string was no…ORA-01843 — ORA-01843: not a valid month (SQL)ORA-01843ORA-00001 — ORA-00001: unique constraint (SCHEMA.PK_X) violated (SQL)ORA-00001ORA-01722 — ORA-01722: invalid number (SQL)ORA-01722ORA-00018 — ORA-00018: maximum number of sessions exceeded (SQL)ORA-00018Subquery returns more than 1 row — Subquery returns more than 1 row (MySQL 1242) / more than one row returned by a subquery used as an expression (SQL)Subquery returns mo…= NULL — WHERE col = NULL returns no rows (use IS NULL) (SQL)= NULLcartesian — Query returns far too many rows: accidental Cartesian product (missing JOIN condition) (SQL)cartesian22003 — ERROR: numeric field overflow — A field with precision 5, scale 2 must round to an absolute value less than 10^3 (PostgreSQL)220038115 — SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115) (SQL)8115CASE — CASE expression returns mixed types: conversion failed / types cannot be matched (SQL)CASECOUNT — COUNT(column) ignores NULLs: counts differ from COUNT(*) (SQL)COUNTIN list — Too many values in an IN list / too many parameters (limit exceeded) (SQL)IN listimplicit conversion — Query slow because of an implicit type conversion or function on the column (index not used) (SQL)implicit conversionaggregate in WHERE — ERROR: aggregate functions are not allowed in WHERE (use HAVING) / MySQL 1111 Invalid use of group function (SQL)aggregate in WHEREORDER BY with DISTINCT — ORDER BY items must appear in the select list if SELECT DISTINCT is specified (SQL)ORDER BY with DISTI…OFFSET — Pagination gets slower on later pages (large OFFSET scans and discards rows) (SQL)OFFSET1062 — 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)145223505 — PostgreSQL: ERROR: duplicate key value violates unique constraint (PostgreSQL)23505

Directly related (12)

22008PostgreSQL

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.

Setting locale failedLinux

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.

1292MySQL

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.

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.

ORA-01861SQL

ORA-01861: literal does not match format string

A date/time string doesn't exactly match the format mask used to parse it.

NOT INSQL

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.

DECIMALSQL

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.

timezoneSQL

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.

LIKESQL

LIKE matches too much: _ and % are wildcards (escape them)

Searching for text containing `_` or `%` returns unexpected rows because LIKE treats them as wildcards.

LIMITSQL

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.

TRUNCATESQL

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)

invalid time valueJavaScript

RangeError: Invalid time value

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

1690MySQL

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

Arithmetic on UNSIGNED columns produced a negative result.

22P02PostgreSQL

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

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

command not foundLinux

bash: command not found

The shell can’t find an executable with that name in any directory on your PATH.

ssh port 22 Connection refusedLinux

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 port 22 Connection timed outLinux

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.

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.

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…

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.

InputMismatchExceptionJava

java.util.InputMismatchException (Scanner)

Scanner.nextInt()/nextDouble() read a token that isn’t that type.

ValueErrorPython

ValueError: invalid literal for int() with base 10: 'abc'

int() received a string that isn’t a whole number — empty, decimal, whitespace or text.

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.

Input string was not in a correct format.NET

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-01843SQL

ORA-01843: not a valid month

A date string couldn't be parsed because the month part doesn't match the expected format.

ORA-00001SQL

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

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

ORA-01722SQL

ORA-01722: invalid number

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

ORA-00018SQL

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 rowSQL

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.

= NULLSQL

WHERE col = NULL returns no rows (use IS NULL)

Comparing anything to NULL with = or never matches, because the result is UNKNOWN, not true.

cartesianSQL

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.

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.

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.

CASESQL

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

COUNTSQL

COUNT(column) ignores NULLs: counts differ from COUNT(*)

`COUNT(col)` counts only non-NULL values, while `COUNT(*)` counts rows, so totals don't match.

IN listSQL

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.

implicit conversionSQL

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.

aggregate in WHERESQL

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 with DISTINCTSQL

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.

OFFSETSQL

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.

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.

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.