MySQL  8.0.12
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_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_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_FAIL = 1000,
  DB_OVERFLOW, DB_UNDERFLOW, DB_STRONG_FAIL, DB_ZIP_OVERFLOW,
  DB_RECORD_NOT_FOUND = 1500, DB_END_OF_INDEX, DB_NOT_FOUND, DB_DATA_MISMATCH = 2000
}
 

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_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 

we cannot create a new single-table tablespace because a file of the same name 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 
DB_TABLE_IN_FK_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 
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 encrytion metadata in page 0.

DB_FAIL 
DB_OVERFLOW 
DB_UNDERFLOW 
DB_STRONG_FAIL 
DB_ZIP_OVERFLOW 
DB_RECORD_NOT_FOUND 
DB_END_OF_INDEX 
DB_NOT_FOUND 

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

DB_DATA_MISMATCH 

Column update or read failed because the types mismatch.