Error map

implicit conversion Query slow because of an implicit type conversion or function on the column (index not used)

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.

implicit conversion — Query slow because of an implicit type conversion or function on the column (index not used) (SQL)implicit co…1267 — 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 timeout57014 — ERROR: canceling statement due to statement timeout (PostgreSQL)57014N+1 queries — Performance: N+1 query problem (one query per row in a loop) (SQL)N+1 queriesout of shared memory — ERROR: out of shared memory — HINT: You might need to increase max_locks_per_transaction. (PostgreSQL)out of shared memoryOutOfMemoryException — System.OutOfMemoryException: Exception of type 'System.OutOfMemoryException' was thrown (.NET)OutOfMemoryExceptionLIKE — LIKE matches too much: _ and % are wildcards (escape them) (SQL)LIKEsorting — Numbers sort wrongly (1, 10, 2): VARCHAR column sorted as text (SQL)sortingcartesian — 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)CASEdate format — Dates mixed up: dd/mm/yyyy vs mm/dd/yyyy, ISO 8601 recommended (SQL)date formatOFFSET — Pagination gets slower on later pages (large OFFSET scans and discards rows) (SQL)OFFSETambiguous column — Column reference is ambiguous / Column 'id' in field list is ambiguous (MySQL 1052) (SQL)ambiguous column1366 — MySQL ERROR 1366: Incorrect string value: '\xF0\x9F\x98\x80' for column (MySQL)13661071 — MySQL ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes (MySQL)1071504 — HTTP 504 Gateway Timeout (HTTP)504524 — Cloudflare Error 524: A Timeout Occurred (Cloudflare)524304 — HTTP 304 Not Modified (HTTP)304ETIMEDOUT — API Request Timed Out (ETIMEDOUT / ReadTimeout / timeout of 30000ms exceeded) (API)ETIMEDOUTLock wait timeout — Lock wait timeout exceeded; try restarting transaction (MySQL 1205) (SQL)Lock wait timeoutTask timed out — AWS Lambda: Task timed out after X seconds (AWS)Task timed outLazyInitializationException — org.hibernate.LazyInitializationException: could not initialize proxy - no Session (Java)LazyInitializationE…TransientObjectException — org.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing (Java)TransientObjectExce…Hibernate ConstraintViolationException — org.hibernate.exception.ConstraintViolationException: could not execute statement (Java)Hibernate Constrain…redirect_uri_mismatch — OAuth Error: redirect_uri_mismatch (Authentication)redirect_uri_mismat…divergent branches — hint: You have divergent branches and need to specify how to reconcile them. (Git)divergent branchesLF/CRLF warning — warning: in the working copy of 'x', LF will be replaced by CRLF the next time Git touches it (Git)LF/CRLF warningOOMKilled — Kubernetes: OOMKilled (exit code 137) (Kubernetes)OOMKilledOutOfMemoryError — java.lang.OutOfMemoryError: Java heap space (Java)OutOfMemoryErrorMEMORY_MANAGEMENT — Blue Screen: MEMORY_MANAGEMENT (Stop code 0x0000001A) (Windows)MEMORY_MANAGEMENT22P02 — ERROR: invalid input syntax for type integer: "abc" (PostgreSQL)22P02IN list — Too many values in an IN list / too many parameters (limit exceeded) (SQL)IN listCOUNT — COUNT(column) ignores NULLs: counts differ from COUNT(*) (SQL)COUNTinteger division — 5 / 2 = 2: integer division silently truncates the result (SQL)integer division8114 — 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_CONCAT= 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 INORDER BY with DISTINCT — ORDER BY items must appear in the select list if SELECT DISTINCT is specified (SQL)ORDER BY with DISTI…AttributeError — 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_TYPEDateTimeParseException — 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 date1292 — MySQL ERROR 1292 (22007): Incorrect datetime value: 'x' for column 'y' (MySQL)1292LIMIT — LIMIT/TOP without ORDER BY returns different rows each time (SQL)LIMIThotspotting — Firestore write latency/errors: hotspotting from sequential document IDs or indexed fields (Google Cloud / Firebase)hotspottingindexOn — Realtime Database: Using an unspecified index — consider adding ".indexOn" to your security rules (Google Cloud / Firebase)indexOn

Directly related (12)

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.

57014PostgreSQL

ERROR: canceling statement due to statement timeout

A query ran longer than statement_timeout and PostgreSQL cancelled it.

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.

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.

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.

LIKESQL

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

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

sortingSQL

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

