Error map

ORA-00028 ORA-00028: your session has been killed

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.

ORA-00028 — ORA-00028: your session has been killed (SQL)ORA-00028ORA-00933 — ORA-00933: SQL command not properly ended (SQL)ORA-00933Idle connections silently dropped by firewall/NAT — Networking: Connection works, then fails after being idle — firewall/NAT idle timeout dropped the TCP session (use keepalive) (Networking)Idle connections si…ORA-01722 — ORA-01722: invalid number (SQL)ORA-01722ORA-00001 — ORA-00001: unique constraint (SCHEMA.PK_X) violated (SQL)ORA-00001ORA-01017 — ORA-01017: invalid username/password; logon denied (SQL)ORA-01017ORA-00054 — ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired (SQL)ORA-00054ORA-12154 — ORA-12154: TNS:could not resolve the connect identifier specified (SQL)ORA-12154ORA-12514 — ORA-12514: TNS:listener does not currently know of service requested in connect descriptor (SQL)ORA-12514ORA-12505 — ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (SQL)ORA-12505ORA-12541 — ORA-12541: TNS:no listener (SQL)ORA-12541ORA-06512 — ORA-06512: at "SCHEMA.PROC", line N (SQL)ORA-06512ORA-00060 — ORA-00060: deadlock detected while waiting for resource (SQL)ORA-000601064 — 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 BY1020 — Cloudflare Error 1020: Access Denied (Cloudflare)1020iptables: No chain/target/match — driver failed programming external connectivity on endpoint: iptables: No chain/target/match by that name (Docker)iptables: No chain/…ssh port 22 Connection timed out — ssh: connect to host x port 22: Connection timed out (Linux)ssh port 22 Connect…8152 / 2628 — SQL Server: String or binary data would be truncated in table 'x', column 'y'. (Msg 2628) (SQL)8152 / 2628245 — 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)81151062 — MySQL ERROR 1062 (23000): Duplicate entry for key (MySQL)1062SQLite UNIQUE failed — sqlite3.IntegrityError: UNIQUE constraint failed: users.email (SQL)SQLite UNIQUE failedSQLite NOT NULL failed — sqlite3.IntegrityError: NOT NULL constraint failed: table.column (SQL)SQLite NOT NULL fai…1045 — MySQL ERROR 1045 (28000): Access denied for user (MySQL)10451698 — MySQL ERROR 1698 (28000): Access denied for user 'root'@'localhost' (MySQL)1698role does not exist — FATAL: role "x" does not exist (PostgreSQL)role does not existDeadlock — 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 timeout1213 — MySQL ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction (MySQL)1213Network-related error — SQL Server: A network-related or instance-specific error occurred while establishing a connection to SQL Server. (provider: Named Pipes Provider, error: 40 / TCP Provider, error: 26) (SQL)Network-related err…ORA-00904 — ORA-00904: "X": invalid identifier (SQL)ORA-00904ORA-00018 — ORA-00018: maximum number of sessions exceeded (SQL)ORA-00018ORA-00020 — ORA-00020: maximum number of processes (150) exceeded (SQL)ORA-00020ORA-01034 — ORA-01034: ORACLE not available (ORA-27101: shared memory realm does not exist) (SQL)ORA-01034ORA-12170 — ORA-12170: TNS:Connect timeout occurred (SQL)ORA-121702003 — MySQL ERROR 2003 (HY000): Can't connect to MySQL server on 'host:3306' (111) (MySQL)2003ORA-00942 — ORA-00942: table or view does not exist (SQL)ORA-00942ORA-01400 — ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE"."COLUMN") (SQL)ORA-01400ORA-01000 — ORA-01000: maximum open cursors exceeded (SQL)ORA-010001205 — SQL Server Msg 1205: Transaction was deadlocked on lock resources and has been chosen as the deadlock victim (SQL)12051222 — SQL Server Msg 1222: Lock request time out period exceeded (SQL)1222SQL0911N — Db2 SQL0911N: The current transaction has been rolled back because of a deadlock or timeout (reason code 68) (SQL)SQL0911N

Directly related (12)

ORA-00933SQL

ORA-00933: SQL command not properly ended

Oracle found extra clauses or syntax it doesn’t support at the end of a statement.

Idle connections silently dropped by firewall/NATNetworking

Networking: Connection works, then fails after being idle — firewall/NAT idle timeout dropped the TCP session (use keepalive)

A connection that sat idle was forgotten by a firewall or NAT device, so the next packet gets reset or vanishes.

ORA-01722SQL

ORA-01722: invalid number

Oracle tried to convert a string to a number and failed.

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-00054SQL

ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired

DDL or a NOWAIT lock couldn’t get the lock because another session holds it.

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

ORA-12514SQL

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

