Error map
implicit conversion Query slow because of an implicit type conversion or function on the column (index not used)
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)
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.
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.
ERROR: canceling statement due to statement timeout
A query ran longer than statement_timeout and PostgreSQL cancelled it.
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.
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.
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.
LIKE matches too much: _ and % are wildcards (escape them)
Searching for text containing `_` or `%` returns unexpected rows because LIKE treats them as wildcards.
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".
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.
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).
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.
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)
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.
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…
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.
HTTP 504 Gateway Timeout
A proxy or gateway waited too long for the upstream server to respond and gave up.
Cloudflare Error 524: A Timeout Occurred
Cloudflare connected to the origin, but the origin didn’t send an HTTP response within 100 seconds.
HTTP 304 Not Modified
The cached copy is still valid, so the server sends no body and the client reuses its cache.
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 timeout exceeded; try restarting transaction (MySQL 1205)
A query waited too long for a row lock held by another transaction and gave up.
AWS Lambda: Task timed out after X seconds
The function ran longer than its configured timeout (default 3 seconds) and Lambda stopped it.
org.hibernate.LazyInitializationException: could not initialize proxy - no Session
A lazy-loaded association was accessed after the Hibernate session/transaction closed.
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.
org.hibernate.exception.ConstraintViolationException: could not execute statement
The database rejected an insert/update because of a constraint (unique, foreign key, not null).
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.
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.
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.
Kubernetes: OOMKilled (exit code 137)
The container used more memory than its limit, and the kernel killed it.
java.lang.OutOfMemoryError: Java heap space
The JVM ran out of heap memory and garbage collection couldn’t free enough.
Blue Screen: MEMORY_MANAGEMENT (Stop code 0x0000001A)
Windows detected a severe memory-management error — commonly faulty RAM, unstable memory settings or a bad driver.
ERROR: invalid input syntax for type integer: "abc"
A string couldn’t be converted to the column’s type (integer, numeric, boolean, date…).
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.
COUNT(column) ignores NULLs: counts differ from COUNT(*)
`COUNT(col)` counts only non-NULL values, while `COUNT(*)` counts rows, so totals don't match.
5 / 2 = 2: integer division silently truncates the result
Dividing two integers returns an integer in most databases, so decimals are dropped.
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_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).
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 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 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.
AttributeError: 'X' object has no attribute 'y'
You accessed an attribute or method that doesn’t exist on that object type.
java.lang.ClassCastException: class A cannot be cast to class B
An object was cast to a type it isn’t.
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.
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.
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.
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.
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.
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.
Map another error
Popular: 500400403ORA-009331064Critical errorFileNotFoundException assemblyTypeError