Error map

too many SQL variables SQLite: too many SQL variables

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.

too many SQL variables — SQLite: too many SQL variables (SQL)too many SQ…readonly database — sqlite3.OperationalError: attempt to write a readonly database (SQL)readonly databaseEMFILE — Too many open files (EMFILE) (Linux)EMFILEmalformed database — sqlite3.DatabaseError: database disk image is malformed (SQL)malformed databaseRequestEntityTooLargeException — Lambda: Request must be smaller than 6291456 bytes for the InvokeFunction operation (RequestEntityTooLargeException) (AWS)RequestEntityTooLar…fork: retry: Resource temporarily unavailable — fork: retry: Resource temporarily unavailable (process/thread limit) (Linux)fork: retry: Resour…Unzipped size must be smaller than 262144000 bytes — Lambda: Unzipped size must be smaller than 262144000 bytes (AWS)Unzipped size must …201 — SQL Server Msg 201: Procedure or function expects parameter '@X', which was not supplied (SQL)201message size — Pub/Sub: Message size exceeds the 10 MB publish limit (INVALID_ARGUMENT) (Google Cloud / Firebase)message sizetransaction — SQLite: cannot start a transaction within a transaction (SQL)transactionIN list — Too many values in an IN list / too many parameters (limit exceeded) (SQL)IN listparameters — Prepared statement parameter count mismatch (placeholders vs bound values) (SQL)parametersORA-01795 — ORA-01795: maximum number of expressions in a list is 1000 (SQL)ORA-01795EACCES — Linux: Permission denied (Linux)EACCESSQLITE_BUSY — sqlite3.OperationalError: database is locked (SQLITE_BUSY) (SQL)SQLITE_BUSYSQLite no such column — sqlite3.OperationalError: no such column: x (SQL)SQLite no such colu…ENOENT — Error: ENOENT: no such file or directory (Node.js)ENOENTECONNRESET — Error: socket hang up / read ECONNRESET (API)ECONNRESET1040 — MySQL ERROR 1040 (08004): Too many connections (MySQL)1040corrupt object — error: object file .git/objects/x is empty / fatal: loose object is corrupt (Git)corrupt object126 incorrect key file — MySQL ERROR 126 (HY000): Incorrect key file for table; try to repair it (MySQL)126 incorrect key f…SQLite NOT NULL failed — sqlite3.IntegrityError: NOT NULL constraint failed: table.column (SQL)SQLite NOT NULL fai…413 — HTTP 413 Content Too Large (Request Entity Too Large) (HTTP)413Task timed out — AWS Lambda: Task timed out after X seconds (AWS)Task timed outRuntime.ImportModuleError — Runtime.ImportModuleError: Unable to import module 'lambda_function': No module named 'x' (AWS)Runtime.ImportModul…EADDRINUSE — Error: listen EADDRINUSE: address already in use :::3000 (Node.js)EADDRINUSEEPIPE — Error: write EPIPE (Node.js)EPIPEmaxBuffer exceeded — RangeError [ERR_CHILD_PROCESS_STDIO_MAXBUFFER]: stdout maxBuffer length exceeded (Node.js)maxBuffer exceededRuntime.HandlerNotFound — Runtime.HandlerNotFound: index.handler is undefined or not exported (AWS)Runtime.HandlerNotF…Runtime exited with error: signal: killed — Lambda: Runtime exited with error: signal: killed (Runtime.ExitError) (AWS)Runtime exited with…role cannot be assumed by Lambda — InvalidParameterValueException: The role defined for the function cannot be assumed by Lambda (AWS)role cannot be assu…245 — SQL Server: Conversion failed when converting the varchar value 'x' to data type int. (Msg 245) (SQL)245515 — SQL Server Msg 515: Cannot insert the value NULL into column 'X', table 'Y'; column does not allow nulls (SQL)5155123 — SQL Server Msg 5123: CREATE FILE encountered operating system error 5 (Access is denied) while attempting to open the physical file (SQL)5123Pub/Sub NOT_FOUND: Resource not found (topic/subscription) — Pub/Sub: 5 NOT_FOUND: Resource not found (resource=my-topic) (Google Cloud / Firebase)Pub/Sub NOT_FOUND: …Pub/Sub: messages redelivered (ack deadline exceeded) — Pub/Sub: Messages keep being redelivered — acknowledgement deadline expired before the subscriber acked (Google Cloud / Firebase)Pub/Sub: messages r…Firestore: Document exceeds the maximum size of 1,048,576 bytes — Firestore: 3 INVALID_ARGUMENT: The value of property "data" is longer than 1048487 bytes / Document exceeds the maximum size (Google Cloud / Firebase)Firestore: Document…Deadlock — Deadlock found when trying to get lock; try restarting transaction (SQL)DeadlockLock wait timeout — Lock wait timeout exceeded; try restarting transaction (MySQL 1205) (SQL)Lock wait timeoutSQLite UNIQUE failed — sqlite3.IntegrityError: UNIQUE constraint failed: users.email (SQL)SQLite UNIQUE failedcartesian — 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)CASELIKE — LIKE matches too much: _ and % are wildcards (escape them) (SQL)LIKE08P01 — ERROR: bind message supplies 2 parameters, but prepared statement requires 1 (PostgreSQL)08P01COUNT — COUNT(column) ignores NULLs: counts differ from COUNT(*) (SQL)COUNTdoes not exist — Service account X does not exist (deleted or wrong email) — IAM binding fails (Google Cloud / Firebase)does not existORA-00001 — ORA-00001: unique constraint (SCHEMA.PK_X) violated (SQL)ORA-00001LIMIT — LIMIT/TOP without ORDER BY returns different rows each time (SQL)LIMITORA-00018 — ORA-00018: maximum number of sessions exceeded (SQL)ORA-00018

Directly related (12)

readonly databaseSQL

sqlite3.OperationalError: attempt to write a readonly database

The process can’t write to the SQLite file or its directory.

EMFILELinux

Too many open files (EMFILE)

The process hit its file-descriptor limit — sockets, files and pipes all count.

malformed databaseSQL

sqlite3.DatabaseError: database disk image is malformed

The SQLite file is corrupted.

RequestEntityTooLargeExceptionAWS

Lambda: Request must be smaller than 6291456 bytes for the InvokeFunction operation (RequestEntityTooLargeException)

The event payload (or response) is over Lambda’s 6 MB synchronous limit (256 KB for async invocations).

fork: retry: Resource temporarily unavailableLinux

fork: retry: Resource temporarily unavailable (process/thread limit)

The user or container hit its maximum number of processes/threads (ulimit -u, pids cgroup), so new processes can’t be created.

Unzipped size must be smaller than 262144000 bytesAWS

Lambda: Unzipped size must be smaller than 262144000 bytes

The function code plus layers exceed Lambda’s 250 MB unzipped limit for zip deployments.

201SQL

SQL Server Msg 201: Procedure or function expects parameter '@X', which was not supplied

A required parameter wasn't passed to the stored procedure.

message sizeGoogle Cloud / Firebase

Pub/Sub: Message size exceeds the 10 MB publish limit (INVALID_ARGUMENT)

A single message or publish request was larger than Pub/Sub allows.

transactionSQL

SQLite: cannot start a transaction within a transaction

BEGIN was issued while a transaction was already open on the same connection.

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.

parametersSQL

Prepared statement parameter count mismatch (placeholders vs bound values)

The number of `?`/`$1`/`:name` placeholders doesn't match the values you bound.

ORA-01795SQL

ORA-01795: maximum number of expressions in a list is 1000

An IN (...) list contains more than 1000 items, which Oracle doesn't allow.

Two steps away (36)

EACCESLinux

Linux: Permission denied

Your user (or the service user) lacks read/write/execute permission on a file, directory or one of its parents.

SQLITE_BUSYSQL

sqlite3.OperationalError: database is locked (SQLITE_BUSY)

Another connection holds a write lock on the SQLite file, and this one gave up waiting.

SQLite no such columnSQL

sqlite3.OperationalError: no such column: x

SQLite can’t find the column — missing migration, typo, or a string written in double quotes.

ENOENTNode.js

Error: ENOENT: no such file or directory

A file or directory the program tried to open doesn’t exist at that path.

ECONNRESETAPI

Error: socket hang up / read ECONNRESET

The other side closed the TCP connection abruptly while your client was still using it.

1040MySQL

MySQL ERROR 1040 (08004): Too many connections

MySQL reached `max_connections` and refuses new clients.

