MySQL 8.4.2
Source Code Documentation
db0err.h File Reference

Global error codes for the database. More...

Go to the source code of this file.

Enumerations

enum  dberr_t {
  DB_ERROR_UNSET = 0 , DB_SUCCESS_LOCKED_REC = 9 , DB_SUCCESS = 10 , DB_ERROR ,
  DB_INTERRUPTED , DB_OUT_OF_MEMORY , DB_OUT_OF_FILE_SPACE , DB_OUT_OF_DISK_SPACE ,
  DB_LOCK_WAIT , DB_DEADLOCK , DB_ROLLBACK , DB_DUPLICATE_KEY ,
  DB_MISSING_HISTORY , DB_SKIP_LOCKED , DB_LOCK_NOWAIT , DB_NO_SESSION_TEMP ,
  DB_CLUSTER_NOT_FOUND = 30 , DB_TABLE_NOT_FOUND , DB_MUST_GET_MORE_FILE_SPACE , DB_TABLE_IS_BEING_USED ,
  DB_TOO_BIG_RECORD , DB_LOCK_WAIT_TIMEOUT , DB_NO_REFERENCED_ROW , DB_ROW_IS_REFERENCED ,
  DB_CANNOT_ADD_CONSTRAINT , DB_CORRUPTION , DB_CANNOT_DROP_CONSTRAINT , DB_NO_SAVEPOINT ,
  DB_TABLESPACE_EXISTS , DB_TABLESPACE_DELETED , DB_TABLESPACE_NOT_FOUND , DB_LOCK_TABLE_FULL ,
  DB_FOREIGN_DUPLICATE_KEY , DB_TOO_MANY_CONCURRENT_TRXS , DB_UNSUPPORTED , DB_INVALID_NULL ,
  DB_STATS_DO_NOT_EXIST , DB_FOREIGN_EXCEED_MAX_CASCADE , DB_CHILD_NO_INDEX , DB_PARENT_NO_INDEX ,
  DB_TOO_BIG_INDEX_COL , DB_INDEX_CORRUPT , DB_UNDO_RECORD_TOO_BIG , DB_READ_ONLY ,
  DB_FTS_INVALID_DOCID , DB_TABLE_IN_FK_CHECK , DB_ONLINE_LOG_TOO_BIG , DB_IDENTIFIER_TOO_LONG ,
  DB_FTS_EXCEED_RESULT_CACHE_LIMIT , DB_TEMP_FILE_WRITE_FAIL , DB_CANT_CREATE_GEOMETRY_OBJECT , DB_CANNOT_OPEN_FILE ,
  DB_FTS_TOO_MANY_WORDS_IN_PHRASE , DB_SERVER_VERSION_LOW , DB_TOO_LONG_PATH , DB_IO_ERROR = 100 ,
  DB_IO_DECOMPRESS_FAIL , DB_IO_NO_PUNCH_HOLE , DB_IO_NO_PUNCH_HOLE_FS , DB_IO_NO_PUNCH_HOLE_TABLESPACE ,
  DB_IO_DECRYPT_FAIL , DB_IO_NO_ENCRYPT_TABLESPACE , DB_IO_PARTIAL_FAILED , DB_FORCED_ABORT ,
  DB_TABLE_CORRUPT , DB_WRONG_FILE_NAME , DB_COMPUTE_VALUE_FAILED , DB_NO_FK_ON_S_BASE_COL ,
  DB_INVALID_ENCRYPTION_META , DB_ABORT_INCOMPLETE_CLONE , DB_BTREE_LEVEL_LIMIT_EXCEEDED , DB_DBLWR_NOT_EXISTS ,
  DB_V1_DBLWR_INIT_FAILED , DB_V1_DBLWR_CREATE_FAILED , DB_DBLWR_INIT_FAILED , DB_SCHEMA_MISMATCH ,
  DB_OUT_OF_RESOURCES , DB_PAGE_IS_STALE , DB_AUTOINC_READ_ERROR , DB_FILE_READ_BEYOND_SIZE ,
  DB_DATA_NOT_SORTED , DB_BULK_TOO_BIG_RECORD , DB_FAIL = 1000 , DB_OVERFLOW ,
  DB_UNDERFLOW , DB_STRONG_FAIL , DB_ZIP_OVERFLOW , DB_RECORD_NOT_FOUND = 1500 ,
  DB_END_OF_BLOCK , DB_END_OF_INDEX , DB_END_SAMPLE_READ , DB_NOT_FOUND ,
  DB_DATA_MISMATCH = 2000 , DB_FTS_TOO_MANY_NESTED_EXP
}
 

Detailed Description

Global error codes for the database.

Created 5/24/1996 Heikki Tuuri

Enumeration Type Documentation

◆ dberr_t

enum dberr_t
Enumerator
DB_ERROR_UNSET 
DB_SUCCESS_LOCKED_REC 

like DB_SUCCESS, but a new explicit record lock was created

DB_SUCCESS 
DB_ERROR 
DB_INTERRUPTED 
DB_OUT_OF_MEMORY 
DB_OUT_OF_FILE_SPACE 

The tablespace could not be auto-extending.

DB_OUT_OF_DISK_SPACE 
DB_LOCK_WAIT 
DB_DEADLOCK 
DB_ROLLBACK 
DB_DUPLICATE_KEY 
DB_MISSING_HISTORY 

required history data has been deleted due to lack of space in rollback segment

DB_SKIP_LOCKED 

skip lock

DB_LOCK_NOWAIT 

don't wait lock

DB_NO_SESSION_TEMP 

no session temporary tablespace could be allocated

DB_CLUSTER_NOT_FOUND 
DB_TABLE_NOT_FOUND 
DB_MUST_GET_MORE_FILE_SPACE 

the database has to be stopped and restarted with more file space

DB_TABLE_IS_BEING_USED 
DB_TOO_BIG_RECORD 

a record in an index would not fit on a compressed page, or it would become bigger than 1/2 free space in an uncompressed page frame

DB_LOCK_WAIT_TIMEOUT 

lock wait lasted too long

DB_NO_REFERENCED_ROW 

referenced key value not found for a foreign key in an insert or update of a row

DB_ROW_IS_REFERENCED 

cannot delete or update a row because it contains a key value which is referenced

DB_CANNOT_ADD_CONSTRAINT 

adding a foreign key constraint to a table failed

DB_CORRUPTION 

data structure corruption noticed

DB_CANNOT_DROP_CONSTRAINT 

dropping a foreign key constraint from a table failed

DB_NO_SAVEPOINT 

no savepoint exists with the given name

DB_TABLESPACE_EXISTS 

cannot create a new tablespace because a file of the same name or tablespace ID already exists

DB_TABLESPACE_DELETED 

tablespace was deleted or is being dropped right now

DB_TABLESPACE_NOT_FOUND 

Attempt to delete a tablespace instance that was not found in the tablespace hash table.

DB_LOCK_TABLE_FULL 

lock structs have exhausted the buffer pool (for big transactions, InnoDB stores the lock structs in the buffer pool)

DB_FOREIGN_DUPLICATE_KEY 

foreign key constraints activated by the operation would lead to a duplicate key in some table

DB_TOO_MANY_CONCURRENT_TRXS 

when InnoDB runs out of the preconfigured undo slots, this can only happen when there are too many concurrent transactions

DB_UNSUPPORTED 

when InnoDB sees any artefact or a feature that it can't recoginize or work with e.g., FT indexes created by a later version of the engine.

DB_INVALID_NULL 

a NOT NULL column was found to be NULL during table rebuild

DB_STATS_DO_NOT_EXIST 

an operation that requires the persistent storage, used for recording table and index statistics, was requested but this storage does not exist itself or the stats for a given table do not exist

DB_FOREIGN_EXCEED_MAX_CASCADE 

Foreign key constraint related cascading delete/update exceeds maximum allowed depth.

DB_CHILD_NO_INDEX 

the child (foreign) table does not have an index that contains the foreign keys as its prefix columns

DB_PARENT_NO_INDEX 

the parent table does not have an index that contains the foreign keys as its prefix columns

DB_TOO_BIG_INDEX_COL 

