Skip to content

MySQL Error Mapping

This page lists how native MySQL database or driver errors are represented as TsSqlErrorReason values. The table uses the same row catalog and row order as the other native database pages, so a - means this semantic case is not currently mapped for MySQL.

Database error shows the values exposed through databaseErrorCode and databaseErrorNumber when both are available. Connector-only signals include the connector inline. SQL_UNKNOWN is intentionally the last row.

Semantically classified mapper-known codes are listed individually. Broad SQLSTATE, registry, range, or message-pattern fallbacks are summarized when the mapper intentionally handles an open-ended family of errors; if the same native code appears in more than one row, the driver message determines the final mapped reason.

Category Reason Database error Filled fields
Constraints SQL_CONSTRAINT_VIOLATED
constraintType
unique
ER_DUP_KEY / 1022: unique constraint violation
ER_DUP_ENTRY / 1062: unique constraint violation
ER_DUP_UNIQUE / 1169: unique constraint violation
ER_FOREIGN_DUPLICATE_KEY_OLD_UNUSED / 1557: unique constraint violation
ER_DUP_ENTRY_WITH_KEY_NAME / 1586: unique constraint violation
ER_FOREIGN_DUPLICATE_KEY_WITH_CHILD_INFO / 1761: unique constraint violation
ER_FOREIGN_DUPLICATE_KEY_WITHOUT_CHILD_INFO / 1762: unique constraint violation
ER_DUP_UNKNOWN_IN_INDEX / 1859: unique constraint violation
ER_INTERSECT_ALL_MAX_DUPLICATES_EXCEEDED / 4120: unique constraint violation
constraintType
constraintName when inferred
tableName when inferred
columnName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Constraints SQL_CONSTRAINT_VIOLATED
constraintType
not null
ER_BAD_NULL_ERROR / 1048: not null constraint violation
ER_BAD_NULL_ERROR_NOT_IGNORED / 3673: not null constraint violation
constraintType
constraintName when inferred
tableName when inferred
columnName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Constraints SQL_CONSTRAINT_VIOLATED
constraintType
foreign key
ER_NO_REFERENCED_ROW / 1216: foreign key constraint violation
ER_ROW_IS_REFERENCED / 1217: foreign key constraint violation
ER_ROW_IS_REFERENCED_2 / 1451: foreign key constraint violation
ER_NO_REFERENCED_ROW_2 / 1452: foreign key constraint violation
ER_FK_DEPTH_EXCEEDED / 3008: foreign key constraint violation
ER_USER_REFERENCED_AS_DEFINER / 4005: foreign key constraint violation
ER_CANNOT_USER_REFERENCED_AS_DEFINER / 4006: foreign key constraint violation
constraintType
constraintName when inferred
tableName when inferred
columnName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Constraints SQL_CONSTRAINT_VIOLATED
constraintType
check
ER_CHECK_CONSTRAINT_VIOLATED / 3819: check constraint violation constraintType
constraintName when inferred
tableName when inferred
columnName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Constraints SQL_CONSTRAINT_VIOLATED
constraintType
exclusion
- -
Constraints SQL_CONSTRAINT_VIOLATED
constraintType
restrict
- -
Constraints SQL_CONSTRAINT_VIOLATED server constraint sets above databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Values SQL_INVALID_VALUE
errorType
too long
ER_TOO_LONG_STRING / 1162: too long
ER_DATA_TOO_LONG / 1406: too long
ER_STD_LENGTH_ERROR / 3046: too long
ER_CHANGE_SOURCE_PASSWORD_LENGTH / 3056: too long
ER_JSON_VALUE_TOO_BIG / 3150: too long
ER_JSON_KEY_TOO_BIG / 3151: too long
ER_SRS_ATTRIBUTE_STRING_TOO_LONG / 3718: too long
ER_FUNCTIONAL_INDEX_DATA_IS_TOO_LONG / 3907: too long
ER_CANT_SET_PERSISTED / 4159: too long
errorType
tableName when inferred
columnName when inferred
typeName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Values SQL_INVALID_VALUE
errorType
out of range
ER_WARN_DATA_OUT_OF_RANGE / 1264: out of range
ER_DATA_OUT_OF_RANGE / 1690: out of range
ER_INVALID_ARGUMENT_FOR_LOGARITHM / 3020: out of range
ER_STD_OUT_OF_RANGE_ERROR / 3048: out of range
ER_STD_OVERFLOW_ERROR / 3049: out of range
ER_STD_RANGE_ERROR / 3050: out of range
ER_STD_UNDERFLOW_ERROR / 3051: out of range
ER_NUMERIC_JSON_VALUE_OUT_OF_RANGE / 3155: out of range
ER_JT_VALUE_OUT_OF_RANGE / 3669: out of range
ER_NONPOSITIVE_RADIUS / 3706: out of range
ER_SRS_INVALID_SEMI_MAJOR_AXIS / 3737: out of range
ER_SRS_INVALID_INVERSE_FLATTENING / 3738: out of range
ER_SRS_INVALID_ANGULAR_UNIT / 3739: out of range
ER_SRS_INVALID_PRIME_MERIDIAN / 3740: out of range
ER_INNODB_AUTOEXTEND_SIZE_OUT_OF_RANGE / 4025: out of range
ER_SRS_INVALID_LATITUDE_OF_ORIGIN / 4105: out of range
ER_SRS_INVALID_LONGITUDE_OF_ORIGIN / 4106: out of range
ER_SRS_INVALID_HEIGHT / 4124: out of range
ER_SRS_INVALID_SCALING / 4125: out of range
ER_SRS_INVALID_ZONE_WIDTH / 4126: out of range
ER_SRS_INVALID_LATITUDE_POLAR_STERE_VAR_A / 4127: out of range
errorType
tableName when inferred
columnName when inferred
typeName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Values SQL_INVALID_VALUE
errorType
invalid value
ER_TRUNCATED_WRONG_VALUE / 1292: invalid value
ER_TRUNCATED_WRONG_VALUE_FOR_FIELD / 1366: invalid value
ER_ILLEGAL_VALUE_FOR_TYPE / 1367: invalid value
ER_WRONG_VALUE_FOR_TYPE / 1411: invalid value
ER_CANT_CREATE_GEOMETRY_OBJECT / 1416: invalid value
CR_DATA_TRUNCATED / 2032: invalid value
errorType
tableName when inferred
columnName when inferred
typeName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Values SQL_INVALID_VALUE
errorType
invalid format
- -
Values SQL_INVALID_VALUE
errorType
invalid encoding
- -
Values SQL_INVALID_VALUE
errorType
invalid json
ER_INVALID_JSON_TEXT / 3140: invalid json
ER_INVALID_JSON_TEXT_IN_PARAM / 3141: invalid json
ER_INVALID_JSON_CHARSET / 3144: invalid json
ER_INVALID_JSON_CHARSET_IN_FUNCTION / 3145: invalid json
ER_INVALID_TYPE_FOR_JSON / 3146: invalid json
ER_INVALID_CAST_TO_JSON / 3147: invalid json
ER_INVALID_JSON_VALUE_FOR_CAST / 3156: invalid json
ER_JSON_DOCUMENT_TOO_DEEP / 3157: invalid json
ER_JSON_DOCUMENT_NULL_KEY / 3158: invalid json
ER_INVALID_JSON_TYPE / 3853: invalid json
ER_INVALID_JSON_VALUE_FOR_FUNC_INDEX / 3903: invalid json
ER_MISSING_JSON_VALUE / 3966: invalid json
ER_MULTIPLE_JSON_VALUES / 3967: invalid json
ER_WARN_AUDIT_LOG_FORMAT_UNIX_TIMESTAMP_ONLY_WHEN_JSON / 4051: invalid json
errorType
tableName when inferred
columnName when inferred
typeName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Values SQL_INVALID_VALUE
errorType
invalid xml
- -
Values SQL_INVALID_VALUE
errorType
invalid regular expression
ER_REGEXP_ERROR / 1139: invalid regular expression errorType
tableName when inferred
columnName when inferred
typeName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Values SQL_INVALID_VALUE
errorType
null not allowed
ER_INVALID_USE_OF_NULL / 1138: null not allowed
ER_WARN_NULL_TO_NOTNULL / 1263: null not allowed
errorType
tableName when inferred
columnName when inferred
typeName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Values SQL_INVALID_VALUE
errorType
sequence limit
- -
Parameters SQL_INVALID_PARAMETER
parameterErrorType
missing
ER_WRONG_ARGUMENTS / 1210: missing parameter when the message indicates an unbound or missing argument
ER_NO_DEFAULT / 1230: missing parameter when the message reports a missing default or value
CR_PARAMS_NOT_BOUND / 2031: missing parameter when the message reports an unbound parameter
parameterErrorType
parameterName when inferred
parameterIndex when inferred
expectedParameterCount when inferred
actualParameterCount when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Parameters SQL_INVALID_PARAMETER
parameterErrorType
too many
- -
Parameters SQL_INVALID_PARAMETER
parameterErrorType
wrong count
ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT / 1582: wrong count parameter when the message reports parameter-count details
ER_WRONG_PARAMETERS_TO_NATIVE_FCT / 1583: wrong count parameter when the message reports parameter-count details
ER_WRONG_PARAMETERS_TO_STORED_FCT / 1584: wrong count parameter when the message reports parameter-count details
ER_SP_WRONG_NO_OF_ARGS / 1318: wrong count parameter when the message reports the wrong number of arguments
ERR_MYSQL_WRONG_NUMBER_OF_PARAMETERS_PROVIDED (Bun SQL): wrong count parameter
parameterErrorType
parameterName when inferred
parameterIndex when inferred
expectedParameterCount when inferred
actualParameterCount when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Parameters SQL_INVALID_PARAMETER
parameterErrorType
invalid name
- -
Parameters SQL_INVALID_PARAMETER
parameterErrorType
invalid index
- -
Parameters SQL_INVALID_PARAMETER
parameterErrorType
invalid type
CR_NO_PARAMETERS_EXISTS / 2033: invalid type parameter when the message reports an unsupported parameter type
CR_INVALID_PARAMETER_NO / 2034: invalid type parameter when the message reports an unsupported parameter type
CR_INVALID_BUFFER_USE / 2035: invalid type parameter when the message reports an unsupported buffer type
CR_UNSUPPORTED_PARAM_TYPE / 2036: invalid type parameter when the message reports an unsupported parameter type
ER_WRONG_VALUE_FOR_VAR / 1231: invalid type parameter when the message reports an incorrect argument type
ER_WRONG_TYPE_FOR_VAR / 1232: invalid type parameter when the message reports an incorrect argument type
parameterErrorType
parameterName when inferred
parameterIndex when inferred
expectedParameterCount when inferred
actualParameterCount when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Parameters SQL_INVALID_PARAMETER
parameterErrorType
invalid value
ER_WRONG_PARAMCOUNT_TO_PROCEDURE / 1107: invalid value parameter
ER_WRONG_PARAMETERS_TO_PROCEDURE / 1108: invalid value parameter
ER_WRONG_ARGUMENTS / 1210: invalid value parameter when no more specific parameter subtype is inferred from the message
ER_NO_DEFAULT / 1230: invalid value parameter when no more specific parameter subtype is inferred from the message
ER_WRONG_VALUE_FOR_VAR / 1231: invalid value parameter when no more specific parameter subtype is inferred from the message
ER_WRONG_TYPE_FOR_VAR / 1232: invalid value parameter when no more specific parameter subtype is inferred from the message
ER_BAD_REPLICA_UNTIL_COND / 1277: invalid value parameter
ER_SP_WRONG_NO_OF_ARGS / 1318: invalid value parameter when no more specific parameter subtype is inferred from the message
ER_SP_DUP_PARAM / 1330: invalid value parameter
ER_SP_DUP_VAR / 1331: invalid value parameter
ER_SP_DUP_COND / 1332: invalid value parameter
ER_SP_DUP_CURS / 1333: invalid value parameter
ER_SP_NOT_VAR_ARG / 1414: invalid value parameter
ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT / 1582: invalid value parameter when no more specific parameter subtype is inferred from the message
ER_WRONG_PARAMETERS_TO_NATIVE_FCT / 1583: invalid value parameter when no more specific parameter subtype is inferred from the message
ER_WRONG_PARAMETERS_TO_STORED_FCT / 1584: invalid value parameter when no more specific parameter subtype is inferred from the message
ER_DA_INVALID_CONDITION_NUMBER / 1758: invalid value parameter
CR_PARAMS_NOT_BOUND / 2031: invalid value parameter when no more specific parameter subtype is inferred from the message
CR_NO_PARAMETERS_EXISTS / 2033: invalid value parameter when no more specific parameter subtype is inferred from the message
CR_INVALID_PARAMETER_NO / 2034: invalid value parameter when no more specific parameter subtype is inferred from the message
CR_INVALID_BUFFER_USE / 2035: invalid value parameter when no more specific parameter subtype is inferred from the message
CR_UNSUPPORTED_PARAM_TYPE / 2036: invalid value parameter when no more specific parameter subtype is inferred from the message
CR_DUPLICATE_CONNECTION_ATTR / 2060: invalid value parameter
CR_INVALID_FACTOR_NO / 2072: invalid value parameter
parameterErrorType
parameterName when inferred
parameterIndex when inferred
expectedParameterCount when inferred
actualParameterCount when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Parameters SQL_INVALID_PARAMETER
parameterErrorType
invalid binding
ERR_MYSQL_INVALID_QUERY_BINDING (Bun SQL): invalid binding parameter
ERR_MYSQL_NOT_TAGGED_CALL (Bun SQL): invalid binding parameter
parameterErrorType
parameterName when inferred
parameterIndex when inferred
expectedParameterCount when inferred
actualParameterCount when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Parameters SQL_INVALID_PARAMETER
parameterErrorType
not bindable
Bun SQL simple query parameter message: not bindable parameter parameterErrorType
parameterName when inferred
parameterIndex when inferred
expectedParameterCount when inferred
actualParameterCount when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Parameters SQL_INVALID_PARAMETER
parameterErrorType
already bound
- -
Parameters SQL_INVALID_PARAMETER - -
Object not found SQL_OBJECT_NOT_FOUND
objectType
database
ER_DB_DROP_EXISTS / 1008: database not found
ER_NO_DB_ERROR / 1046: database not found
ER_BAD_DB_ERROR / 1049: database not found
ER_NO_SUCH_DB / 3503: database not found
objectType
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object not found SQL_OBJECT_NOT_FOUND
objectType
schema
- -
Object not found SQL_OBJECT_NOT_FOUND
objectType
table or view
ER_BAD_TABLE_ERROR / 1051: table or view not found
ER_UNKNOWN_TABLE / 1109: table or view not found
ER_NO_SUCH_TABLE / 1146: table or view not found
objectType
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object not found SQL_OBJECT_NOT_FOUND
objectType
column
ER_BAD_FIELD_ERROR / 1054: column not found
ER_KEY_COLUMN_DOES_NOT_EXITS / 1072: column not found
objectType
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object not found SQL_OBJECT_NOT_FOUND
objectType
routine
ER_UNKNOWN_PROCEDURE / 1106: routine not found
ER_CANT_FIND_UDF / 1122: routine not found
ER_FUNCTION_NOT_DEFINED / 1128: routine not found
ER_SP_DOES_NOT_EXIST / 1305: routine not found
ER_FUNC_INEXISTENT_NAME_COLLISION / 1630: routine not found
objectType
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object not found SQL_OBJECT_NOT_FOUND
objectType
sequence
- -
Object not found SQL_OBJECT_NOT_FOUND
objectType
collation
EE_UNKNOWN_COLLATION / 28: collation not found objectType
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object not found SQL_OBJECT_NOT_FOUND
objectType
index
ER_CANT_DROP_FIELD_OR_KEY / 1091: index not found
ER_KEY_DOES_NOT_EXITS / 1176: index not found
ER_FT_MATCHING_KEY_NOT_FOUND / 1191: index not found
objectType
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object not found SQL_OBJECT_NOT_FOUND
objectType
trigger
- -
Object not found SQL_OBJECT_NOT_FOUND
objectType
cursor
- -
Object not found SQL_OBJECT_NOT_FOUND
objectType
prepared statement
- -
Object not found SQL_OBJECT_NOT_FOUND
objectType
role
- -
Object not found SQL_OBJECT_NOT_FOUND ER_SRS_NOT_FOUND / 3548: object not found
ER_UNIT_NOT_FOUND / 3902: object not found
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object already exists SQL_OBJECT_ALREADY_EXISTS
objectType
database
ER_DB_CREATE_EXISTS / 1007: database already exists objectType
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object already exists SQL_OBJECT_ALREADY_EXISTS
objectType
schema
- -
Object already exists SQL_OBJECT_ALREADY_EXISTS
objectType
table or view
ER_TABLE_EXISTS_ERROR / 1050: table or view already exists objectType
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object already exists SQL_OBJECT_ALREADY_EXISTS
objectType
column
ER_DUP_FIELDNAME / 1060: column already exists
ER_FIELD_SPECIFIED_TWICE / 1110: column already exists
objectType
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object already exists SQL_OBJECT_ALREADY_EXISTS
objectType
routine
ER_UDF_EXISTS / 1125: routine already exists
ER_SP_ALREADY_EXISTS / 1304: routine already exists
objectType
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object already exists SQL_OBJECT_ALREADY_EXISTS
objectType
sequence
- -
Object already exists SQL_OBJECT_ALREADY_EXISTS
objectType
index
ER_DUP_KEYNAME / 1061: index already exists objectType
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object already exists SQL_OBJECT_ALREADY_EXISTS
objectType
trigger
- -
Object already exists SQL_OBJECT_ALREADY_EXISTS
objectType
cursor
- -
Object already exists SQL_OBJECT_ALREADY_EXISTS
objectType
prepared statement
- -
Object already exists SQL_OBJECT_ALREADY_EXISTS ER_SRS_ID_ALREADY_EXISTS / 3712: object already exists databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object state SQL_OBJECT_STATE_ERROR
objectStateErrorType
invalid state
ER_SP_CURSOR_ALREADY_OPEN / 1325: invalid state
ER_SP_CURSOR_NOT_OPEN / 1326: invalid state
objectStateErrorType
objectType when inferred
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Object state SQL_OBJECT_STATE_ERROR
objectStateErrorType
wrong object type
- -
Object state SQL_OBJECT_STATE_ERROR
objectStateErrorType
object in use
- -
Object state SQL_OBJECT_STATE_ERROR
objectStateErrorType
dependent objects still exist
ER_CANT_MODIFY_SRS_USED_BY_COLUMN / 3716: dependent objects still exist objectStateErrorType
objectType when inferred
schemaName when inferred
tableName when inferred
columnName when inferred
objectName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Statement SQL_SYNTAX_ERROR ER_PARSE_ERROR / 1064: syntax error
ER_SYNTAX_ERROR / 1149: syntax error
ER_DA_NO_ERROR_LOG_PARSER_CONFIGURED / 4001: syntax error
ER_BULK_PARSER_MISSING_ENCLOSED_BY / 4143: syntax error
ER_BULK_PARSER_ROW_BUFFER_MAX_TOTAL_COLS_EXCEEDED / 4144: syntax error
ER_BULK_PARSER_UNEXPECTED_CHAR_AFTER_COLUMN_TERMINATOR / 4150: syntax error
ER_BULK_PARSER_INCOMPLETE_ESCAPE_SEQUENCE / 4151: syntax error
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Statement SQL_AMBIGUOUS_IDENTIFIER
identifierErrorType
ambiguous
ER_NON_UNIQ_ERROR / 1052: ambiguous identifier identifier when inferred
identifierType when inferred
identifierErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Statement SQL_AMBIGUOUS_IDENTIFIER
identifierErrorType
duplicate
ER_NONUNIQ_TABLE / 1066: duplicate identifier identifier when inferred
identifierType when inferred
identifierErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Statement SQL_AMBIGUOUS_IDENTIFIER - -
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
incomplete statement
- -
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
invalid definition
ER_CANT_CREATE_TABLE / 1005: invalid definition
ER_WRONG_FIELD_SPEC / 1063: invalid definition
ER_INVALID_DEFAULT / 1067: invalid definition
ER_MULTIPLE_PRI_KEY / 1068: invalid definition
ER_TOO_MANY_KEYS / 1069: invalid definition
ER_TOO_MANY_KEY_PARTS / 1070: invalid definition
ER_TOO_LONG_KEY / 1071: invalid definition
ER_BLOB_USED_AS_KEY / 1073: invalid definition
ER_TOO_BIG_FIELDLENGTH / 1074: invalid definition
ER_WRONG_AUTO_KEY / 1075: invalid definition
ER_WRONG_SUB_KEY / 1089: invalid definition
ER_BLOB_CANT_HAVE_DEFAULT / 1101: invalid definition
ER_TABLE_MUST_HAVE_COLUMNS / 1113: invalid definition
ER_NULL_COLUMN_IN_INDEX / 1121: invalid definition
ER_WRONG_COLUMN_NAME / 1166: invalid definition
ER_WRONG_KEY_COLUMN / 1167: invalid definition
ER_BLOB_KEY_WITHOUT_LENGTH / 1170: invalid definition
ER_PRIMARY_CANT_HAVE_NULL / 1171: invalid definition
ER_REQUIRES_PRIMARY_KEY / 1173: invalid definition
ER_CANNOT_ADD_FOREIGN / 1215: invalid definition
ER_WRONG_FK_DEF / 1239: invalid definition
ER_SPATIAL_CANT_HAVE_NULL / 1252: invalid definition
ER_WRONG_NAME_FOR_INDEX / 1280: invalid definition
ER_WRONG_NAME_FOR_CATALOG / 1281: invalid definition
ER_SP_NORETURN / 1320: invalid definition
ER_SP_BAD_CURSOR_QUERY / 1322: invalid definition
ER_SP_BAD_CURSOR_SELECT / 1323: invalid definition
ER_SP_UNDECLARED_VAR / 1327: invalid definition
ER_SP_VARCOND_AFTER_CURSHNDLR / 1337: invalid definition
ER_SP_CURSOR_AFTER_HANDLER / 1338: invalid definition
ER_SP_BAD_SQLSTATE / 1407: invalid definition
ER_TOO_BIG_SCALE / 1425: invalid definition
ER_TOO_BIG_PRECISION / 1426: invalid definition
ER_M_BIGGER_THAN_D / 1427: invalid definition
ER_TOO_BIG_DISPLAYWIDTH / 1439: invalid definition
ER_SP_BAD_VAR_SHADOW / 1453: invalid definition
ER_SP_WRONG_NAME / 1458: invalid definition
ER_CANNOT_DISCARD_TEMPORARY_TABLE / 3007: invalid definition
ER_MISSING_HA_CREATE_OPTION / 3014: invalid definition
ER_NO_FT_MATERIALIZED_SUBQUERY / 3018: invalid definition
ER_TABLE_NO_PRIMARY_KEY / 4130: invalid definition
ER_REQUIRE_TABLE_PRIMARY_KEY_CHECK_GENERATE_WITH_GR / 4155: invalid definition
statementErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
type mismatch
- -
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
invalid statement context
ER_CANT_REMOVE_ALL_FIELDS / 1090: invalid statement context
ER_NO_TABLES_USED / 1096: invalid statement context
ER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE / 1175: invalid statement context
ER_LOCK_OR_ACTIVE_TRANSACTION / 1192: invalid statement context
ER_SET_CONSTANTS_ONLY / 1204: invalid statement context
ER_WRONG_USAGE / 1221: invalid statement context
ER_DUP_ARGUMENT / 1225: invalid statement context
ER_LOCAL_VARIABLE / 1228: invalid statement context
ER_GLOBAL_VARIABLE / 1229: invalid statement context
ER_VAR_CANT_BE_READ / 1233: invalid statement context
ER_CANT_USE_OPTION_HERE / 1234: invalid statement context
ER_UNKNOWN_STMT_HANDLER / 1243: invalid statement context
ER_SP_BADRETURN / 1313: invalid statement context
ER_SP_CURSOR_MISMATCH / 1324: invalid statement context
ER_GET_STACKED_DA_WITHOUT_ACTIVE_HANDLER / 3004: invalid statement context
ER_PASSWORD_EXPIRE_ANONYMOUS_USER / 3016: invalid statement context
ER_COMMAND_SERVICE_BACKEND_FAILED / 4116: invalid statement context
statementErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
invalid identifier
ER_TOO_LONG_IDENT / 1059: invalid identifier
ER_WRONG_DB_NAME / 1102: invalid identifier
ER_WRONG_TABLE_NAME / 1103: invalid identifier
ER_SP_LILABEL_MISMATCH / 1308: invalid identifier
ER_SP_LABEL_REDEFINE / 1309: invalid identifier
ER_SP_LABEL_MISMATCH / 1310: invalid identifier
ER_USER_LOCK_WRONG_NAME / 3057: invalid identifier
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_COLUMN_TYPE_INSTANT / 4083: invalid identifier
statementErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
invalid reference
ER_UPDATE_TABLE_USED / 1093: invalid reference
ER_KEY_REF_DO_NOT_MATCH_TABLE_REF / 1240: invalid reference
ER_ILLEGAL_REFERENCE / 1247: invalid reference
ER_TABLENAME_NOT_ALLOWED_HERE / 1250: invalid reference
ER_TABLE_NOT_EMPTY / 4129: invalid reference
statementErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
invalid grouping
ER_WRONG_FIELD_WITH_GROUP / 1055: invalid grouping
ER_WRONG_GROUP_FIELD / 1056: invalid grouping
ER_WRONG_SUM_SELECT / 1057: invalid grouping
ER_INVALID_GROUP_FUNC_USE / 1111: invalid grouping
ER_MIX_OF_GROUP_FUNC_AND_FIELDS / 1140: invalid grouping
ER_NON_GROUPING_FIELD_USED / 1463: invalid grouping
ER_AGGREGATE_ORDER_FOR_UNION / 3028: invalid grouping
ER_AGGREGATE_ORDER_NON_AGG_QUERY / 3029: invalid grouping
statementErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
invalid windowing
- -
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
invalid recursion
- -
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
invalid locator
- -
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
case not found
- -
Statement SQL_INVALID_SQL_STATEMENT
statementErrorType
invalid argument
- -
Statement SQL_INVALID_SQL_STATEMENT ER_WRONG_OUTER_JOIN_UNUSED / 1120: invalid SQL statement
ER_CANT_CHANGE_TX_CHARACTERISTICS / 1568: invalid SQL statement
ER_CANT_USE_SAME_UUID_AS_GROUP_NAME / 4021: invalid SQL statement
ER_INNODB_INVALID_AUTOEXTEND_SIZE_VALUE / 4023: invalid SQL statement
ER_INVALID_CAST_TO_GEOMETRY / 4032: invalid SQL statement
ER_SDI_GET_KEYS_INVALID_TABLESPACE / 4036: invalid SQL statement
ER_CANT_USE_SAME_UUID_AS_VIEW_CHANGE_UUID / 4039: invalid SQL statement
ER_INVALID_ASSIGNMENT_TARGET / 4048: invalid SQL statement
ER_INVALID_USER_FOR_REGISTRATION / 4060: invalid SQL statement
ER_MFA_METHODS_INVALID_ORDER / 4062: invalid SQL statement
ER_INVALID_MFA_OPERATIONS_FOR_PASSWORDLESS_USER / 4064: invalid SQL statement
ER_DEFINITION_CONTAINS_INVALID_STRING / 4089: invalid SQL statement
ER_BAD_TIMESTAMP_FORMAT / 4122: invalid SQL statement
ER_CANT_RUN_COMMAND_SERVICES_RECURSIVELY / 4167: invalid SQL statement
ER_* / MY-* wrong, bad, invalid, illegal, cant, or missing fallback: invalid SQL statement
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Execution SQL_DIVISION_BY_ZERO ER_DIVISION_BY_ZERO / 1365: division by zero databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Execution SQL_CARDINALITY_VIOLATION ER_WRONG_VALUE_COUNT / 1058: cardinality violation
ER_WRONG_VALUE_COUNT_ON_ROW / 1136: cardinality violation
ER_TOO_MANY_ROWS / 1172: cardinality violation
ER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT / 1222: cardinality violation
ER_OPERAND_COLUMNS / 1241: cardinality violation
ER_SUBQUERY_NO_1_ROW / 1242: cardinality violation
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Execution SQL_ROUTINE_ERROR - -
Transactions TRANSACTION_ERROR
transactionErrorType
invalid state
ERR_MYSQL_INVALID_TRANSACTION_STATE (Bun SQL): invalid state transactionErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Transactions TRANSACTION_ERROR
transactionErrorType
aborted
- -
Transactions TRANSACTION_ERROR
transactionErrorType
active transaction
ER_CANT_DO_THIS_DURING_AN_TRANSACTION / 1179: active transaction transactionErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Transactions TRANSACTION_ERROR
transactionErrorType
serialization failure
- -
Transactions TRANSACTION_ERROR
transactionErrorType
deadlock
ER_LOCK_DEADLOCK / 1213: deadlock
ER_XA_RBDEADLOCK / 1614: deadlock
transactionErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Transactions TRANSACTION_ERROR
transactionErrorType
transaction rolled back
ER_ERROR_DURING_COMMIT / 1180: transaction rolled back
ER_ERROR_DURING_ROLLBACK / 1181: transaction rolled back
ER_WARNING_NOT_COMPLETE_ROLLBACK / 1196: transaction rolled back
ER_XA_RBROLLBACK / 1402: transaction rolled back
ER_TRANSACTION_ROLLBACK_DURING_COMMIT / 3101: transaction rolled back
transactionErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Transactions TRANSACTION_ERROR
transactionErrorType
outcome unknown
- -
Transactions TRANSACTION_ERROR
transactionErrorType
invalid savepoint
- -
Transactions TRANSACTION_ERROR
transactionErrorType
unsupported operation
ERR_MYSQL_UNSAFE_TRANSACTION (Bun SQL): unsupported operation transactionErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Transactions NOT_IN_TRANSACTION raised directly by ts-sql-query transaction state checks driver-mapped cases fill databaseErrorCode, databaseErrorNumber when available, and databaseErrorMessage; direct checks fill no extra fields
Transactions NESTED_TRANSACTION_NOT_SUPPORTED raised directly by ts-sql-query nested transaction checks driver-mapped cases fill databaseErrorCode, databaseErrorNumber when available, and databaseErrorMessage; direct checks fill no extra fields
Transactions FORBIDDEN_CONCURRENT_USAGE raised directly by query-runner concurrent usage checks driver-mapped cases fill databaseErrorCode, databaseErrorNumber when available, and databaseErrorMessage; direct checks fill no extra fields
Transactions TRANSACTION_LEVEL_NOT_SUPPORTED raised directly by query runners that reject the isolation level transactionLevel
Transactions TRANSACTION_ACCESS_MODE_NOT_SUPPORTED raised directly by query runners that reject the transaction access mode accessMode
Timeouts SQL_TIMEOUT
timeoutType
connection
ER_NET_READ_INTERRUPTED / 1159: connection timeout
ER_NET_WRITE_INTERRUPTED / 1161: connection timeout
ER_STOP_REPLICA_MONITOR_IO_THREAD_TIMEOUT / 4011: connection timeout
PROTOCOL_SEQUENCE_TIMEOUT (mysql2): connection timeout
ETIMEDOUT (mysql2): connection timeout
ESOCKETTIMEDOUT (mysql2): connection timeout
timeoutType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Timeouts SQL_TIMEOUT
timeoutType
lock
ER_LOCK_WAIT_TIMEOUT / 1205: lock timeout
ER_XA_RBTIMEOUT / 1613: lock timeout
ER_USER_LOCK_DEADLOCK / 3058: lock timeout
ER_* / MY-* lock fallback: lock timeout
timeoutType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Timeouts SQL_TIMEOUT
timeoutType
statement
- -
Timeouts SQL_TIMEOUT
timeoutType
transaction
- -
Timeouts SQL_TIMEOUT
timeoutType
idle transaction
- -
Timeouts SQL_TIMEOUT
timeoutType
cancelled
ER_QUERY_INTERRUPTED / 1317: cancelled timeout
ERR_MYSQL_QUERY_CANCELLED (Bun SQL): cancelled timeout
timeoutType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Timeouts SQL_TIMEOUT
timeoutType
database file busy
- -
Connections SQL_CONNECTION_ERROR
errorType
connection lost
ER_HANDSHAKE_ERROR / 1043: connection lost
ER_UNKNOWN_COM_ERROR / 1047: connection lost
ER_SERVER_SHUTDOWN / 1053: connection lost
ER_FORCING_CLOSE / 1080: connection lost
ER_IPSOCK_ERROR / 1081: connection lost
ER_ABORTING_CONNECTION / 1152: connection lost
ER_NET_READ_ERROR_FROM_PIPE / 1154: connection lost
ER_NET_FCNTL_ERROR / 1155: connection lost
ER_NET_PACKETS_OUT_OF_ORDER / 1156: connection lost
ER_NET_UNCOMPRESS_ERROR / 1157: connection lost
ER_NET_READ_ERROR / 1158: connection lost
ER_NET_ERROR_ON_WRITE / 1160: connection lost
ER_NEW_ABORTING_CONNECTION / 1184: connection lost
ER_SOURCE_NET_READ / 1189: connection lost
ER_SOURCE_NET_WRITE / 1190: connection lost
ER_CONNECT_TO_SOURCE / 1218: connection lost
CR_SOCKET_CREATE_ERROR / 2001: connection lost
CR_CONNECTION_ERROR / 2002: connection lost
CR_CONN_HOST_ERROR / 2003: connection lost
CR_IPSOCK_ERROR / 2004: connection lost
CR_SERVER_GONE_ERROR / 2006: connection lost
CR_VERSION_ERROR / 2007: connection lost
CR_WRONG_HOST_INFO / 2009: connection lost
CR_SERVER_HANDSHAKE_ERR / 2012: connection lost
CR_SERVER_LOST / 2013: connection lost
CR_NAMEDPIPEWAIT_ERROR / 2016: connection lost
CR_NAMEDPIPEOPEN_ERROR / 2017: connection lost
CR_NAMEDPIPESETSTATE_ERROR / 2018: connection lost
CR_PROBE_REPLICA_CONNECT / 2024: connection lost
CR_PROBE_SOURCE_CONNECT / 2025: connection lost
CR_MALFORMED_PACKET / 2027: connection lost
CR_SHARED_MEMORY_CONNECT_REQUEST_ERROR / 2038: connection lost
CR_SHARED_MEMORY_CONNECT_ANSWER_ERROR / 2039: connection lost
CR_SHARED_MEMORY_CONNECT_FILE_MAP_ERROR / 2040: connection lost
CR_SHARED_MEMORY_CONNECT_MAP_ERROR / 2041: connection lost
CR_SHARED_MEMORY_FILE_MAP_ERROR / 2042: connection lost
CR_SHARED_MEMORY_MAP_ERROR / 2043: connection lost
CR_SHARED_MEMORY_EVENT_ERROR / 2044: connection lost
CR_SHARED_MEMORY_CONNECT_ABANDONED_ERROR / 2045: connection lost
CR_SHARED_MEMORY_CONNECT_SET_ERROR / 2046: connection lost
CR_CONN_UNKNOW_PROTOCOL / 2047: connection lost
CR_SERVER_LOST_EXTENDED / 2055: connection lost
PROTOCOL_CONNECTION_LOST (mysql2): connection lost
ERR_MYSQL_CONNECTION_CLOSED (Bun SQL): connection lost
ECONNRESET (mysql2): connection lost
EPIPE (mysql2): connection lost
ECONNREFUSED (mysql2): connection lost
ENOTFOUND (mysql2): connection lost
EAI_AGAIN (mysql2): connection lost
EHOSTUNREACH (mysql2): connection lost
ENETUNREACH (mysql2): connection lost
errorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Connections SQL_CONNECTION_ERROR
errorType
temporarily unavailable
ER_HOST_IS_BLOCKED / 1129: temporarily unavailable
ER_SERVER_OFFLINE_MODE / 3032: temporarily unavailable
POOL_NONEONLINE (mysql2): temporarily unavailable
errorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Connections SQL_CONNECTION_ERROR
errorType
invalid connection configuration
ER_BAD_HOST_ERROR / 1042: invalid connection configuration
CR_UNKNOWN_HOST / 2005: invalid connection configuration
CR_SSL_CONNECTION_ERROR / 2026: invalid connection configuration
CR_SSL_FIPS_MODE_ERR / 2064: invalid connection configuration
CR_COMPRESSION_WRONGLY_CONFIGURED / 2066: invalid connection configuration
CR_DNS_SRV_LOOKUP_FAILED / 2070: invalid connection configuration
CR_TLS_SERVER_NOT_FOUND / 2075: invalid connection configuration
errorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Connections SQL_CONNECTION_ERROR
errorType
pool error
POOL_NOEXIST (mysql2): pool error errorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Resources SQL_RESOURCE_LIMIT_REACHED
resourceType
memory
EE_OUTOFMEMORY / 5: memory resource limit
EE_CAPACITY_EXCEEDED / 34: memory resource limit
ER_OUTOFMEMORY / 1037: memory resource limit
ER_OUT_OF_SORTMEMORY / 1038: memory resource limit
ER_OUT_OF_RESOURCES / 1041: memory resource limit
ER_STACK_OVERRUN / 1119: memory resource limit
ER_CANT_CREATE_THREAD / 1135: memory resource limit
ER_LOCK_TABLE_FULL / 1206: memory resource limit
ER_ZLIB_Z_MEM_ERROR / 1257: memory resource limit
CR_OUT_OF_MEMORY / 2008: memory resource limit
ER_ENGINE_OUT_OF_MEMORY / 3015: memory resource limit
ER_STD_BAD_ALLOC_ERROR / 3044: memory resource limit
resourceType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Resources SQL_RESOURCE_LIMIT_REACHED
resourceType
disk
EE_DISK_FULL / 20: disk resource limit
EE_DISK_FULL_WITH_RETRY_MSG / 35: disk resource limit
ER_RECORD_FILE_FULL / 1114: disk resource limit
ER_TRANS_CACHE_FULL / 1197: disk resource limit
ER_INNODB_UNDO_LOG_FULL / 3019: disk resource limit
resourceType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Resources SQL_RESOURCE_LIMIT_REACHED
resourceType
temp space
- -
Resources SQL_RESOURCE_LIMIT_REACHED
resourceType
connections
ER_CON_COUNT_ERROR / 1040: connections resource limit
ER_TOO_MANY_USER_CONNECTIONS / 1203: connections resource limit
resourceType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Resources SQL_RESOURCE_LIMIT_REACHED
resourceType
pool
- -
Resources SQL_RESOURCE_LIMIT_REACHED
resourceType
cpu
- -
Resources SQL_RESOURCE_LIMIT_REACHED
resourceType
file size
- -
Resources SQL_RESOURCE_LIMIT_REACHED EE_OUT_OF_FILERESOURCES / 23: resource limit reached
ER_TOO_BIG_SELECT / 1104: resource limit reached
ER_TOO_MANY_TABLES / 1116: resource limit reached
ER_TOO_MANY_FIELDS / 1117: resource limit reached
ER_TOO_BIG_ROWSIZE / 1118: resource limit reached
ER_USER_LIMIT_REACHED / 1226: resource limit reached
ER_ZLIB_Z_BUF_ERROR / 1258: resource limit reached
ER_TOO_LONG_BODY / 1437: resource limit reached
ER_MAX_PREPARED_STMT_COUNT_REACHED / 1461: resource limit reached
CR_NET_PACKET_TOO_LARGE / 2020: resource limit reached
resourceType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Access SQL_AUTHENTICATION_ERROR ER_ACCESS_DENIED_ERROR / 1045: authentication error
ER_ACCESS_DENIED_NO_PASSWORD_ERROR / 1698: authentication error
ER_ACCESS_DENIED_CHANGE_USER_ERROR / 1873: authentication error
CR_UNUSED_1 / 2049: authentication error
CR_AUTH_PLUGIN_CANNOT_LOAD / 2059: authentication error
CR_AUTH_PLUGIN_ERR / 2061: authentication error
CR_KERBEROS_USER_NOT_FOUND / 2067: authentication error
ER_AUTHENTICATION_POLICY_MISMATCH / 4058: authentication error
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Access SQL_AUTHORIZATION_ERROR ER_DBACCESS_DENIED_ERROR / 1044: authorization error
ER_HOST_NOT_PRIVILEGED / 1130: authorization error
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Access SQL_PERMISSION_DENIED ER_KILL_DENIED_ERROR / 1095: permission denied
ER_TABLEACCESS_DENIED_ERROR / 1142: permission denied
ER_COLUMNACCESS_DENIED_ERROR / 1143: permission denied
ER_ILLEGAL_GRANT_FOR_TABLE / 1144: permission denied
ER_NO_PERMISSION_TO_CREATE_USER / 1211: permission denied
ER_SPECIFIC_ACCESS_DENIED_ERROR / 1227: permission denied
ER_REVOKE_GRANTS / 1269: permission denied
ER_PROCACCESS_DENIED_ERROR / 1370: permission denied
ER_NONEXISTING_PROC_GRANT / 1403: permission denied
ER_CANT_CREATE_USER_WITH_GRANT / 1410: permission denied
CR_LOAD_DATA_LOCAL_INFILE_REJECTED / 2068: permission denied
ER_REPLACE_INACCESSIBLE_ROWS / 3059: permission denied
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Access SQL_READ_ONLY_VIOLATION ER_OPEN_AS_READONLY / 1036: read only violation
ER_TABLE_NOT_LOCKED_FOR_WRITE / 1099: read only violation
ER_READ_ONLY_TRANSACTION / 1207: read only violation
ER_CANT_UPDATE_WITH_READLOCK / 1223: read only violation
ER_CANT_EXECUTE_IN_READ_ONLY_TRANSACTION / 1792: read only violation
ER_CANT_CHANGE_SYS_VAR_IN_READ_ONLY_MODE / 4156: read only violation
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Configuration SQL_CONFIGURATION_ERROR
configurationErrorType
configuration file
- -
Configuration SQL_CONFIGURATION_ERROR
configurationErrorType
lock file
- -
Configuration SQL_CONFIGURATION_ERROR
configurationErrorType
runtime parameter
EE_UNKNOWN_CHARSET / 22: runtime parameter configuration error
EE_FAILED_TO_OPEN_DEFAULTS_FILE / 47: runtime parameter configuration error
EE_FAILED_TO_HANDLE_DEFAULTS_FILE / 48: runtime parameter configuration error
EE_WRONG_DIRECTIVE_IN_CONFIG_FILE / 49: runtime parameter configuration error
EE_INCORRECT_GRP_DEFINITION_IN_CONFIG_FILE / 51: runtime parameter configuration error
EE_OPTION_WITHOUT_GRP_IN_CONFIG_FILE / 52: runtime parameter configuration error
EE_CONFIG_FILE_PERMISSION_ERROR / 53: runtime parameter configuration error
EE_IGNORE_WORLD_WRITABLE_CONFIG_FILE / 54: runtime parameter configuration error
EE_SSL_ERROR_FROM_FILE / 59: runtime parameter configuration error
EE_SSL_ERROR / 60: runtime parameter configuration error
EE_UNKNOWN_PROTOCOL_OPTION / 63: runtime parameter configuration error
EE_FAILED_TO_LOCATE_SERVER_PUBLIC_KEY / 64: runtime parameter configuration error
EE_PUBLIC_KEY_NOT_IN_PEM_FORMAT / 65: runtime parameter configuration error
EE_UNKNOWN_VARIABLE / 67: runtime parameter configuration error
EE_UNKNOWN_OPTION / 68: runtime parameter configuration error
EE_UNKNOWN_SHORT_OPTION / 69: runtime parameter configuration error
EE_OPTION_WITHOUT_ARGUMENT / 70: runtime parameter configuration error
EE_OPTION_REQUIRES_ARGUMENT / 71: runtime parameter configuration error
EE_SHORT_OPTION_REQUIRES_ARGUMENT / 72: runtime parameter configuration error
EE_OPTION_IGNORED_DUE_TO_INVALID_VALUE / 73: runtime parameter configuration error
EE_OPTION_WITH_EMPTY_VALUE / 74: runtime parameter configuration error
EE_FAILED_TO_ASSIGN_MAX_VALUE_TO_OPTION / 75: runtime parameter configuration error
EE_INCORRECT_BOOLEAN_VALUE_FOR_OPTION / 76: runtime parameter configuration error
EE_FAILED_TO_SET_OPTION_VALUE / 77: runtime parameter configuration error
EE_INCORRECT_INT_VALUE_FOR_OPTION / 78: runtime parameter configuration error
EE_INCORRECT_UINT_VALUE_FOR_OPTION / 79: runtime parameter configuration error
EE_INVALID_DECIMAL_VALUE_FOR_OPTION / 84: runtime parameter configuration error
ER_UNKNOWN_SYSTEM_VARIABLE / 1193: runtime parameter configuration error
ER_INCORRECT_GLOBAL_LOCAL_VAR / 1238: runtime parameter configuration error
ER_UNKNOWN_COLLATION / 1273: runtime parameter configuration error
ER_UNKNOWN_KEY_CACHE / 1284: runtime parameter configuration error
ER_UNKNOWN_STORAGE_ENGINE / 1286: runtime parameter configuration error
CR_CANT_READ_CHARSET / 2019: runtime parameter configuration error
CR_WRONG_LICENSE / 2028: runtime parameter configuration error
CR_INVALID_CLIENT_CHARSET / 2074: runtime parameter configuration error
ER_STORAGE_ENGINE_NOT_LOADED / 3003: runtime parameter configuration error
ER_COL_COUNT_DOESNT_MATCH_PLEASE_UPDATE_V2 / 3009: runtime parameter configuration error
ER_CHANGE_REPLICATION_SOURCE_NO_OPTIONS_FOR_GTID_ONLY / 4065: runtime parameter configuration error
configurationErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
I/O SQL_IO_ERROR
ioErrorType
read
EE_READ / 2: read I/O error
EE_EOFERR / 9: read I/O error
EE_DIR / 12: read I/O error
EE_CANT_READLINK / 24: read I/O error
ER_CANT_READ_DIR / 1018: read I/O error
ER_ERROR_ON_READ / 1024: read I/O error
ioErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
I/O SQL_IO_ERROR
ioErrorType
write
EE_CANTCREATEFILE / 1: write I/O error
EE_WRITE / 3: write I/O error
EE_CANT_MKDIR / 21: write I/O error
EE_CANT_SYMLINK / 25: write I/O error
ER_CANT_CREATE_FILE / 1004: write I/O error
ER_CANT_CREATE_DB / 1006: write I/O error
ER_ERROR_ON_WRITE / 1026: write I/O error
ioErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
I/O SQL_IO_ERROR
ioErrorType
fsync
EE_SYNC / 27: fsync I/O error ioErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
I/O SQL_IO_ERROR
ioErrorType
truncate
- -
I/O SQL_IO_ERROR
ioErrorType
file stat
EE_STAT / 13: file stat I/O error
ER_CANT_GET_STAT / 1013: file stat I/O error
ioErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
I/O SQL_IO_ERROR
ioErrorType
lock
EE_CANTLOCK / 10: lock I/O error
ER_CANT_LOCK / 1015: lock I/O error
ioErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
I/O SQL_IO_ERROR
ioErrorType
unlock
EE_CANTUNLOCK / 11: unlock I/O error ioErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
I/O SQL_IO_ERROR
ioErrorType
delete
EE_DELETE / 6: delete I/O error ioErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
I/O SQL_IO_ERROR
ioErrorType
file not found
EE_FILENOTFOUND / 29: file not found I/O error
ER_FILE_NOT_FOUND / 1017: file not found I/O error
ioErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
I/O SQL_IO_ERROR
ioErrorType
access
EE_CHANGE_OWNERSHIP / 31: access I/O error
EE_CHANGE_PERMISSIONS / 32: access I/O error
ioErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
I/O SQL_IO_ERROR
ioErrorType
shared memory
- -
I/O SQL_IO_ERROR
ioErrorType
seek
EE_CANT_SEEK / 33: seek I/O error ioErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
I/O SQL_IO_ERROR
ioErrorType
mmap
- -
I/O SQL_IO_ERROR
ioErrorType
path
EE_LINK / 7: path I/O error
EE_CANT_CHSIZE / 14: path I/O error
EE_CANT_OPEN_STREAM / 15: path I/O error
EE_GETWD / 16: path I/O error
EE_SETWD / 17: path I/O error
EE_REALPATH / 26: path I/O error
ER_DB_DROP_RMDIR / 1010: path I/O error
ER_ERROR_ON_RENAME / 1025: path I/O error
ER_TEXTFILE_NOT_READABLE / 1085: path I/O error
ER_FILE_EXISTS_ERROR / 1086: path I/O error
CR_FILE_NAME_TOO_LONG / 2063: path I/O error
CR_LOAD_DATA_LOCAL_INFILE_REALPATH_FAIL / 2069: path I/O error
ioErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
I/O SQL_IO_ERROR
ioErrorType
atomic write
- -
I/O SQL_IO_ERROR
ioErrorType
close
EE_BADCLOSE / 4: close I/O error ioErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
I/O SQL_IO_ERROR
ioErrorType
reserved extension
- -
I/O SQL_IO_ERROR
ioErrorType
unknown
ER_INVALID_CAST_POLYGON_RING_DIRECTION / 4033: unknown I/O error
ER_BULK_LOADER_FILE_CONTAINS_LESS_LINES_THAN_IGNORE_CLAUSE / 4142: unknown I/O error
ER_* / MY-* file, directory, read, write, or open fallback: unknown I/O error
ioErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
External SQL_EXTERNAL_DATA_SOURCE_ERROR CR_PROBE_REPLICA_STATUS / 2022: external data source error
CR_PROBE_REPLICA_HOSTS / 2023: external data source error
ER_DONT_SUPPORT_REPLICA_PRESERVE_COMMIT_ORDER / 3031: external data source error
ER_STARTING_REPLICA_MONITOR_IO_THREAD / 4012: external data source error
ER_CANT_USE_ANONYMOUS_TO_GTID_WITH_GTID_MODE_NOT_ON / 4013: external data source error
ER_CANT_COMBINE_ANONYMOUS_TO_GTID_AND_AUTOPOSITION / 4014: external data source error
ER_ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_REQUIRES_GTID_MODE_ON / 4015: external data source error
ER_SQL_REPLICA_SKIP_COUNTER_USED_WITH_GTID_MODE_ON / 4016: external data source error
ER_USING_ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_AS_LOCAL_OR_UUID / 4017: external data source error
ER_CANT_SET_SQL_AFTER_OR_BEFORE_GTIDS_WITH_ANONYMOUS_TO_GTID / 4019: external data source error
ER_ANONYMOUS_TO_GTID_UUID_SAME_AS_GROUP_NAME / 4020: external data source error
ER_GRP_RPL_RECOVERY_CHANNEL_STILL_RUNNING / 4022: external data source error
ER_CHANGE_RPL_SRC_WRONG_COMPRESSION_ALGORITHM_SIZE / 4037: external data source error
ER_ANONYMOUS_TO_GTID_UUID_SAME_AS_VIEW_CHANGE_UUID / 4040: external data source error
ER_GRP_RPL_VIEW_CHANGE_UUID_FAIL_GET_VARIABLE / 4041: external data source error
ER_GRP_RPL_FAILOVER_CHANNEL_STATUS_PROPAGATION / 4050: external data source error
ER_CHANGE_REP_SOURCE_CANT_DISABLE_AUTO_POS_WITHOUT_POSITIONS / 4069: external data source error
ER_REGEXP_MISSING_RESOURCE / 4076: external data source error
ER_CANT_EXECUTE_COMMAND_WITH_ASSIGNED_GTID_NEXT / 4090: external data source error
ER_* / MY-* replica, source, slave, master, GTID, RPL, binlog, or group replication fallback: external data source error
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Features SQL_FEATURE_NOT_SUPPORTED ER_UNSUPPORTED_EXTENSION / 1112: feature not supported
ER_UNKNOWN_CHARACTER_SET / 1115: feature not supported
ER_NOT_ALLOWED_COMMAND / 1148: feature not supported
ER_TABLE_CANT_HANDLE_BLOB / 1163: feature not supported
ER_TABLE_CANT_HANDLE_AUTO_INCREMENT / 1164: feature not supported
ER_CHECK_NOT_IMPLEMENTED / 1178: feature not supported
ER_NOT_SUPPORTED_YET / 1235: feature not supported
ER_SP_BADSELECT / 1312: feature not supported
ER_SP_BADSTATEMENT / 1314: feature not supported
ER_SP_SUBSELECT_NYI / 1335: feature not supported
ER_STMT_NOT_ALLOWED_IN_SF_OR_TRG / 1336: feature not supported
ER_SP_NO_RETSET / 1415: feature not supported
ER_SP_NO_AGGREGATE / 1460: feature not supported
ER_ALTER_OPERATION_NOT_SUPPORTED / 1845: feature not supported
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON / 1846: feature not supported
CR_NOT_IMPLEMENTED / 2054: feature not supported
CR_DEPRECATED_COMPRESSION_NOT_SUPPORTED / 2065: feature not supported
ER_WARN_LEGACY_SYNTAX_CONVERTED / 3005: feature not supported
ER_EXPLAIN_NOT_SUPPORTED / 3012: feature not supported
ER_ALTER_OPERATION_NOT_SUPPORTED_REASON_GIS / 3060: feature not supported
ER_IDENTIFIED_BY_UNSUPPORTED / 4053: feature not supported
ER_INNODB_INSTANT_ADD_DROP_NOT_SUPPORTED_MAX_SIZE / 4157: feature not supported
ER_INNODB_INSTANT_ADD_NOT_SUPPORTED_MAX_FIELDS / 4158: feature not supported
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Corruption SQL_DATABASE_CORRUPTED
corruptionType
database file
ER_NOT_FORM_FILE / 1033: database file corruption
ER_CRASHED_ON_USAGE / 1194: database file corruption
ER_CRASHED_ON_REPAIR / 1195: database file corruption
ER_CORRUPT_HELP_DB / 1244: database file corruption
corruptionType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Corruption SQL_DATABASE_CORRUPTED
corruptionType
index
ER_NOT_KEYFILE / 1034: index corruption
ER_OLD_KEYFILE / 1035: index corruption
ER_INDEX_CORRUPT / 1712: index corruption
corruptionType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Corruption SQL_DATABASE_CORRUPTED
corruptionType
sequence
- -
Corruption SQL_DATABASE_CORRUPTED
corruptionType
virtual table
- -
Corruption SQL_DATABASE_CORRUPTED
corruptionType
filesystem
- -
Corruption SQL_DATABASE_CORRUPTED
corruptionType
checksum
ER_TOO_BIG_FOR_UNCOMPRESS / 1256: checksum corruption
ER_ZLIB_Z_DATA_ERROR / 1259: checksum corruption
ER_FILE_CORRUPT / 3000: checksum corruption
corruptionType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Internal SQL_INTERNAL_ERROR
errorType
engine internal
ER_WARN_HYPERGRAPH_EXPERIMENTAL / 4000: engine internal
ER_DA_ERROR_LOG_MULTIPLE_FILTERS / 4003: engine internal
ER_REGEX_NUMBER_TOO_BIG / 4007: engine internal
ER_SPVAR_NONINTEGER_TYPE / 4008: engine internal
WARN_UNSUPPORTED_ACL_TABLES_READ / 4009: engine internal
ER_INNODB_INCOMPATIBLE_WITH_TABLESPACE / 4024: engine internal
ER_CANNOT_USE_AUTOEXTEND_SIZE_CLAUSE / 4026: engine internal
ER_INNODB_COMPRESSION_FAILURE / 4029: engine internal
ER_WARN_ASYNC_CONN_FAILOVER_NETWORK_NAMESPACE / 4030: engine internal
ER_RELOAD_KEYRING_FAILURE / 4035: engine internal
ER_WARN_ADUIT_LOG_MAX_SIZE_AND_PRUNE_SECONDS / 4042: engine internal
ER_WARN_ADUIT_LOG_MAX_SIZE_CLOSE_TO_ROTATE_ON_SIZE / 4043: engine internal
ER_KERBEROS_CREATE_USER / 4044: engine internal
ER_INSTALL_PLUGIN_CONFLICT_CLIENT / 4045: engine internal
ER_DA_ERROR_LOG_COMPONENT_FLUSH_FAILED / 4046: engine internal
ER_WARN_SQL_AFTER_MTS_GAPS_GAP_NOT_CALCULATED / 4047: engine internal
ER_OPERATION_NOT_ALLOWED_ON_GR_SECONDARY / 4049: engine internal
ER_MFA_METHOD_NOT_EXISTS / 4057: engine internal
ER_PLUGIN_REGISTRATION_DONE / 4059: engine internal
ER_USER_REGISTRATION_FAILED / 4061: engine internal
ER_MFA_METHODS_IDENTICAL / 4063: engine internal
ER_VALUE_OUT_OF_RANGE / 4074: engine internal
ER_FULLTEXT_WITH_ROLLUP / 4075: engine internal
ER_WARN_REGEXP_USING_DEFAULT / 4077: engine internal
ER_CONCURRENT_PROCEDURE_USAGE / 4080: engine internal
ER_DA_GLOBAL_CONN_LIMIT / 4081: engine internal
ER_DA_CONN_LIMIT / 4082: engine internal
ER_INNODB_MAX_ROW_VERSION / 4092: engine internal
ER_WARN_DEPRECATED_DATETIME_DELIMITER / 4095: engine internal
ER_WARN_DEPRECATED_SUPERFLUOUS_DELIMITER / 4096: engine internal
ER_CANNOT_PERSIST_SENSITIVE_VARIABLES / 4097: engine internal
ER_IF_NOT_EXISTS_UNSUPPORTED_TRG_EXISTS_ON_DIFFERENT_TABLE / 4100: engine internal
ER_GIPK_COLUMN_EXISTS / 4108: engine internal
ER_GIPK_COLUMN_ALTER_NOT_ALLOWED / 4110: engine internal
ER_DROP_PK_COLUMN_TO_DROP_GIPK / 4111: engine internal
ER_WARN_DEPRECATED_IDENT / 4119: engine internal
ER_TP_QUERY_THRS_PER_GRP_EXCEEDS_TXN_THR_LIMIT / 4121: engine internal
ER_SHAPE_PRIDICTION_UDF / 4123: engine internal
ER_WARN_DEPRECATED_CLIENT_NO_SCHEMA_OPTION / 4128: engine internal
ER_TABLE_IN_SHARED_TABLESPACE / 4131: engine internal
ER_INDEX_OTHER_THAN_PK / 4132: engine internal
ER_LOAD_BULK_DATA_UNSORTED / 4133: engine internal
ER_BULK_READER_SERVER_ERROR / 4137: engine internal
ER_BULK_READER_COMMUNICATION_ERROR / 4138: engine internal
ER_BULK_LOAD_DATA_FAILED / 4139: engine internal
ER_BULK_LOADER_COLUMN_TOO_BIG_FOR_LEFTOVER_BUFFER / 4140: engine internal
ER_BULK_LOADER_COMPONENT_ERROR / 4141: engine internal
ER_LOAD_BULK_DATA_FAILED / 4152: engine internal
ER_LOAD_BULK_DATA_WARN_NULL_TO_NOTNULL / 4154: engine internal
ER_INSTALL_COMPONENT_SET_NULL_VALUE / 4160: engine internal
ER_VALIDATE_PASSWORD_INSUFFICIENT_CHANGED_CHARACTERS / 4165: engine internal
ER_WARN_DEPRECATED_WITH_NOTE / 4166: engine internal
EE_* / error numbers 1-999 fallback: engine internal
ER_* / MY-* warning, note, or info fallback: engine internal
errorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Internal SQL_INTERNAL_ERROR
errorType
api misuse
CR_COMMANDS_OUT_OF_SYNC / 2014: api misuse
CR_NULL_POINTER / 2029: api misuse
CR_NO_PREPARE_STMT / 2030: api misuse
CR_INVALID_CONN_HANDLE / 2048: api misuse
CR_FETCH_CANCELED / 2050: api misuse
CR_NO_DATA / 2051: api misuse
CR_NO_STMT_METADATA / 2052: api misuse
CR_NO_RESULT_SET / 2053: api misuse
CR_STMT_CLOSED / 2056: api misuse
CR_NEW_STMT_METADATA / 2057: api misuse
CR_ALREADY_CONNECTED / 2058: api misuse
CR_INSECURE_API_ERR / 2062: api misuse
CR_MANDATORY_TRACKER_NOT_FOUND / 2071: api misuse
CR_CANT_GET_SESSION_DATA / 2073: api misuse
mysql2 and Bun SQL API misuse messages: api misuse
CR_* / error numbers 2001-2999 fallback: api misuse
errorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Fallback SQL_UNKNOWN CR_UNKNOWN_ERROR / 2000: unknown
ERR_MYSQL_UNKNOWN_ERROR (Bun SQL): unknown SQL error
unmapped explicit driver code or numeric error with no active-database symbol: unknown
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage