Error map

sorting Numbers sort wrongly (1, 10, 2): VARCHAR column sorted as text

SQL · layer 5, Data

Open the full error page →

Centre: this error. First ring: errors it is linked with (8). 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.

sorting — Numbers sort wrongly (1, 10, 2): VARCHAR column sorted as text (SQL)sorting22P02 — ERROR: invalid input syntax for type integer: "abc" (PostgreSQL)22P02cartesian — Query returns far too many rows: accidental Cartesian product (missing JOIN condition) (SQL)cartesianCASE — CASE expression returns mixed types: conversion failed / types cannot be matched (SQL)CASEinteger division — 5 / 2 = 2: integer division silently truncates the result (SQL)integer divisionCOUNT — COUNT(column) ignores NULLs: counts differ from COUNT(*) (SQL)COUNTimplicit conversion — Query slow because of an implicit type conversion or function on the column (index not used) (SQL)implicit conversion8114 — SQL Server Msg 8114: Error converting data type varchar to numeric (SQL)8114GROUP_CONCAT — GROUP_CONCAT / STRING_AGG result truncated or fails (group_concat_max_len, string length limit) (SQL)GROUP_CONCAT1264 — 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)13661690 — MySQL ERROR 1690 (22003): BIGINT UNSIGNED value is out of range (MySQL)169057014 — ERROR: canceling statement due to statement timeout (PostgreSQL)57014out of shared memory — ERROR: out of shared memory — HINT: You might need to increase max_locks_per_transaction. (PostgreSQL)out of shared memoryN+1 queries — Performance: N+1 query problem (one query per row in a loop) (SQL)N+1 queriesAttributeError — AttributeError: 'X' object has no attribute 'y' (Python)AttributeErrorClassCastException — java.lang.ClassCastException: class A cannot be cast to class B (Java)ClassCastExceptionERR_INVALID_ARG_TYPE — TypeError [ERR_INVALID_ARG_TYPE]: The "path" argument must be of type string. Received undefined (Node.js)ERR_INVALID_ARG_TYPEDivision by zero — SQL Error: division by zero / Divide by zero error encountered (SQL)Division by zeroTS7016 — TS7016: Could not find a declaration file for module 'x'. 'x.js' implicitly has an 'any' type. (Node.js)TS7016TS2304 — TS2304: Cannot find name 'x'. (Node.js)TS2304aggregate in WHERE — ERROR: aggregate functions are not allowed in WHERE (use HAVING) / MySQL 1111 Invalid use of group function (SQL)aggregate in WHERE= NULL — WHERE col = NULL returns no rows (use IS NULL) (SQL)= NULLNOT IN — NOT IN (subquery) returns no rows because the subquery contains NULL (SQL)NOT IN1267 — MySQL ERROR 1267 (HY000): Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '=' (SQL)1267pool timeout — Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. All pooled connections were in use and max pool size was reached. (SQL)pool timeoutOutOfMemoryException — System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown (.NET)OutOfMemoryException245 — SQL Server: Conversion failed when converting the varchar value 'x' to data type int. (Msg 245) (SQL)2458115 — SQL Server: Arithmetic overflow error converting expression to data type int. (Msg 8115) (SQL)8115242 — SQL Server Msg 242: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value (SQL)2421406 — MySQL ERROR 1406: Data too long for column (MySQL)1406date format — Dates mixed up: dd/mm/yyyy vs mm/dd/yyyy, ISO 8601 recommended (SQL)date format

Directly related (8)

Two steps away (23)

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.

1690MySQL

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

Arithmetic on UNSIGNED columns produced a negative result.

57014PostgreSQL

ERROR: canceling statement due to statement timeout

A query ran longer than statement_timeout and PostgreSQL cancelled it.

out of shared memoryPostgreSQL

ERROR: out of shared memory — HINT: You might need to increase max_locks_per_transaction.

A transaction took more locks than the lock table can hold — usually touching many tables/partitions at once.

N+1 queriesSQL

Performance: N+1 query problem (one query per row in a loop)

Code runs one query to load a list, then one more query per item — hundreds of queries per page.

AttributeErrorPython

AttributeError: 'X' object has no attribute 'y'

You accessed an attribute or method that doesn’t exist on that object type.

ClassCastExceptionJava

java.lang.ClassCastException: class A cannot be cast to class B

An object was cast to a type it isn’t.

ERR_INVALID_ARG_TYPENode.js

TypeError [ERR_INVALID_ARG_TYPE]: The "path" argument must be of type string. Received undefined

A Node API got an argument of the wrong type — usually undefined because an env var or config value is missing.

Division by zeroSQL

SQL Error: division by zero / Divide by zero error encountered

An expression divided by a value that was 0 for at least one row.

TS7016Node.js

TS7016: Could not find a declaration file for module 'x'. 'x.js' implicitly has an 'any' type.

The JavaScript package has no TypeScript types bundled and no @types package installed.

TS2304Node.js

TS2304: Cannot find name 'x'.

TypeScript doesn’t know an identifier — a missing import, missing type definitions (e.g. for Node or Jest globals), or a typo.

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.

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

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.

1267SQL

MySQL ERROR 1267 (HY000): Illegal mix of collations (utf8mb4_unicode_ci,IMPLICIT) and (utf8mb4_0900_ai_ci,IMPLICIT) for operation '='

Two strings with different collations were compared or joined.

pool timeoutSQL

Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. All pooled connections were in use and max pool size was reached.

The application’s connection pool was exhausted — all connections busy or leaked.

OutOfMemoryException.NET

System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown

The process couldn’t allocate memory — large in-memory data, leaks, 32-bit process limits, or container memory limits.

245SQL

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.

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.

242SQL

SQL Server Msg 242: The conversion of a varchar data type to a datetime data type resulted in an out-of-range value

A date string couldn't be converted because it's invalid or in the wrong format for the session language.

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…

date formatSQL

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

A date string like 03/04/2026 is read as March 4th or April 3rd depending on locale, so rows get wrong dates or conversion errors.