index column size exceeds maximum limit

DB_INDEX_CORRUPT 

we have corrupted index

DB_UNDO_RECORD_TOO_BIG 

the undo log record is too big

DB_READ_ONLY 

Update operation attempted in a read-only transaction.

DB_FTS_INVALID_DOCID 

FTS Doc ID cannot be zero.

DB_TABLE_IN_FK_CHECK 

table is being used in foreign key check

DB_ONLINE_LOG_TOO_BIG 

Modification log grew too big during online index creation.

DB_IDENTIFIER_TOO_LONG 

Identifier name too long.

DB_FTS_EXCEED_RESULT_CACHE_LIMIT 

FTS query memory exceeds result cache limit.

DB_TEMP_FILE_WRITE_FAIL 

Temp file write failure.

DB_CANT_CREATE_GEOMETRY_OBJECT 

Cannot create specified Geometry data object.

DB_CANNOT_OPEN_FILE 

Cannot open a file.

DB_FTS_TOO_MANY_WORDS_IN_PHRASE 

Too many words in a phrase.

DB_SERVER_VERSION_LOW 

Server version is lower than tablespace version.

DB_TOO_LONG_PATH 

The path is too long for the OS.

DB_IO_ERROR 

Generic IO error.

DB_IO_DECOMPRESS_FAIL 

Failure to decompress a page after reading it from disk.

DB_IO_NO_PUNCH_HOLE 

Punch hole not supported by InnoDB.

DB_IO_NO_PUNCH_HOLE_FS 

The file system doesn't support punch hole.

DB_IO_NO_PUNCH_HOLE_TABLESPACE 

The tablespace doesn't support punch hole.

DB_IO_DECRYPT_FAIL 

Failure to decrypt a page after reading it from disk.

DB_IO_NO_ENCRYPT_TABLESPACE 

The tablespace doesn't support encrypt.

DB_IO_PARTIAL_FAILED 

Partial IO request failed.

DB_FORCED_ABORT 

Transaction was forced to rollback by a higher priority transaction.

DB_TABLE_CORRUPT 

Table/clustered index is corrupted.

DB_WRONG_FILE_NAME 

Invalid Filename.

DB_COMPUTE_VALUE_FAILED 

Compute generated value failed.

DB_NO_FK_ON_S_BASE_COL 

Cannot add foreign constrain placed on the base column of stored column.

DB_INVALID_ENCRYPTION_META 

Invalid encryption metadata in page 0.

DB_ABORT_INCOMPLETE_CLONE 

Incomplete cloned directory.

DB_BTREE_LEVEL_LIMIT_EXCEEDED 

Btree level limit exceeded.

DB_DBLWR_NOT_EXISTS 

Doublewrite meta data not found in the system space header.

DB_V1_DBLWR_INIT_FAILED 

Failed to initialize the doublewrite extents in the system tablespace.

DB_V1_DBLWR_CREATE_FAILED 

Failed to create the doublewrite extents in the system tablespace.

DB_DBLWR_INIT_FAILED 

Failed to initialize the double write memory data structures.

DB_SCHEMA_MISMATCH 
DB_OUT_OF_RESOURCES 

System has run out of resources.

DB_PAGE_IS_STALE 

Page was discarded, was not written to storage.

DB_AUTOINC_READ_ERROR 

Error reading the auto-increment value.

DB_FILE_READ_BEYOND_SIZE 

Failed to read as read was beyond file size.

DB_DATA_NOT_SORTED 

Data is not in sorted order.

DB_BULK_TOO_BIG_RECORD 

The record size is too big for LOAD BULK DATA operation.

DB_FAIL 
DB_OVERFLOW 
DB_UNDERFLOW 
DB_STRONG_FAIL 
DB_ZIP_OVERFLOW 
DB_RECORD_NOT_FOUND 
DB_END_OF_BLOCK 
DB_END_OF_INDEX 
DB_END_SAMPLE_READ 
DB_NOT_FOUND 

Generic error code for "Not found" type of errors.

DB_DATA_MISMATCH 

Column update or read failed because the types mismatch.

DB_FTS_TOO_MANY_NESTED_EXP