corrupt objectGit

error: object file .git/objects/x is empty / fatal: loose object is corrupt

The local Git object database is corrupted — usually after a crash, disk full or sync tool interference.

126 incorrect key fileMySQL

MySQL ERROR 126 (HY000): Incorrect key file for table; try to repair it

MySQL can’t use a table’s index file — usually a full tmp disk during a query, or MyISAM corruption.

SQLite NOT NULL failedSQL

sqlite3.IntegrityError: NOT NULL constraint failed: table.column

A NULL went into a NOT NULL column in SQLite.

413HTTP

HTTP 413 Content Too Large (Request Entity Too Large)

The request body is bigger than the server is willing to accept — usually a file upload over the configured limit.

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.

Runtime.ImportModuleErrorAWS

Runtime.ImportModuleError: Unable to import module 'lambda_function': No module named 'x'

Lambda couldn’t load your handler file or one of its dependencies — the package is missing from the deployment zip/layer or the h…

EADDRINUSENode.js

Error: listen EADDRINUSE: address already in use :::3000

Another process is already listening on that port.

EPIPENode.js

Error: write EPIPE

Node wrote to a pipe or socket whose other end was already closed.

maxBuffer exceededNode.js

RangeError [ERR_CHILD_PROCESS_STDIO_MAXBUFFER]: stdout maxBuffer length exceeded

child_process.exec/execSync produced more output than its buffer allows (default 1 MB).

Runtime.HandlerNotFoundAWS

Runtime.HandlerNotFound: index.handler is undefined or not exported

Lambda loaded the file but couldn’t find the function named in the handler setting.

Runtime exited with error: signal: killedAWS

Lambda: Runtime exited with error: signal: killed (Runtime.ExitError)

The function process was killed — almost always because it ran out of its configured memory.

role cannot be assumed by LambdaAWS

InvalidParameterValueException: The role defined for the function cannot be assumed by Lambda

The execution role’s trust policy doesn’t allow lambda.amazonaws.com — or the role was just created and IAM hasn’t propagated yet.

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.

515SQL

SQL Server Msg 515: Cannot insert the value NULL into column 'X', table 'Y'; column does not allow nulls

An INSERT or UPDATE tried to put NULL into a NOT NULL column that has no default.

5123SQL

SQL Server Msg 5123: CREATE FILE encountered operating system error 5 (Access is denied) while attempting to open the physical file

SQL Server's service account can't read or write the .mdf/.ldf file when attaching or restoring.

Pub/Sub NOT_FOUND: Resource not found (topic/subscription)Google Cloud / Firebase

Pub/Sub: 5 NOT_FOUND: Resource not found (resource=my-topic)

The topic or subscription you used doesn't exist in the project the client is configured for.

Pub/Sub: messages redelivered (ack deadline exceeded)Google Cloud / Firebase

Pub/Sub: Messages keep being redelivered — acknowledgement deadline expired before the subscriber acked

Your subscriber took longer than the ack deadline to acknowledge, so Pub/Sub redelivered the message (duplicate processing).

Firestore: Document exceeds the maximum size of 1,048,576 bytesGoogle Cloud / Firebase

Firestore: 3 INVALID_ARGUMENT: The value of property "data" is longer than 1048487 bytes / Document exceeds the maximum size

A single Firestore document (all fields combined) went beyond the 1 MiB limit.

DeadlockSQL

Deadlock found when trying to get lock; try restarting transaction

Two transactions waited on each other’s locks; the database killed one so the other could continue.

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.

SQLite UNIQUE failedSQL

sqlite3.IntegrityError: UNIQUE constraint failed: users.email

An insert/update duplicated a value in a UNIQUE or PRIMARY KEY column in SQLite.

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

LIKESQL

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

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

08P01PostgreSQL

ERROR: bind message supplies 2 parameters, but prepared statement requires 1

The number of query parameters sent doesn’t match the $1, $2 … placeholders in the SQL.

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.

does not existGoogle Cloud / Firebase

Service account X does not exist (deleted or wrong email) — IAM binding fails

The service account named in a binding, deploy or API call doesn't exist (or was deleted).

ORA-00001SQL

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

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

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.

ORA-00018SQL

ORA-00018: maximum number of sessions exceeded

The database reached its SESSIONS limit, so no new connection can be created.