Error map

000606 Snowflake: No active warehouse selected in the current session

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.

000606 — Snowflake: No active warehouse selected in the current session (SQL)000606pool 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 timeoutaggregate in WHERE — ERROR: aggregate functions are not allowed in WHERE (use HAVING) / MySQL 1111 Invalid use of group function (SQL)aggregate in WHERE002003 — Snowflake SQL compilation error: Object 'X' does not exist or not authorized (SQL)002003100038 — Snowflake: Numeric value 'X' is not recognized (SQL)100038cartesian — Query returns far too many rows: accidental Cartesian product (missing JOIN condition) (SQL)cartesian229 — SQL Server Msg 229: The SELECT permission was denied on the object (SQL)229auth/requires-recent-login — Firebase Auth: auth/requires-recent-login — sensitive operation needs a recent sign-in (Google Cloud / Firebase)auth/requires-recen…ORA-00028 — ORA-00028: your session has been killed (SQL)ORA-00028504 — HTTP 504 Gateway Timeout (HTTP)504524 — Cloudflare Error 524: A Timeout Occurred (Cloudflare)524304 — HTTP 304 Not Modified (HTTP)3041064 — MySQL ERROR 1064 (42000): You have an error in your SQL syntax (MySQL)1064ambiguous column — Column reference is ambiguous / Column 'id' in field list is ambiguous (MySQL 1052) (SQL)ambiguous columnGROUP BY — Column must appear in the GROUP BY clause / isn't in GROUP BY (MySQL 1055 only_full_group_by) (SQL)GROUP BYreadonly database — sqlite3.OperationalError: attempt to write a readonly database (SQL)readonly database208 — SQL Server: Invalid object name 'x'. (Msg 208) (SQL)2085123 — SQL Server Msg 5123: CREATE FILE encountered operating system error 5 (Access is denied) while attempting to open the physical file (SQL)512322P02 — ERROR: invalid input syntax for type integer: "abc" (PostgreSQL)22P02245 — SQL Server: Conversion failed when converting the varchar value 'x' to data type int. (Msg 245) (SQL)245CASE — CASE expression returns mixed types: conversion failed / types cannot be matched (SQL)CASE57014 — 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 queries0x80070005 — Windows Error 0x80070005 (E_ACCESSDENIED): Access is denied (Windows)0x8007000542501 — PostgreSQL: ERROR: permission denied for table / schema public (PostgreSQL)42501sudoers — user is not in the sudoers file. This incident will be reported. (Linux)sudoersauth/invalid-credential — Firebase Auth: auth/invalid-credential (auth/wrong-password, auth/user-not-found, auth/invalid-login-credentials) (Authentication)auth/invalid-creden…Your Remote Desktop Services session has ended (network problem) — Networking: Your Remote Desktop Services session has ended. Possibly the network connection was lost / Remote Desktop disconnected, error code 0x904 (Networking)Your Remote Desktop…The specified network name is no longer available (64) — Networking: Windows error 64: The specified network name is no longer available — SMB session dropped (Networking)The specified netwo…ORA-00001 — ORA-00001: unique constraint (SCHEMA.PK_X) violated (SQL)ORA-00001ORA-01017 — ORA-01017: invalid username/password; logon denied (SQL)ORA-01017ORA-12154 — ORA-12154: TNS:could not resolve the connect identifier specified (SQL)ORA-12154

Directly related (8)

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.

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.

002003SQL

Snowflake SQL compilation error: Object 'X' does not exist or not authorized

The table/view/schema name can't be resolved in the current role, database and schema context, or the role lacks privileges.

100038SQL

Snowflake: Numeric value 'X' is not recognized

A text value couldn't be converted to a number while loading or casting.

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.

229SQL

SQL Server Msg 229: The SELECT permission was denied on the object

The login's user lacks the permission on that table, view or procedure.

auth/requires-recent-loginGoogle Cloud / Firebase

Firebase Auth: auth/requires-recent-login — sensitive operation needs a recent sign-in

Changing email/password, deleting the account or linking credentials needs the user to have signed in recently.

ORA-00028SQL

ORA-00028: your session has been killed

An administrator, a resource limit or a profile terminated your session while it was idle or running.

Two steps away (24)

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.

1064MySQL

MySQL ERROR 1064 (42000): You have an error in your SQL syntax

MySQL couldn’t parse the query. The text after “near” shows where parsing failed.

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.

GROUP BYSQL

Column must appear in the GROUP BY clause / isn't in GROUP BY (MySQL 1055 only_full_group_by)

You selected a column that is neither grouped nor aggregated, so the result would be ambiguous.

readonly databaseSQL

sqlite3.OperationalError: attempt to write a readonly database

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

208SQL

SQL Server: Invalid object name 'x'. (Msg 208)

The table/view doesn’t exist in the current database or schema.

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.

22P02PostgreSQL

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

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

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.

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

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.

0x80070005Windows

Windows Error 0x80070005 (E_ACCESSDENIED): Access is denied

Windows refused an operation because the account or process lacks permission — seen in Windows Update, installers, Task Scheduler…

42501PostgreSQL

PostgreSQL: ERROR: permission denied for table / schema public

The role is connected but lacks privileges on that table or schema — very common after PostgreSQL 15 removed CREATE on the public…

sudoersLinux

user is not in the sudoers file. This incident will be reported.

Your account isn’t allowed to use sudo.

auth/invalid-credentialAuthentication

Firebase Auth: auth/invalid-credential (auth/wrong-password, auth/user-not-found, auth/invalid-login-credentials)

Firebase rejected the email/password sign-in — wrong password, no such user, or a provider credential that’s malformed/expired.

Your Remote Desktop Services session has ended (network problem)Networking

Networking: Your Remote Desktop Services session has ended. Possibly the network connection was lost / Remote Desktop disconnected, error code 0x904

An established Remote Desktop session dropped because the network under it stalled or the session was reset.

The specified network name is no longer available (64)Networking

Networking: Windows error 64: The specified network name is no longer available — SMB session dropped

A connection to a Windows file share was cut while in use.

ORA-00001SQL

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

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

ORA-01017SQL

ORA-01017: invalid username/password; logon denied

Oracle rejected the credentials.

ORA-12154SQL

ORA-12154: TNS:could not resolve the connect identifier specified

The Oracle client couldn’t find the alias in tnsnames.ora (or the naming method can’t resolve it).