A numeric-looking column stored as text sorts alphabetically, so "10" comes before "2".

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.

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

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.

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.

Two steps away (36)

ambiguous columnSQL

Column reference is ambiguous / Column 'id' in field list is ambiguous (MySQL 1052)

A column name exists in more than one joined table, so the database doesn’t know which one you mean.

1366MySQL

MySQL ERROR 1366: Incorrect string value: '\xF0\x9F\x98\x80' for column

The text contains characters (usually emoji) that the column’s character set can’t store — the column or connection is `utf8`/`ut…

1071MySQL

MySQL ERROR 1071 (42000): Specified key was too long; max key length is 767 bytes

An index on a VARCHAR is too long for the row format — classic with utf8mb4 VARCHAR(255) on MySQL 5.6/MariaDB 10.1.

504HTTP

HTTP 504 Gateway Timeout

A proxy or gateway waited too long for the upstream server to respond and gave up.

524Cloudflare

Cloudflare Error 524: A Timeout Occurred

Cloudflare connected to the origin, but the origin didn’t send an HTTP response within 100 seconds.

304HTTP

HTTP 304 Not Modified

The cached copy is still valid, so the server sends no body and the client reuses its cache.

ETIMEDOUTAPI

API Request Timed Out (ETIMEDOUT / ReadTimeout / timeout of 30000ms exceeded)

The client gave up waiting — either for the connection to open or for the response to arrive.

Lock wait timeoutSQL

Lock wait timeout exceeded; try restarting transaction (MySQL 1205)

A query waited too long for a row lock held by another transaction and gave up.

Task timed outAWS

AWS Lambda: Task timed out after X seconds

The function ran longer than its configured timeout (default 3 seconds) and Lambda stopped it.

LazyInitializationExceptionJava

org.hibernate.LazyInitializationException: could not initialize proxy - no Session

A lazy-loaded association was accessed after the Hibernate session/transaction closed.

TransientObjectExceptionJava

org.hibernate.TransientObjectException: object references an unsaved transient instance - save the transient instance before flushing

An entity references another entity that hasn’t been saved yet, and no cascade is configured.

Hibernate ConstraintViolationExceptionJava

org.hibernate.exception.ConstraintViolationException: could not execute statement

The database rejected an insert/update because of a constraint (unique, foreign key, not null).

redirect_uri_mismatchAuthentication

OAuth Error: redirect_uri_mismatch

The redirect URI in your OAuth request doesn’t exactly match one registered for the client in the provider’s console.

divergent branchesGit

hint: You have divergent branches and need to specify how to reconcile them.

Git 2.27+ asks you to choose merge, rebase or fast-forward-only when local and remote both have new commits.

LF/CRLF warningGit

warning: in the working copy of 'x', LF will be replaced by CRLF the next time Git touches it

Git’s line-ending conversion (core.autocrlf) will change line endings in your working copy.

OOMKilledKubernetes

Kubernetes: OOMKilled (exit code 137)

The container used more memory than its limit, and the kernel killed it.

OutOfMemoryErrorJava

java.lang.OutOfMemoryError: Java heap space

The JVM ran out of heap memory and garbage collection couldn’t free enough.

MEMORY_MANAGEMENTWindows

Blue Screen: MEMORY_MANAGEMENT (Stop code 0x0000001A)

Windows detected a severe memory-management error — commonly faulty RAM, unstable memory settings or a bad driver.

22P02PostgreSQL

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

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

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.

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.

integer divisionSQL

5 / 2 = 2: integer division silently truncates the result

Dividing two integers returns an integer in most databases, so decimals are dropped.

8114SQL

SQL Server Msg 8114: Error converting data type varchar to numeric

A text value that isn't a valid number was converted to DECIMAL/NUMERIC.

GROUP_CONCATSQL

GROUP_CONCAT / STRING_AGG result truncated or fails (group_concat_max_len, string length limit)

An aggregated string is cut off at 1024 characters (MySQL) or fails with a size error (SQL Server STRING_AGG, 8000 bytes).

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

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.

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.

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.

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.

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.

hotspottingGoogle Cloud / Firebase

Firestore write latency/errors: hotspotting from sequential document IDs or indexed fields

Writes get slow or fail when many documents with monotonically increasing IDs or indexed values land in the same key range.

indexOnGoogle Cloud / Firebase

Realtime Database: Using an unspecified index — consider adding ".indexOn" to your security rules

A query orders or filters by a child that isn't indexed, so the client downloads and filters the data.