Error codes

undefined

• Oracle73
• PostgreSQL62
• MySQL62
• SQL Server62
• MongoDB55
• Redis54
• Elasticsearch58

Oracle

• ORA-00001Unique constraint violated
• ORA-00054Resource busy and acquire with NOWAIT specified or timeout expired
• ORA-00060Deadlock detected while waiting for resource
• ORA-01017Invalid username/password; logon denied
• ORA-01555Snapshot too old: rollback segment number too small
• ORA-01652Unable to extend temp segment by N in tablespace
• ORA-04031Unable to allocate N bytes of shared memory
• ORA-12154TNS: could not resolve the connect identifier specified
• ORA-12514TNS: listener does not currently know of service requested in connect descriptor
• ORA-00942Table or view does not exist
• ORA-01031Insufficient privileges
• ORA-00257Archiver error. Connect internal only, until freed
• ORA-01000Maximum open cursors exceeded
• ORA-00018Maximum number of sessions exceeded
• ORA-28000The account is locked
• ORA-01578Oracle data block corrupted (file #, block #)
• ORA-01722Invalid number
• ORA-02049Timeout: distributed transaction waiting for lock
• enq: TX - row lock contentionWait: session blocked on a row-level lock held by another transaction
• log file syncWait: session waiting for LGWR to flush redo to disk on commit
• db file sequential readWait: single-block physical read, typically an index or table lookup
• db file scattered readWait: multi-block physical read, typically a full table or index fast full scan
• buffer busy waitsWait: contention for a buffer already being read or modified by another session
• gc buffer busyWait (RAC): contention for a cache-fusion block being transferred between instances
• library cache lockWait: contention on a library cache object handle (parse/DDL serialization)
• ORA-00604error occurred at recursive SQL level
• ORA-01438value larger than specified precision allowed for this column
• ORA-01400cannot insert NULL into (column)
• ORA-02291integrity constraint violated - parent key not found
• ORA-02292integrity constraint violated - child record found
• ORA-00979not a GROUP BY expression
• ORA-00918column ambiguously defined
• ORA-06550line/column PLS-... PL/SQL compilation error
• ORA-04068existing state of packages has been discarded
• ORA-01427single-row subquery returns more than one row
• ORA-12899value too large for column
• ORA-30926unable to get a stable set of rows in the source tables
• ORA-08103object no longer exists
• ORA-01843not a valid month
• ORA-14400inserted partition key does not map to any partition
• ORA-01536space quota exceeded for tablespace
• direct path readWait: session reading blocks directly into PGA bypassing buffer cache
• latch: cache buffers chainsWait: contention on cache buffers chains latch
• ORA-00955name is already used by an existing object
• ORA-02449unique/primary keys in table referenced by foreign keys
• ORA-01950no privileges on tablespace 'name'
• ORA-01110data file N: 'path'
• ORA-16038log N sequence# M cannot be archived
• ORA-19809limit exceeded for recovery files
• ORA-00376file N cannot be read at this time
• ORA-12520TNS:listener could not find available handler for requested type of server
• ORA-28001the password has expired
• ORA-38029object statistics are locked
• ORA-00845MEMORY_TARGET not supported on this system
• ORA-27102out of memory
• ORA-04030out of process memory when trying to allocate N bytes
• ORA-12537TNS:connection closed
• ORA-03135connection lost contact
• ORA-01033ORACLE initialization or shutdown in progress
• ORA-00600internal error code, arguments: [...]
• ORA-07445exception encountered: core dump
• ORA-01102cannot mount database in EXCLUSIVE mode
• ORA-29913error in executing ODCIEXTTABLEOPEN callout
• ORA-19804cannot reclaim N bytes disk space from M bytes limit
• ORA-00494enqueue held for too long by 'inst N, osid M'
• ORA-04021timeout occurred while waiting to lock object
• ORA-04061existing state of package/procedure has been invalidated
• ORA-01466unable to read data - table definition has changed
• ORA-08176consistent read failure; rollback data not available
• ORA-00020maximum number of processes (N) exceeded
• ORA-01113file N needs media recovery
• ORA-02393exceeded call limit on CPU usage
• ORA-12801error signaled in parallel query server Pnnn

PostgreSQL

• 23505unique_violation
• 23503foreign_key_violation
• 23502not_null_violation
• 40P01deadlock_detected
• 40001serialization_failure
• 53300too_many_connections
• 53100disk_full
• 57014query_canceled
• 42P01undefined_table
• 42703undefined_column
• 42501insufficient_privilege
• 28P01invalid_password
• 08006connection_failure
• 55P03lock_not_available
• 54000program_limit_exceeded
• 22001string_data_right_truncation
• 25P02in_failed_sql_transaction
• 53200out_of_memory
• 42883undefined_function
• 42804datatype_mismatch
• 22P02invalid_text_representation
• 22003numeric_value_out_of_range
• 23514check_violation
• 22012division_by_zero
• 42601syntax_error
• 42P07duplicate_table
• 42701duplicate_column
• 3D000invalid_catalog_name
• 3F000invalid_schema_name
• 0A000feature_not_supported
• 57P03cannot_connect_now
• 2BP01dependent_objects_still_exist
• 55006object_in_use
• 22007invalid_datetime_format
• 54001statement_too_complex
• 58030io_error
• 22004null_value_not_allowed
• 42P18indeterminate_datatype
• 42P02undefined_parameter
• 2F003prohibited_sql_statement_attempted
• 40003statement_completion_unknown
• 08003connection_does_not_exist
• 25006read_only_sql_transaction
• 21000cardinality_violation
• 08001sqlclient_unable_to_establish_sqlconnection
• 08004sqlserver_rejected_establishment_of_sqlconnection
• 57P01admin_shutdown
• 53400configuration_limit_exceeded
• XX001data_corrupted
• XX002index_corrupted
• 25001active_sql_transaction
• 42P16invalid_table_definition
• P0001raise_exception
• 23P01exclusion_violation
• 23001restrict_violation
• 42P17invalid_object_definition
• 42710duplicate_object
• 22008datetime_field_overflow
• 22026string_data_length_mismatch
• 2201Binvalid_regular_expression
• 44000with_check_option_violation
• 40002transaction_integrity_constraint_violation

MySQL

• 1045Access denied for user (using password: YES/NO)
• 1062Duplicate entry for key
• 1213Deadlock found when trying to get lock; try restarting transaction
• 1205Lock wait timeout exceeded; try restarting transaction
• 1040Too many connections
• 1064You have an error in your SQL syntax
• 1146Table doesn't exist
• 1054Unknown column in field list
• 2002Can't connect to local MySQL server through socket
• 2003Can't connect to MySQL server (TCP/IP)
• 2006MySQL server has gone away
• 1114The table is full
• 1215Cannot add foreign key constraint
• 1451Cannot delete or update a parent row: a foreign key constraint fails
• 1452Cannot add or update a child row: a foreign key constraint fails
• 1366Incorrect string/integer value for column
• 1044Access denied for user to database
• 1264Out of range value for column
• 1052Column 'x' in field list is ambiguous
• 1136Column count doesn't match value count
• 1048Column 'x' cannot be null
• 1292Incorrect datetime value / truncated incorrect value
• 1406Data too long for column
• 1071Specified key was too long; max key length is 767 bytes
• 1050Table already exists
• 1051Unknown table 'x'
• 1091Can't DROP 'x'; check that column/key exists
• 1093You can't specify target table 'x' for update in FROM clause
• 1305PROCEDURE does not exist
• 1227Access denied; you need (at least one of) the PRIVILEGE
• 3730Cannot drop table referenced by a foreign key constraint
• 2013Lost connection to MySQL server during query
• 1153Got a packet bigger than 'max_allowed_packet' bytes
• 1969MariaDB: Query execution was interrupted (max_statement_time exceeded)
• 1927MariaDB: ER_CONNECTION_KILLED: Connection was killed
• 1290ER_OPTION_PREVENTS_STATEMENT: running with the --read-only option
• 1836ER_READ_ONLY_MODE: Running in read-only mode
• 3819ER_CHECK_CONSTRAINT_VIOLATED: Check constraint is violated
• 1118ER_TOO_BIG_ROWSIZE: Row size too large
• 1170ER_BLOB_KEY_WITHOUT_LENGTH: BLOB/TEXT column used in key specification without a key length
• 1592ER_BINLOG_UNSAFE_STATEMENT: Unsafe statement written to the binary log
• 3140ER_INVALID_JSON_TEXT: Invalid JSON text
• 1526ER_NO_PARTITION_FOR_GIVEN_VALUE: Table has no partition for value
• 1049Unknown database 'name'
• 1364Field 'name' doesn't have a default value
• 1206The total number of locks exceeds the lock table size
• 1236Got fatal error 1236 from master when reading data from binary log
• 1129Host 'host' is blocked because of many connection errors
• 1194Table 'name' is marked as crashed and should be repaired
• 1615Prepared statement needs to be re-prepared
• 1553Cannot drop index needed in a foreign key constraint
• 3948Loading local data is disabled; this must be enabled on both the client and server sides
• 1075Incorrect table definition; there can be only one auto column and it must be defined as a key
• 1055Expression not in GROUP BY (only_full_group_by)
• 1267Illegal mix of collations
• 1030Got error N from storage engine
• 1197Multi-statement transaction required more than 'max_binlog_cache_size'
• 1785Statement violates GTID consistency
• 3024Query execution was interrupted, maximum statement execution time exceeded
• 1298Unknown or incorrect time zone
• 1418Function has none of DETERMINISTIC, NO SQL, or READS SQL DATA (binary logging enabled)
• 1231Variable can't be set to the value of ...

SQL Server

• 1205Transaction (Process ID) was deadlocked on lock resources with another process and has been chosen as the deadlock victim
• 2627Violation of PRIMARY KEY / UNIQUE KEY constraint. Cannot insert duplicate key in object
• 2601Cannot insert duplicate key row in object with unique index. The duplicate key value is ...
• 547The INSERT/UPDATE/DELETE statement conflicted with the FOREIGN KEY / CHECK constraint
• 18456Login failed for user
• 8152String or binary data would be truncated
• 2628String or binary data would be truncated in table, column ...; truncated value
• 1222Lock request time out period exceeded
• 9002The transaction log for database is full due to ...
• 1105Could not allocate space for object in database because the filegroup is full
• 208Invalid object name
• 229The SELECT/EXECUTE permission was denied on the object
• 4060Cannot open database requested by the login. The login failed
• 233A connection was successfully established with the server, but then an error occurred (no process is on the other end of the pipe)
• 823The operating system returned error to SQL Server during a read/write at offset in file (I/O error)
• 824SQL Server detected a logical consistency-based I/O error (page corruption)
• 701There is insufficient system memory in resource pool to run this query
• 845Time-out occurred while waiting for buffer latch
• 3201Cannot open backup device. Operating system error (backup device error)
• 8134Divide by zero error encountered
• 245Conversion failed when converting the value to data type
• 515Cannot insert the value NULL into column
• 8115Arithmetic overflow error converting expression to data type
• 512Subquery returned more than 1 value
• 207Invalid column name
• 156Incorrect syntax near the keyword
• 2812Could not find stored procedure
• 8623The query processor ran out of internal resources and could not produce a query plan
• 4104The multi-part identifier could not be bound
• 2714There is already an object named in the database
• 601Could not continue scan with NOLOCK due to data movement
• 50000Custom error raised with RAISERROR
• 3902The COMMIT TRANSACTION request has no corresponding BEGIN TRANSACTION
• 1101Could not allocate a new page because of insufficient disk space in filegroup
• 3729Cannot DROP because it is being referenced by object
• 3961Snapshot isolation transaction failed because the object was modified by a DDL statement
• 1785Introducing FOREIGN KEY constraint may cause cycles or multiple cascade paths
• 9421XML parsing: illegal xml character
• 15151Cannot find the object/principal because it does not exist or you do not have permission
• 4834You do not have permission to use the bulk load statement
• 10928Resource limit for the database has been reached (Azure SQL)
• 40544The database has reached its size quota (Azure SQL)
• 40613Database is not currently available (Azure SQL)
• 102Incorrect syntax near 'token'
• 8114Error converting data type X to Y
• 1204The instance of the SQL Server Database Engine cannot obtain a LOCK resource
• 3906Failed to update database because the database is read-only
• 15023User already exists in the current database
• 18452Login failed. The login is from an untrusted domain and cannot be used with Windows authentication
• 605Attempt to fetch logical page belongs to a different allocation unit
• 4922ALTER TABLE ALTER COLUMN failed because one or more objects access this column
• 7202Could not find server 'name' in sys.servers
• 40501The service is currently busy. Retry the request after 10 seconds
• 8645A time out occurred while waiting for memory resources to execute the query
• 8651Could not perform the operation because the requested memory grant was not available
• 5061ALTER DATABASE failed because a lock could not be placed on database
• 3702Cannot drop database because it is currently in use
• 15138The database principal owns a schema in the database, and cannot be dropped
• 1934INSERT/UPDATE failed because the following SET options have incorrect settings
• 468Cannot resolve the collation conflict
• 4864Bulk load data conversion error (type mismatch or invalid character)
• 916The server principal is not able to access the database under the current security context

MongoDB

• E11000E11000 duplicate key error collection
• 11000DuplicateKey (error code 11000)
• 13Unauthorized (error code 13)
• 18AuthenticationFailed (error code 18)
• 11600InterruptedAtShutdown (error code 11600)
• 50MaxTimeMSExpired (error code 50)
• 251NoSuchTransaction (error code 251)
• 112WriteConflict (error code 112)
• 133FailedToSatisfyReadPreference (error code 133)
• 6HostUnreachable (error code 6)
• 89NetworkTimeout (error code 89)
• 262ExceededTimeLimit (error code 262)
• 292QueryExceededMemoryLimitNoDiskUseAllowed (error code 292)
• 26NamespaceNotFound (error code 26)
• 43CursorNotFound (error code 43)
• 211KeyNotFound (error code 211)
• 121DocumentValidationFailure
• 40ConflictingUpdateOperators
• 66ImmutableField (cannot update _id)
• 2BadValue
• 14TypeMismatch
• 10334BSONObjectTooLarge
• 46LockBusy
• 96OperationFailed
• 72InvalidOptions
• 9FailedToParse
• 134ReadConcernMajorityNotAvailableYet
• 202NetworkInterfaceExceededTimeLimit
• 31 RoleNotFoundRole not found
• 263 OperationNotSupportedInTransactionOperation not supported inside a multi-document transaction
• 20 IllegalOperationIllegal operation
• 48 NamespaceExistsNamespace (collection) already exists
• 11601 InterruptedOperation was interrupted
• 85 IndexOptionsConflictIndex already exists with different options / different name
• 67 CannotCreateIndexCannot create index
• 27 IndexNotFoundIndex not found
• 79 UnknownReplWriteConcernUnknown replica set write concern
• 10107 NotWritablePrimarynot master / not writable primary
• 91 ShutdownInProgressThe server is in the process of shutting down
• 189 PrimarySteppedDownPrimary stepped down while operation was in progress
• 24 LockTimeoutOperation exceeded time limit waiting for a lock
• 7 HostNotFoundCould not find host
• 175 QueryPlanKilledQuery plan killed during execution
• 11602 InterruptedDueToReplStateChangeOperation interrupted due to a replication state change
• 136 CappedPositionLostCapped collection position lost
• 28 PathNotViableCannot use the part of the path to traverse the element
• 216 ElectionInProgressElectionInProgress
• 225 TransactionTooOldTransactionTooOld
• 246 SnapshotUnavailableSnapshotUnavailable
• 257 TransactionTooLargeTransactionTooLarge
• 276 IndexBuildAbortedIndexBuildAborted
• 86 IndexKeySpecsConflictIndexKeySpecsConflict
• 166 CommandNotSupportedOnViewCommandNotSupportedOnView
• 168 InvalidPipelineOperatorInvalidPipelineOperator
• 118 NamespaceNotShardedNamespaceNotSharded

Redis

• WRONGTYPEWRONGTYPE Operation against a key holding the wrong kind of value
• OOMOOM command not allowed when used memory > 'maxmemory'
• NOAUTHNOAUTH Authentication required
• WRONGPASSWRONGPASS invalid username-password pair or user is disabled
• READONLYREADONLY You can't write against a read only replica
• MASTERDOWNMASTERDOWN Link with MASTER is down and replica-serve-stale-data is set to 'no'
• CLUSTERDOWNCLUSTERDOWN The cluster is down / Hash slot not served
• LOADINGLOADING Redis is loading the dataset in memory
• BUSYBUSY Redis is busy running a script. You can only call SCRIPT KILL or SHUTDOWN NOSAVE
• MISCONFMISCONF Redis is configured to save RDB snapshots, but it's currently unable to persist to disk
• CROSSSLOTCROSSSLOT Keys in request don't hash to the same slot
• MOVEDMOVED slot ip:port (cluster redirect)
• ASKASK slot ip:port (cluster redirect)
• NOSCRIPTNOSCRIPT No matching script. Please use EVAL
• EXECABORTEXECABORT Transaction discarded because of previous errors
• NOPERMNOPERM this user has no permissions to run the command or access one of the keys
• ERR value is not an integer or out of rangeERR value is not an integer or out of range
• ERR value is not a valid floatERR value is not a valid float
• ERR increment or decrement would overflowERR increment or decrement would overflow
• ERR max number of clients reachedERR max number of clients reached
• BUSYKEYBUSYKEY Target key name already exists
• ERR no such keyERR no such key
• ERR DUMP payload version or checksum are wrongERR DUMP payload version or checksum are wrong
• NOREPLICASNOREPLICAS Not enough good replicas to write
• ERR This instance has cluster support disabledERR This instance has cluster support disabled
• ERR unknown subcommandERR unknown subcommand or wrong number of arguments
• ERR Client sent AUTH, but no password is setERR AUTH <password> called without any password configured for the default user (Redis 6+) / ERR Client sent AUTH, but no password is set (Redis <6)
• ERR DEBUG command not allowedDEBUG command not allowed
• ERR Can't save in background: fork failedBackground save failed: fork failed
• NOPROTO unsupported protocol versionUnsupported RESP protocol version
• ERR Unknown option or number of arguments for CONFIG SETUnknown option or number of arguments for CONFIG SET (older versions: Unsupported CONFIG parameter)
• ERR MULTI calls can not be nestedMULTI calls can not be nested
• ERR Lua script attempted to access nonexistent global variableLua script attempted to access a nonexistent global variable
• ERR unknown commandUnknown command
• TRYAGAIN Multiple keys request during rehashing of slotMultiple keys request during rehashing of slot (cluster)
• ERR DISCARD without MULTIDISCARD without MULTI
• BUSYGROUP Consumer Group name already existsConsumer group already exists
• NOGROUP No such key or consumer groupNo such key or consumer group in stream
• NOTBUSY No scripts in execution right nowNo scripts in execution right now
• DENIED Redis is running in protected modeRedis is running in protected mode
• ERR Can't execute '<cmd>': only (P|S)SUBSCRIBE / (P|S)UNSUBSCRIBE / PING / QUIT / RESET are allowed in this contextCommand not allowed in subscribe context
• ERR SELECT is not allowed in cluster modeSELECT is not allowed in cluster mode
• ERR wrong number of arguments for commandWrong number of arguments for command
• ERR Background save already in progressBackground save already in progress
• ERR bit offset is not an integer or out of rangeBit offset is not an integer or out of range
• ERR Protocol error: invalid multibulk lengthProtocol error: invalid multibulk length
• ERR Number of keys can't be greater than number of argsEVAL/EVALSHA: numkeys exceeds argument count
• ERR WATCH inside MULTI is not allowedWATCH inside MULTI is not allowed
• ERR WAIT cannot be used with replica instancesWAIT cannot be used with replica instances
• ERR Background append only file rewriting already in progressAOF rewrite already in progress
• IOERR error or timeout reading from target instanceMIGRATE: I/O error or timeout to target
• ERR Error compiling script (new function)Error compiling Lua script
• ERR FAILOVER requires connected replicas.FAILOVER requires connected replicas
• ERR invalid expire time in 'set' commandinvalid expire time in SET

Elasticsearch

• cluster_block_exceptionClusterBlockException[blocked by: [TOO_MANY_REQUESTS/12/disk usage exceeded flood-stage watermark, index has read-only-allow-delete block]] (before 7.x: FORBIDDEN/12/index read-only / allow delete (api))
• index_read_only_allow_deleteTOO_MANY_REQUESTS/12/disk usage exceeded flood-stage watermark, index has read-only-allow-delete block (legacy: FORBIDDEN/12/index read-only / allow delete (api))
• high_disk_watermark_exceededhigh disk watermark [90%] exceeded / flood stage disk watermark [95%] exceeded
• circuit_breaking_exceptionCircuitBreakingException[[parent] Data too large, data for [<...>] would be [...], which is larger than the limit of [...]]
• mapper_parsing_exceptionmapper_parsing_exception: failed to parse field [...] of type [...]
• strict_dynamic_mapping_exceptionstrict_dynamic_mapping_exception: mapping set to strict, dynamic introduction of [...] within [...] is not allowed
• illegal_argument_exception_fielddataillegal_argument_exception: Fielddata is disabled on text fields by default. Set fielddata=true on [your_field] in order to load fielddata in memory
• search_phase_execution_exceptionsearch_phase_execution_exception: all shards failed / Failed to execute phase [query]
• too_many_clausestoo_many_clauses: maxClauseCount is set to 1024 (query contains too many clauses)
• version_conflict_engine_exceptionversion_conflict_engine_exception: [_doc][id]: version conflict, current version [x] is different than the one provided [y] (HTTP 409)
• document_missing_exceptiondocument_missing_exception: [_doc][id]: document missing
• index_not_found_exceptionindex_not_found_exception: no such index [index_name] (HTTP 404)
• resource_already_exists_exceptionresource_already_exists_exception: index [index_name/uuid] already exists (HTTP 400)
• cluster_health_redcluster health status: RED / unassigned shards
• no_shard_available_action_exceptionno_shard_available_action_exception: No shard available for [...]
• es_rejected_execution_exceptiones_rejected_execution_exception: rejected execution of ... on ... (queue capacity ...) (HTTP 429)
• master_not_discovered_exceptionmaster_not_discovered_exception / MasterNotDiscoveredException
• security_exceptionsecurity_exception: unable to authenticate / action [...] is unauthorized for user [...] (HTTP 401/403)
• validation_exceptionvalidation_exception / illegal_argument_exception: Validation Failed: ...
• task_cancelled_exceptiontask_cancelled_exception: Task was cancelled / TaskCancelledException
• action_request_validation_exceptionaction_request_validation_exception
• index_closed_exceptionindex_closed_exception
• unavailable_shards_exceptionunavailable_shards_exception
• query_shard_exceptionquery_shard_exception
• script_exceptionscript_exception
• number_format_exceptionnumber_format_exception
• connect_transport_exceptionconnect_transport_exception
• repository_missing_exceptionrepository_missing_exception
• concurrent_snapshot_execution_exceptionconcurrent_snapshot_execution_exception
• invalid_index_name_exceptioninvalid_index_name_exception
• resource_not_found_exceptionresource_not_found_exception
• process_cluster_event_timeout_exceptionprocess_cluster_event_timeout_exception
• search_context_missing_exceptionNo search context found for id (scroll expired)
• aliases_not_found_exceptionAliases missing
• snapshot_missing_exceptionSnapshot is missing
• index_template_missing_exceptionIndex template is missing
• settings_exceptionInvalid settings
• shard_not_found_exceptionShard not found
• not_x_content_exceptionCompressor detection error / body is not valid content
• document_source_missing_exceptionDocument source is missing
• node_not_connected_exceptionNode is not connected
• receive_timeout_transport_exceptionRequest timed out waiting for a response from another node
• routing_missing_exceptionRouting value is required for this document
• too_many_buckets_exceptionTrying to create too many buckets
• shard_lock_obtain_failed_exceptionObtaining shard lock timed out
• parsing_exceptionFailed to parse the search request / query DSL
• max_bytes_length_exceeded_exceptionDocument contains at least one immense term that is too long
• illegal_argument_exception_total_fieldsLimit of total fields has been exceeded
• verification_exceptionverification_exception: Found N problem(s) — Unknown column / Unknown index (ES|QL, SQL, EQL)
• bind_transport_exceptionbind_transport_exception (Address already in use)
• translog_corrupted_exceptiontranslog_corrupted_exception
• recovery_engine_exceptionrecovery_engine_exception
• snapshot_in_progress_exceptionsnapshot_in_progress_exception
• repository_verification_exceptionrepository_verification_exception
• reduce_search_phase_exceptionreduce_search_phase_exception
• aggregation_execution_exceptionaggregation_execution_exception
• failed_node_exceptionfailed_node_exception
• elasticsearch_parse_exceptionelasticsearch_parse_exception