The listener is up but doesn’t know the service name you requested.

ORA-12505SQL

ORA-12505: TNS:listener does not currently know of SID given in connect descriptor

The connect string uses a SID the listener doesn’t know — often a service name passed as SID.

ORA-12541SQL

ORA-12541: TNS:no listener

Nothing listens on the Oracle host/port — the listener is down or you have the wrong port.

ORA-06512SQL

ORA-06512: at "SCHEMA.PROC", line N

A stack-trace line from PL/SQL — the real error is the ORA- code above it.

ORA-00060SQL

ORA-00060: deadlock detected while waiting for resource

Two sessions wait for each other's row locks; Oracle rolled back one statement.

Two steps away (31)

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.

1020Cloudflare

Cloudflare Error 1020: Access Denied

A Cloudflare firewall/WAF custom rule blocked the request — the visitor’s IP, country, user agent or request pattern matched a bl…

iptables: No chain/target/matchDocker

driver failed programming external connectivity on endpoint: iptables: No chain/target/match by that name

Docker’s iptables rules were wiped (firewalld/ufw reload, iptables flush) while Docker was running, so it can’t publish ports.

ssh port 22 Connection timed outLinux

ssh: connect to host x port 22: Connection timed out

SSH packets get no reply — a firewall/security group drops them, the server is off, or the IP is wrong.

8152 / 2628SQL

SQL Server: String or binary data would be truncated in table 'x', column 'y'. (Msg 2628)

A value is longer than the column allows.

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.

1062MySQL

MySQL ERROR 1062 (23000): Duplicate entry for key

An INSERT/UPDATE would create a duplicate value in a PRIMARY or UNIQUE key.

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.

SQLite NOT NULL failedSQL

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

A NULL went into a NOT NULL column in SQLite.

1045MySQL

MySQL ERROR 1045 (28000): Access denied for user

MySQL rejected the login — wrong password, wrong user/host combination, or the user doesn’t exist.

1698MySQL

MySQL ERROR 1698 (28000): Access denied for user 'root'@'localhost'

root uses the auth_socket/unix_socket plugin (Ubuntu/Debian default), so password logins as root fail.

role does not existPostgreSQL

FATAL: role "x" does not exist

PostgreSQL has no login role with that name.

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.

1213MySQL

MySQL ERROR 1213 (40001): Deadlock found when trying to get lock; try restarting transaction

MySQL detected a deadlock between two transactions and rolled one back.

Network-related errorSQL

SQL Server: A network-related or instance-specific error occurred while establishing a connection to SQL Server. (provider: Named Pipes Provider, error: 40 / TCP Provider, error: 26)

The client couldn’t reach the SQL Server instance — wrong server name/instance, TCP disabled, firewall, or SQL Browser not runnin…

ORA-00904SQL

ORA-00904: "X": invalid identifier

A column name in the statement doesn’t exist (or is misquoted).

ORA-00018SQL

ORA-00018: maximum number of sessions exceeded

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

ORA-00020SQL

ORA-00020: maximum number of processes (150) exceeded

The instance reached its PROCESSES limit, so new connections are refused.

ORA-01034SQL

ORA-01034: ORACLE not available (ORA-27101: shared memory realm does not exist)

The instance isn't started (or ORACLE_SID/ORACLE_HOME point to the wrong place), so you can't attach to it.

ORA-12170SQL

ORA-12170: TNS:Connect timeout occurred

The client couldn't establish the connection to the Oracle listener within the timeout.

2003MySQL

MySQL ERROR 2003 (HY000): Can't connect to MySQL server on 'host:3306' (111)

The client couldn’t reach MySQL over TCP — server down, wrong host/port, firewall, or MySQL bound to localhost only.

ORA-00942SQL

ORA-00942: table or view does not exist

Oracle can’t see the table — it doesn’t exist, is in another schema, or you lack privileges on it.

ORA-01400SQL

ORA-01400: cannot insert NULL into ("SCHEMA"."TABLE"."COLUMN")

A NULL was inserted into a NOT NULL column.

ORA-01000SQL

ORA-01000: maximum open cursors exceeded

A session opened more cursors than `OPEN_CURSORS` allows, almost always because statements/result sets aren't closed.

1205SQL

SQL Server Msg 1205: Transaction was deadlocked on lock resources and has been chosen as the deadlock victim

Two sessions each hold locks the other needs, so SQL Server rolled one of them back.

1222SQL

SQL Server Msg 1222: Lock request time out period exceeded

A statement waited longer than `LOCK_TIMEOUT` for a lock held by another session.

SQL0911NSQL

Db2 SQL0911N: The current transaction has been rolled back because of a deadlock or timeout (reason code 68)

Db2 rolled the transaction back because it hit a lock timeout (68) or a deadlock (2).