Skip to content

MariaDB Error Mapping

This page lists how native MariaDB 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 MariaDB.

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 / 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_ON_DUPLICATE_DISABLED / 4058: 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 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
constraintType
constraintName when inferred
tableName when inferred
columnName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Constraints SQL_CONSTRAINT_VIOLATED
constraintType
check
ER_CONSTRAINT_FAILED / 4025: 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_MASTER_PASSWORD_LENGTH / 3056: too long
ER_TOO_LONG_DATABASE_COMMENT / 4160: too long
WARN_SORTING_ON_TRUNCATED_LENGTH / 4203: 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_ARGUMENT_OUT_OF_RANGE / 4103: out of range
ER_PART_WRONG_VALUE / 4127: out of range
ER_PARSING_PRECISION / 45050 (mariadb): 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
ER_GIS_DIFFERENT_SRIDS / 3033: invalid value
ER_GIS_UNSUPPORTED_ARGUMENT / 3034: invalid value
ER_GIS_UNKNOWN_ERROR / 3035: invalid value
ER_GIS_UNKNOWN_EXCEPTION / 3036: invalid value
ER_GIS_INVALID_DATA / 3037: invalid value
ER_BOOST_GEOMETRY_EMPTY_INPUT_EXCEPTION / 3038: invalid value
ER_BOOST_GEOMETRY_CENTROID_EXCEPTION / 3039: invalid value
ER_BOOST_GEOMETRY_OVERLAY_INVALID_INPUT_EXCEPTION / 3040: invalid value
ER_BOOST_GEOMETRY_TURN_INFO_EXCEPTION / 3041: invalid value
ER_BOOST_GEOMETRY_SELF_INTERSECTION_POINT_EXCEPTION / 3042: invalid value
ER_BOOST_GEOMETRY_UNKNOWN_EXCEPTION / 3043: invalid value
ER_STD_DOMAIN_ERROR / 3045: invalid value
ER_STD_INVALID_ARGUMENT / 3047: invalid value
ER_KEYS_OUT_OF_ORDER / 4054: invalid value
ER_OVERLAPPING_KEYS / 4055: invalid value
ER_RDB_TTL_DURATION_FORMAT / 4066: invalid value
ER_RDB_TTL_COL_FORMAT / 4070: invalid value
ER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION / 4078: invalid value
ER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION / 4079: invalid value
ER_WRONG_TYPE_FOR_PERCENTILE_FUNC / 4101: invalid value
ER_ARGUMENT_NOT_CONSTANT / 4102: invalid value
ER_WRONG_TYPE_OF_ARGUMENT / 4104: invalid value
ER_PERIOD_TYPES_MISMATCH / 4153: invalid value
ER_WARN_HISTORY_ROW_START_TIME / 4163: invalid value
ER_PART_STARTS_BEYOND_INTERVAL / 4164: 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
ER_DYN_COL_WRONG_FORMAT / 1919: invalid format
ER_BAD_BASE64_DATA / 1958: invalid format
ER_GIS_DATA_WRONG_ENDIANESS / 3055: invalid format
ER_UNKNOWN_COMPRESSION_METHOD / 4098: invalid format
ER_VECTOR_BINARY_FORMAT_INVALID / 4204: invalid format
ER_VECTOR_FORMAT_INVALID / 4205: invalid format
errorType
tableName when inferred
columnName when inferred
typeName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Values SQL_INVALID_VALUE
errorType
invalid encoding
ER_DYN_COL_WRONG_CHARSET / 1922: invalid encoding
ER_CANNOT_CONVERT_CHARACTER / 1977: invalid encoding
errorType
tableName when inferred
columnName when inferred
typeName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Values SQL_INVALID_VALUE
errorType
invalid json
ER_JSON_BAD_CHR / 4035: invalid json
ER_JSON_NOT_JSON_CHR / 4036: invalid json
ER_JSON_EOS / 4037: invalid json
ER_JSON_SYNTAX / 4038: invalid json
ER_JSON_ESCAPING / 4039: invalid json
ER_JSON_PATH_EOS / 4041: invalid json
ER_JSON_PATH_SYNTAX / 4042: invalid json
ER_JSON_PATH_NO_WILDCARD / 4044: invalid json
ER_JSON_PATH_ARRAY / 4045: invalid json
ER_JSON_ONE_OR_ALL / 4046: invalid json
ER_GEOJSON_INCORRECT / 4048: invalid json
ER_GEOJSON_TOO_FEW_POINTS / 4049: invalid json
ER_GEOJSON_NOT_CLOSED / 4050: invalid json
ER_JSON_PATH_EMPTY / 4051: invalid json
ER_GEOJSON_EMPTY_COORDINATES / 4076: invalid json
ER_JSON_TABLE_ERROR_ON_FIELD / 4176: invalid json
ER_JSON_TABLE_SCALAR_EXPECTED / 4178: invalid json
ER_JSON_TABLE_MULTIPLE_MATCHES / 4179: invalid json
ER_JSON_HISTOGRAM_PARSE_FAILED / 4186: invalid json
ER_JSON_INVALID_VALUE_FOR_KEYWORD / 4193: 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
ER_SEQUENCE_RUN_OUT / 4084: sequence limit errorType
tableName when inferred
columnName when inferred
typeName when inferred
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Parameters SQL_INVALID_PARAMETER
parameterErrorType
missing
ER_MISSING / 4125: missing parameter
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
ER_MISSING_PARAMETER / 45016 (mariadb): missing parameter
ER_PARAMETER_UNDEFINED / 45017 (mariadb): missing parameter
ER_PLACEHOLDER_UNDEFINED / 45018 (mariadb): missing parameter
ER_BATCH_WITH_NO_VALUES / 45031 (mariadb): missing parameter
ER_UNDEFINED_SQL / 45049 (mariadb): missing parameter
ER_MISSING_SQL_PARAMETER / 45052 (mariadb): missing parameter
ER_MISSING_DATABASE_PARAMETER / 45055 (mariadb): missing 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
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_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_SLAVE_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
ER_BAD_OPTION_VALUE / 1912: invalid value parameter
ER_WRONG_PARAMCOUNT_TO_CURSOR / 4080: invalid value parameter
ER_SF_OUT_INOUT_ARG_NOT_ALLOWED / 4187: invalid value parameter
ER_BAD_PARAMETER_VALUE / 45043 (mariadb): 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_UNSUPPORTED_PARAM_TYPE / 2036: invalid value parameter when no more specific parameter subtype is inferred from the message
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
- -
Parameters SQL_INVALID_PARAMETER
parameterErrorType
not bindable
- -
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
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
ER_UNKNOWN_SEQUENCES / 4091: sequence 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
collation
- -
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
ER_VEC_DISTANCE_TYPE / 4206: index not found
ER_UNRESOLVED_INDEX_HINT_NAME / 4222: 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
ER_REFERENCED_TRG_DOES_NOT_EXIST_MYSQL / 3011: trigger not found
ER_REFERENCED_TRG_DOES_NOT_EXIST / 4031: trigger 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
cursor
- -
Object not found SQL_OBJECT_NOT_FOUND
objectType
prepared statement
- -
Object not found SQL_OBJECT_NOT_FOUND
objectType
role
ER_ROLE_DROP_EXISTS / 1976: role 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 ER_PERIOD_NOT_FOUND / 4156: 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_CONNECTION_ALREADY_EXISTS / 1934: object already exists
ER_PLUGIN_INSTALLED / 1968: object already exists
ER_USER_CREATE_EXISTS / 1973: object already exists
ER_ROLE_CREATE_EXISTS / 1975: 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
ER_QUERY_CACHE_IS_DISABLED / 1924: invalid state
ER_SEQUENCE_ACCESS_ERROR / 4087: invalid state
ER_VERS_ALREADY_VERSIONED / 4135: invalid state
ER_BACKUP_LOCK_IS_ACTIVE / 4145: invalid state
ER_BACKUP_NOT_RUNNING / 4146: invalid state
ER_BACKUP_WRONG_STAGE / 4147: invalid state
ER_BACKUP_STAGE_FAILED / 4148: invalid state
ER_BACKUP_UNKNOWN_STAGE / 4149: invalid state
ER_PREPARE_CLOSED / 45051 (mariadb): 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
ER_IT_IS_A_VIEW / 1965: wrong object type
ER_NOT_SEQUENCE / 4089: wrong object type
ER_NOT_SEQUENCE2 / 4090: wrong object type
ER_VERS_NOT_VERSIONED / 4124: wrong object type
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
object in use
- -
Object state SQL_OBJECT_STATE_ERROR
objectStateErrorType
dependent objects still exist
- -
Statement SQL_SYNTAX_ERROR ER_PARSE_ERROR / 1064: syntax error
ER_SYNTAX_ERROR / 1149: 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
ER_DUP_QUERY_NAME / 4004: duplicate identifier
ER_DUP_WINDOW_NAME / 4010: duplicate identifier
ER_VERS_DUPLICATE_ROW_START_END / 4134: duplicate identifier
ER_DUPLICATE_FIELD / 45040 (mariadb): 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_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_GENERATED_COLUMN_FUNCTION_IS_NOT_ALLOWED / 1901: invalid definition
ER_PRIMARY_KEY_BASED_ON_GENERATED_COLUMN / 1903: invalid definition
ER_KEY_BASED_ON_GENERATED_VIRTUAL_COLUMN / 1904: invalid definition
ER_WRONG_FK_OPTION_FOR_GENERATED_COLUMN / 1905: invalid definition
ER_TABLE_DEFINITION_TOO_BIG / 1967: 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_RECURSIVE_WITHOUT_ANCHORS / 4005: invalid definition
ER_NOT_STANDARD_COMPLIANT_RECURSIVE / 4008: invalid definition
ER_WRONG_WINDOW_SPEC_NAME / 4009: invalid definition
ER_PARTITION_LIST_IN_REFERENCING_WINDOW_SPEC / 4011: invalid definition
ER_ORDER_LIST_IN_REFERENCING_WINDOW_SPEC / 4012: invalid definition
ER_WINDOW_FRAME_IN_REFERENCED_WINDOW_SPEC / 4013: invalid definition
ER_BAD_COMBINATION_OF_WINDOW_FRAME_BOUND_SPECS / 4014: invalid definition
ER_WRONG_PLACEMENT_OF_WINDOW_FUNCTION / 4015: invalid definition
ER_WINDOW_FUNCTION_IN_WINDOW_SPEC / 4016: invalid definition
ER_NOT_ALLOWED_WINDOW_FRAME / 4017: invalid definition
ER_NO_ORDER_LIST_IN_WINDOW_SPEC / 4018: invalid definition
ER_RANGE_FRAME_NEEDS_SIMPLE_ORDERBY / 4019: invalid definition
ER_WRONG_TYPE_FOR_ROWS_FRAME / 4020: invalid definition
ER_WRONG_TYPE_FOR_RANGE_FRAME / 4021: invalid definition
ER_WINDOW_FUNCTION_DONT_HAVE_FRAME / 4023: invalid definition
ER_INVALID_NTILE_ARGUMENT / 4024: invalid definition
ER_PARTITION_DEFAULT_ERROR / 4030: invalid definition
ER_INVISIBLE_NOT_NULL_WITHOUT_DEFAULT / 4108: invalid definition
ER_VERS_FIELD_WRONG_TYPE / 4110: invalid definition
ER_PARTITION_WRONG_TYPE / 4113: invalid definition
ER_VERS_DROP_PARTITION_INTERVAL / 4116: invalid definition
ER_VERS_ALTER_NOT_ALLOWED / 4119: invalid definition
ER_VERS_RANGE_PROHIBITED / 4121: invalid definition
ER_VERS_TABLE_MUST_HAVE_COLUMNS / 4123: invalid definition
ER_VERS_PERIOD_COLUMNS / 4126: invalid definition
ER_VERS_WRONG_PARTS / 4128: invalid definition
ER_VERS_ALTER_SYSTEM_FIELD / 4130: invalid definition
ER_DROP_VERSIONING_SYSTEM_TIME_PARTITION / 4131: invalid definition
ER_PERIOD_TEMPORARY_NOT_ALLOWED / 4152: invalid definition
ER_MORE_THAN_ONE_PERIOD / 4154: invalid definition
ER_PERIOD_FIELD_WRONG_ATTRIBUTES / 4155: invalid definition
ER_PERIOD_COLUMNS_UPDATED / 4157: invalid definition
ER_NO_AUTOINCREMENT_WITH_UNIQUE / 4169: invalid definition
ER_KEY_CONTAINS_PERIOD_FIELDS / 4170: invalid definition
ER_KEY_CANT_HAVE_WITHOUT_OVERLAPS / 4171: invalid definition
ER_PK_INDEX_CANT_BE_IGNORED / 4174: invalid definition
ER_WITH_TIES_NEEDS_ORDER / 4180: invalid definition
ER_CM_OPTION_MISSING_REQUIREMENT / 4191: invalid definition
ER_SEQUENCE_TABLE_CANNOT_HAVE_ANY_KEYS / 4198: invalid definition
ER_SEQUENCE_TABLE_CANNOT_HAVE_ANY_CONSTRAINTS / 4199: invalid definition
ER_SEQUENCE_TABLE_ORDER_BY / 4200: 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_ILLEGAL_SUBQUERY_OPTIMIZER_SWITCHES / 1923: invalid statement context
ER_STORED_FUNCTION_PREVENTS_SWITCH_SKIP_REPLICATION / 1930: invalid statement context
ER_TARGET_NOT_EXPLAINABLE / 1933: invalid statement context
ER_STORED_FUNCTION_PREVENTS_SWITCH_GTID_DOMAIN_ID_SEQ_NO / 1954: invalid statement context
ER_PASSWORD_EXPIRE_ANONYMOUS_USER / 3016: invalid statement context
ER_BAD_COMMAND_IN_MULTI / 4001: invalid statement context
ER_NOT_AGGREGATE_FUNCTION / 4105: invalid statement context
ER_INVALID_AGGREGATE_FUNCTION / 4106: invalid statement context
ER_UPDATED_COLUMN_ONLY_ONCE / 4140: invalid statement context
ER_ALTER_OPERATION_TABLE_OPTIONS_NEED_REBUILD / 4144: invalid statement context
ER_NOT_ALLOWED_IN_THIS_CONTEXT / 4172: invalid statement context
ER_JSON_TABLE_ALIAS_REQUIRED / 4177: invalid statement context
ER_PSEUDO_THREAD_ID_OVERWRITE / 4196: invalid statement context
ER_WARN_MALFORMED_HINT / 4224: 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_UNKNOWN_STRUCTURED_VARIABLE / 4081: invalid identifier
ER_END_IDENTIFIER_DOES_NOT_MATCH / 4083: invalid identifier
ER_NULL_ESCAPEID / 45006 (mariadb): invalid identifier
ER_NULL_CHAR_ESCAPEID / 45005 (mariadb): invalid identifier
ER_PRIVATE_FIELDS_USE / 45058 (mariadb): 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_NO_EIS_FOR_FIELD / 1980: invalid reference
ER_REF_TO_RECURSIVE_WITH_TABLE_IN_DERIVED / 4007: invalid reference
ER_EXPRESSION_REFERS_TO_UNINIT_FIELD / 4029: invalid reference
ER_FIELD_REFERENCE_IN_TVC / 4100: invalid reference
ER_UNRESOLVED_TABLE_HINT_NAME / 4221: 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_WARN_AGGFUNC_DEPENDENCE / 1981: invalid grouping
ER_AGGREGATE_ORDER_FOR_UNION / 3028: invalid grouping
ER_AGGREGATE_ORDER_NON_AGG_QUERY / 3029: invalid grouping
ER_SUM_FUNC_WITH_WINDOW_FUNC_AS_ARG / 4074: 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 / 1120: invalid SQL statement
ER_CANT_CHANGE_TX_ISOLATION / 1568: invalid SQL statement
ER_COMMULTI_BADCONTEXT / 4000: invalid SQL statement
ER_INVALID_DEFAULT_PARAM / 4032: invalid SQL statement
ER_MYROCKS_CANT_NOPAD_COLLATION / 4077: 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_ZER / 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
ER_WITH_COL_WRONG_LIST / 4002: cardinality violation
ER_WRONG_NUMBER_OF_VALUES_IN_TVC / 4099: cardinality violation
ER_SEQUENCE_TABLE_HAS_WRONG_NUMBER_OF_COLUMNS / 4197: cardinality violation
ER_INCORRECT_COLUMN_NAME_COUNT / 4202: cardinality violation
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Execution SQL_ROUTINE_ERROR ER_STD_LOGIC_ERROR / 3052: routine error
ER_STD_RUNTIME_ERROR / 3053: routine error
ER_ERROR_EVALUATING_EXPRESSION / 4027: routine error
ER_CALCULATING_DEFAULT_VALUE / 4028: routine error
WARN_SFORMAT_ERROR / 4183: routine error
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Transactions TRANSACTION_ERROR
transactionErrorType
invalid state
- -
Transactions TRANSACTION_ERROR
transactionErrorType
aborted
- -
Transactions TRANSACTION_ERROR
transactionErrorType
active transaction
ER_CANT_DO_THIS_DURING_AN_TRANSACTION / 1179: active transaction
ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_SKIP_REPLICATION / 1929: active transaction
ER_INSIDE_TRANSACTION_PREVENTS_SWITCH_GTID_DOMAIN_ID_SEQ_NO / 1953: active transaction
ER_UPDATES_WITH_CONSISTENT_SNAPSHOT / 4059: 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_PRIOR_COMMIT_FAILED / 1964: transaction rolled back
ER_ROLLBACK_ONLY / 4060: transaction rolled back
transactionErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Transactions TRANSACTION_ERROR
transactionErrorType
outcome unknown
ER_DATA_WAS_COMMITED_UNDER_ROLLBACK / 4173: outcome unknown transactionErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Transactions TRANSACTION_ERROR
transactionErrorType
invalid savepoint
- -
Transactions TRANSACTION_ERROR
transactionErrorType
unsupported operation
- -
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
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
ER_QUERY_RESULT_INCOMPLETE / 1931: statement timeout
ER_STATEMENT_TIMEOUT / 1969: statement timeout
ER_QUERY_TIMEOUT / 3024: statement timeout
ER_SLAVE_STATEMENT_TIMEOUT / 4192: statement timeout
timeoutType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Timeouts SQL_TIMEOUT
timeoutType
transaction
- -
Timeouts SQL_TIMEOUT
timeoutType
idle transaction
- -
Timeouts SQL_TIMEOUT
timeoutType
cancelled
ER_QUERY_INTERRUPTED / 1317: 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_MASTER_NET_READ / 1189: connection lost
ER_MASTER_NET_WRITE / 1190: connection lost
ER_CONNECT_TO_MASTER / 1218: connection lost
ER_CONNECTION_KILLED / 1927: 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
ER_POOL_NO_CONNECTION / 45061 (mariadb): 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 errorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Connections SQL_CONNECTION_ERROR
errorType
pool error
- -
Resources SQL_RESOURCE_LIMIT_REACHED
resourceType
memory
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
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
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
ER_INDEX_FILE_FULL / 4139: 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
ER_GET_CONNECTION_TIMEOUT / 45028 (mariadb): pool resource limit resourceType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Resources SQL_RESOURCE_LIMIT_REACHED
resourceType
cpu
- -
Resources SQL_RESOURCE_LIMIT_REACHED
resourceType
file size
- -
Resources SQL_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
ER_DYN_COL_IMPLEMENTATION_LIMIT / 1920: resource limit reached
ER_TOO_MANY_DEFINITIONS_IN_WITH_CLAUSE / 4003: resource limit reached
ER_EXPRESSION_IS_TOO_BIG / 4026: resource limit reached
ER_NET_OK_PACKET_TOO_LARGE / 4075: resource limit reached
ER_MAX_ALLOWED_PACKET / 45046 (mariadb): 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
ER_USER_IS_BLOCKED / 4150: 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
ER_CANNOT_GRANT_ROLE / 1961: permission denied
ER_CANNOT_REVOKE_ROLE / 1962: permission denied
ER_KILL_QUERY_DENIED_ERROR / 1979: permission denied
ER_REPLACE_INACCESSIBLE_ROWS / 3059: permission denied
ER_ACCOUNT_HAS_BEEN_LOCKED / 4151: permission denied
ER_LOAD_INFILE_CAPABILITY_DISABLED / 4166: permission denied
ER_LOCAL_INFILE_DISABLED / 45021 (mariadb): 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
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
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
ER_UNKNOWN_OPTION / 1911: 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_SQL_MODE_NO_EFFECT / 3027: runtime parameter configuration error
ER_CF_DIFFERENT / 4065: runtime parameter configuration error
ER_NO_SECURE_TRANSPORTS_CONFIGURED / 4167: runtime parameter configuration error
ER_STORAGE_ENGINE_DISABLED / 4182: runtime parameter configuration error
ER_PROVIDER_NOT_LOADED / 4185: runtime parameter configuration error
ER_VARIABLE_IGNORED / 4201: runtime parameter configuration error
configurationErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
I/O SQL_IO_ERROR
ioErrorType
read
ER_CANT_READ_DIR / 1018: read I/O error
ER_ERROR_ON_READ / 1024: read I/O error
ER_LOCAL_INFILE_NOT_READABLE / 45022 (mariadb): read I/O error
ER_SQL_FILE_ERROR / 45054 (mariadb): read I/O error
ioErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
I/O SQL_IO_ERROR
ioErrorType
write
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
- -
I/O SQL_IO_ERROR
ioErrorType
truncate
- -
I/O SQL_IO_ERROR
ioErrorType
file stat
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
ER_CANT_LOCK / 1015: lock I/O error ioErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
I/O SQL_IO_ERROR
ioErrorType
unlock
- -
I/O SQL_IO_ERROR
ioErrorType
delete
- -
I/O SQL_IO_ERROR
ioErrorType
file not found
ER_FILE_NOT_FOUND / 1017: file not found I/O error
ER_MISSING_SQL_FILE / 45053 (mariadb): file not found I/O error
ioErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
I/O SQL_IO_ERROR
ioErrorType
access
ER_LOCAL_INFILE_WRONG_FILENAME / 45034 (mariadb): 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
- -
I/O SQL_IO_ERROR
ioErrorType
mmap
- -
I/O SQL_IO_ERROR
ioErrorType
path
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
ioErrorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
I/O SQL_IO_ERROR
ioErrorType
atomic write
- -
I/O SQL_IO_ERROR
ioErrorType
close
- -
I/O SQL_IO_ERROR
ioErrorType
reserved extension
- -
I/O SQL_IO_ERROR
ioErrorType
unknown
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 ER_MASTER_LOG_PREFIX / 1935: external data source error
ER_CANT_START_STOP_SLAVE / 1936: external data source error
ER_SLAVE_STARTED / 1937: external data source error
ER_SLAVE_STOPPED / 1938: external data source error
ER_SQL_DISCOVER_ERROR / 1939: external data source error
ER_FAILED_GTID_STATE_INIT / 1940: external data source error
ER_INCORRECT_GTID_STATE / 1941: external data source error
ER_CANNOT_UPDATE_GTID_STATE / 1942: external data source error
ER_DUPLICATE_GTID_DOMAIN / 1943: external data source error
ER_GTID_POSITION_NOT_FOUND_IN_BINLOG / 1945: external data source error
ER_CANNOT_LOAD_SLAVE_GTID_STATE / 1946: external data source error
ER_MASTER_GTID_POS_CONFLICTS_WITH_BINLOG / 1947: external data source error
ER_MASTER_GTID_POS_MISSING_DOMAIN / 1948: external data source error
ER_UNTIL_REQUIRES_USING_GTID / 1949: external data source error
ER_GTID_STRICT_OUT_OF_ORDER / 1950: external data source error
ER_GTID_START_FROM_BINLOG_HOLE / 1951: external data source error
ER_SLAVE_UNEXPECTED_MASTER_SWITCH / 1952: external data source error
ER_GTID_POSITION_NOT_FOUND_IN_BINLOG2 / 1955: external data source error
ER_BINLOG_MUST_BE_EMPTY / 1956: external data source error
ER_CHANGE_SLAVE_PARALLEL_THREADS_ACTIVE / 1963: external data source error
ER_SLAVE_SKIP_NOT_IN_GTID / 1966: external data source error
CR_PROBE_REPLICA_STATUS / 2022: external data source error when the driver provides this symbol
CR_PROBE_REPLICA_HOSTS / 2023: external data source error when the driver provides this symbol
ER_ERROR_ON_MASTER / 3001: external data source error
ER_INCONSISTENT_ERROR / 3002: external data source error
ER_BINLOG_UNSAFE_FULLTEXT_PLUGIN / 3006: external data source error
ER_SLAVE_SQL_THREAD_MUST_STOP / 3017: external data source error
ER_SLAVE_CHANNEL_IO_THREAD_MUST_STOP / 3021: external data source error
ER_WARN_OPEN_TEMP_TABLES_MUST_BE_ZERO / 3022: external data source error
ER_WARN_ONLY_MASTER_LOG_FILE_NO_POS / 3023: external data source error
ER_SLAVE_WORKER_STOPPED_PREVIOUS_THD_ERROR / 3030: external data source error
ER_DONT_SUPPORT_SLAVE_PRESERVE_COMMIT_ORDER / 3031: external data source error
ER_BINLOG_NON_SUPPORTED_BULK / 4033: external data source error
ER_SLAVE_SAME_ID / 4052: external data source error
ER_REQUIRE_ROW_BINLOG_FORMAT / 4056: external data source error
ER_RDB_STATUS_GENERAL / 4067: external data source error
ER_RDB_STATUS_MSG / 4068: external data source error
ER_KEY_CREATE_DURING_ALTER / 4072: external data source error
ER_SK_POPULATE_DURING_ALTER / 4073: external data source error
ER_SEQUENCE_BINLOG_FORMAT / 4088: external data source error
ER_SLAVE_IGNORED_SHARED_TABLE / 4168: external data source error
ER_BINLOG_UNSAFE_SKIP_LOCKED / 4175: external data source error
ER_INCONSISTENT_SLAVE_TEMP_TABLE / 4188: external data source error
ER_VERS_HIST_PART_FAILED / 4189: external data source error
ER_INIT_SLAVE_ERROR / 4226: 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
ER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN / 1907: feature not supported
ER_UNSUPPORTED_ENGINE_FOR_GENERATED_COLUMNS / 1910: feature not supported
ER_QUERY_CACHE_IS_GLOBALY_DISABLED / 1925: feature not supported
ER_SUBQUERIES_NOT_SUPPORTED / 1970: feature not supported
ER_SET_STATEMENT_NOT_SUPPORTED / 1971: 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_FRAME_EXCLUSION_NOT_SUPPORTED / 4022: feature not supported
ER_FLASHBACK_NOT_SUPPORTED / 4053: feature not supported
ER_ISOLATION_MODE_NOT_SUPPORTED / 4057: feature not supported
ER_UNSUPPORTED_COLLATION / 4063: feature not supported
ER_RDB_TTL_UNSUPPORTED / 4069: feature not supported
ER_VERS_ENGINE_UNSUPPORTED / 4111: feature not supported
ER_VERS_ALTER_ENGINE_PROHIBITED / 4120: feature not supported
ER_VERS_DB_NOT_SUPPORTED / 4132: feature not supported
ER_VERS_NOT_SUPPORTED / 4137: feature not supported
ER_VERS_TRX_PART_HISTORIC_ROW_NOT_SUPPORTED / 4138: feature not supported
ER_GALERA_REPLICATION_NOT_SUPPORTED / 4165: feature not supported
ER_PARTITION_CONVERT_SUBPARTITIONED / 4184: feature not supported
ER_JSON_SCHEMA_KEYWORD_UNSUPPORTED / 4194: feature not supported
ER_JSON_NO_VARIABLE_SCHEMA / 4195: feature not supported
ER_HINTS_INSIDE_VIEWS_NOT_SUPPORTED / 4223: feature not supported
ER_WARN_HINTS_ON_INSERT_PART_OF_INSERT_SELECT / 4225: 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
ER_SEQUENCE_INVALID_DATA / 4085: sequence corruption
ER_SEQUENCE_INVALID_TABLE_STRUCTURE / 4086: sequence corruption
corruptionType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
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
ER_METADATA_INCONSISTENCY / 4064: checksum corruption
corruptionType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Internal SQL_INTERNAL_ERROR
errorType
engine internal
ER_UNUSED_17 / 1101: engine internal
ER_UNACCEPTABLE_MUTUAL_RECURSION / 4006: engine internal
ER_JSON_DEPTH / 4040: engine internal
ER_JSON_PATH_DEPTH / 4043: engine internal
ER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE / 4047: engine internal
ER_ROLLBACK_TO_SAVEPOINT / 4061: engine internal
ER_ISOLATION_LEVEL_WITH_CONSISTENT_SNAPSHOT / 4062: engine internal
ER_ROW_VARIABLE_DOES_NOT_HAVE_FIELD / 4082: engine internal
ER_UNKNOWN_VIEW / 4092: engine internal
ER_PACKAGE_ROUTINE_IN_SPEC_NOT_DEFINED_IN_BODY / 4095: engine internal
ER_PACKAGE_ROUTINE_FORWARD_DECLARATION_NOT_DEFINED / 4096: engine internal
ER_COMPRESSED_COLUMN_USED_AS_KEY / 4097: engine internal
ER_CONFLICTING_FOR_SYSTEM_TIME / 4122: engine internal
ER_VERS_NO_TRX_ID / 4129: engine internal
ER_VERS_TRT_IS_DISABLED / 4133: engine internal
ER_EMPTY_ROW_IN_TVC / 4141: engine internal
ER_VERS_QUERY_IN_PARTITION / 4142: engine internal
ER_KEY_DOESNT_SUPPORT / 4143: engine internal
ER_PERIOD_CONSTRAINT_DROP / 4158: 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_INVALID_BUFFER_USE / 2035: api misuse
CR_* / error numbers 2001-2999 fallback: api misuse
errorType
databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage
Fallback SQL_UNKNOWN unmapped explicit driver code or numeric error with no active-database symbol: unknown databaseErrorCode when available
databaseErrorNumber when available
databaseErrorMessage