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_VIOLATEDconstraintType unique |
ER_DUP_KEY / 1022: unique constraint violationER_DUP_ENTRY / 1062: unique constraint violationER_DUP_UNIQUE / 1169: unique constraint violationER_FOREIGN_DUPLICATE_KEY / 1557: unique constraint violationER_DUP_ENTRY_WITH_KEY_NAME / 1586: unique constraint violationER_FOREIGN_DUPLICATE_KEY_WITH_CHILD_INFO / 1761: unique constraint violationER_FOREIGN_DUPLICATE_KEY_WITHOUT_CHILD_INFO / 1762: unique constraint violationER_DUP_UNKNOWN_IN_INDEX / 1859: unique constraint violationER_ON_DUPLICATE_DISABLED / 4058: unique constraint violation |
constraintTypeconstraintName when inferredtableName when inferredcolumnName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Constraints | SQL_CONSTRAINT_VIOLATEDconstraintType not null |
ER_BAD_NULL_ERROR / 1048: not null constraint violation |
constraintTypeconstraintName when inferredtableName when inferredcolumnName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Constraints | SQL_CONSTRAINT_VIOLATEDconstraintType foreign key |
ER_NO_REFERENCED_ROW / 1216: foreign key constraint violationER_ROW_IS_REFERENCED / 1217: foreign key constraint violationER_ROW_IS_REFERENCED_2 / 1451: foreign key constraint violationER_NO_REFERENCED_ROW_2 / 1452: foreign key constraint violationER_FK_DEPTH_EXCEEDED / 3008: foreign key constraint violation |
constraintTypeconstraintName when inferredtableName when inferredcolumnName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Constraints | SQL_CONSTRAINT_VIOLATEDconstraintType check |
ER_CONSTRAINT_FAILED / 4025: check constraint violation |
constraintTypeconstraintName when inferredtableName when inferredcolumnName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Constraints | SQL_CONSTRAINT_VIOLATEDconstraintType exclusion |
- | - |
| Constraints | SQL_CONSTRAINT_VIOLATEDconstraintType restrict |
- | - |
| Constraints | SQL_CONSTRAINT_VIOLATED |
server constraint sets above | databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType too long |
ER_TOO_LONG_STRING / 1162: too longER_DATA_TOO_LONG / 1406: too longER_STD_LENGTH_ERROR / 3046: too longER_CHANGE_MASTER_PASSWORD_LENGTH / 3056: too longER_TOO_LONG_DATABASE_COMMENT / 4160: too longWARN_SORTING_ON_TRUNCATED_LENGTH / 4203: too long |
errorTypetableName when inferredcolumnName when inferredtypeName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType out of range |
ER_WARN_DATA_OUT_OF_RANGE / 1264: out of rangeER_DATA_OUT_OF_RANGE / 1690: out of rangeER_INVALID_ARGUMENT_FOR_LOGARITHM / 3020: out of rangeER_STD_OUT_OF_RANGE_ERROR / 3048: out of rangeER_STD_OVERFLOW_ERROR / 3049: out of rangeER_STD_RANGE_ERROR / 3050: out of rangeER_STD_UNDERFLOW_ERROR / 3051: out of rangeER_ARGUMENT_OUT_OF_RANGE / 4103: out of rangeER_PART_WRONG_VALUE / 4127: out of rangeER_PARSING_PRECISION / 45050 (mariadb): out of range |
errorTypetableName when inferredcolumnName when inferredtypeName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType invalid value |
ER_TRUNCATED_WRONG_VALUE / 1292: invalid valueER_TRUNCATED_WRONG_VALUE_FOR_FIELD / 1366: invalid valueER_ILLEGAL_VALUE_FOR_TYPE / 1367: invalid valueER_WRONG_VALUE_FOR_TYPE / 1411: invalid valueER_CANT_CREATE_GEOMETRY_OBJECT / 1416: invalid valueER_GIS_DIFFERENT_SRIDS / 3033: invalid valueER_GIS_UNSUPPORTED_ARGUMENT / 3034: invalid valueER_GIS_UNKNOWN_ERROR / 3035: invalid valueER_GIS_UNKNOWN_EXCEPTION / 3036: invalid valueER_GIS_INVALID_DATA / 3037: invalid valueER_BOOST_GEOMETRY_EMPTY_INPUT_EXCEPTION / 3038: invalid valueER_BOOST_GEOMETRY_CENTROID_EXCEPTION / 3039: invalid valueER_BOOST_GEOMETRY_OVERLAY_INVALID_INPUT_EXCEPTION / 3040: invalid valueER_BOOST_GEOMETRY_TURN_INFO_EXCEPTION / 3041: invalid valueER_BOOST_GEOMETRY_SELF_INTERSECTION_POINT_EXCEPTION / 3042: invalid valueER_BOOST_GEOMETRY_UNKNOWN_EXCEPTION / 3043: invalid valueER_STD_DOMAIN_ERROR / 3045: invalid valueER_STD_INVALID_ARGUMENT / 3047: invalid valueER_KEYS_OUT_OF_ORDER / 4054: invalid valueER_OVERLAPPING_KEYS / 4055: invalid valueER_RDB_TTL_DURATION_FORMAT / 4066: invalid valueER_RDB_TTL_COL_FORMAT / 4070: invalid valueER_ILLEGAL_PARAMETER_DATA_TYPES2_FOR_OPERATION / 4078: invalid valueER_ILLEGAL_PARAMETER_DATA_TYPE_FOR_OPERATION / 4079: invalid valueER_WRONG_TYPE_FOR_PERCENTILE_FUNC / 4101: invalid valueER_ARGUMENT_NOT_CONSTANT / 4102: invalid valueER_WRONG_TYPE_OF_ARGUMENT / 4104: invalid valueER_PERIOD_TYPES_MISMATCH / 4153: invalid valueER_WARN_HISTORY_ROW_START_TIME / 4163: invalid valueER_PART_STARTS_BEYOND_INTERVAL / 4164: invalid value |
errorTypetableName when inferredcolumnName when inferredtypeName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType invalid format |
ER_DYN_COL_WRONG_FORMAT / 1919: invalid formatER_BAD_BASE64_DATA / 1958: invalid formatER_GIS_DATA_WRONG_ENDIANESS / 3055: invalid formatER_UNKNOWN_COMPRESSION_METHOD / 4098: invalid formatER_VECTOR_BINARY_FORMAT_INVALID / 4204: invalid formatER_VECTOR_FORMAT_INVALID / 4205: invalid format |
errorTypetableName when inferredcolumnName when inferredtypeName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType invalid encoding |
ER_DYN_COL_WRONG_CHARSET / 1922: invalid encodingER_CANNOT_CONVERT_CHARACTER / 1977: invalid encoding |
errorTypetableName when inferredcolumnName when inferredtypeName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType invalid json |
ER_JSON_BAD_CHR / 4035: invalid jsonER_JSON_NOT_JSON_CHR / 4036: invalid jsonER_JSON_EOS / 4037: invalid jsonER_JSON_SYNTAX / 4038: invalid jsonER_JSON_ESCAPING / 4039: invalid jsonER_JSON_PATH_EOS / 4041: invalid jsonER_JSON_PATH_SYNTAX / 4042: invalid jsonER_JSON_PATH_NO_WILDCARD / 4044: invalid jsonER_JSON_PATH_ARRAY / 4045: invalid jsonER_JSON_ONE_OR_ALL / 4046: invalid jsonER_GEOJSON_INCORRECT / 4048: invalid jsonER_GEOJSON_TOO_FEW_POINTS / 4049: invalid jsonER_GEOJSON_NOT_CLOSED / 4050: invalid jsonER_JSON_PATH_EMPTY / 4051: invalid jsonER_GEOJSON_EMPTY_COORDINATES / 4076: invalid jsonER_JSON_TABLE_ERROR_ON_FIELD / 4176: invalid jsonER_JSON_TABLE_SCALAR_EXPECTED / 4178: invalid jsonER_JSON_TABLE_MULTIPLE_MATCHES / 4179: invalid jsonER_JSON_HISTOGRAM_PARSE_FAILED / 4186: invalid jsonER_JSON_INVALID_VALUE_FOR_KEYWORD / 4193: invalid json |
errorTypetableName when inferredcolumnName when inferredtypeName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType invalid xml |
- | - |
| Values | SQL_INVALID_VALUEerrorType invalid regular expression |
ER_REGEXP_ERROR / 1139: invalid regular expression |
errorTypetableName when inferredcolumnName when inferredtypeName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType null not allowed |
ER_INVALID_USE_OF_NULL / 1138: null not allowedER_WARN_NULL_TO_NOTNULL / 1263: null not allowed |
errorTypetableName when inferredcolumnName when inferredtypeName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType sequence limit |
ER_SEQUENCE_RUN_OUT / 4084: sequence limit |
errorTypetableName when inferredcolumnName when inferredtypeName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType missing |
ER_MISSING / 4125: missing parameterER_WRONG_ARGUMENTS / 1210: missing parameter when the message indicates an unbound or missing argumentER_NO_DEFAULT / 1230: missing parameter when the message reports a missing default or valueCR_PARAMS_NOT_BOUND / 2031: missing parameter when the message reports an unbound parameterER_MISSING_PARAMETER / 45016 (mariadb): missing parameterER_PARAMETER_UNDEFINED / 45017 (mariadb): missing parameterER_PLACEHOLDER_UNDEFINED / 45018 (mariadb): missing parameterER_BATCH_WITH_NO_VALUES / 45031 (mariadb): missing parameterER_UNDEFINED_SQL / 45049 (mariadb): missing parameterER_MISSING_SQL_PARAMETER / 45052 (mariadb): missing parameterER_MISSING_DATABASE_PARAMETER / 45055 (mariadb): missing parameter |
parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType too many |
- | - |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType wrong count |
ER_WRONG_PARAMCOUNT_TO_NATIVE_FCT / 1582: wrong count parameter when the message reports parameter-count detailsER_WRONG_PARAMETERS_TO_NATIVE_FCT / 1583: wrong count parameter when the message reports parameter-count detailsER_WRONG_PARAMETERS_TO_STORED_FCT / 1584: wrong count parameter when the message reports parameter-count detailsER_SP_WRONG_NO_OF_ARGS / 1318: wrong count parameter when the message reports the wrong number of arguments |
parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType invalid name |
- | - |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType invalid index |
- | - |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType invalid type |
CR_NO_PARAMETERS_EXISTS / 2033: invalid type parameter when the message reports an unsupported parameter typeCR_INVALID_PARAMETER_NO / 2034: invalid type parameter when the message reports an unsupported parameter typeCR_UNSUPPORTED_PARAM_TYPE / 2036: invalid type parameter when the message reports an unsupported parameter typeER_WRONG_VALUE_FOR_VAR / 1231: invalid type parameter when the message reports an incorrect argument typeER_WRONG_TYPE_FOR_VAR / 1232: invalid type parameter when the message reports an incorrect argument type |
parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType invalid value |
ER_WRONG_PARAMCOUNT_TO_PROCEDURE / 1107: invalid value parameterER_WRONG_PARAMETERS_TO_PROCEDURE / 1108: invalid value parameterER_WRONG_ARGUMENTS / 1210: invalid value parameter when no more specific parameter subtype is inferred from the messageER_NO_DEFAULT / 1230: invalid value parameter when no more specific parameter subtype is inferred from the messageER_WRONG_VALUE_FOR_VAR / 1231: invalid value parameter when no more specific parameter subtype is inferred from the messageER_WRONG_TYPE_FOR_VAR / 1232: invalid value parameter when no more specific parameter subtype is inferred from the messageER_BAD_SLAVE_UNTIL_COND / 1277: invalid value parameterER_SP_WRONG_NO_OF_ARGS / 1318: invalid value parameter when no more specific parameter subtype is inferred from the messageER_SP_DUP_PARAM / 1330: invalid value parameterER_SP_DUP_VAR / 1331: invalid value parameterER_SP_DUP_COND / 1332: invalid value parameterER_SP_DUP_CURS / 1333: invalid value parameterER_SP_NOT_VAR_ARG / 1414: invalid value parameterER_WRONG_PARAMCOUNT_TO_NATIVE_FCT / 1582: invalid value parameter when no more specific parameter subtype is inferred from the messageER_WRONG_PARAMETERS_TO_NATIVE_FCT / 1583: invalid value parameter when no more specific parameter subtype is inferred from the messageER_WRONG_PARAMETERS_TO_STORED_FCT / 1584: invalid value parameter when no more specific parameter subtype is inferred from the messageER_DA_INVALID_CONDITION_NUMBER / 1758: invalid value parameterER_BAD_OPTION_VALUE / 1912: invalid value parameterER_WRONG_PARAMCOUNT_TO_CURSOR / 4080: invalid value parameterER_SF_OUT_INOUT_ARG_NOT_ALLOWED / 4187: invalid value parameterER_BAD_PARAMETER_VALUE / 45043 (mariadb): invalid value parameterCR_PARAMS_NOT_BOUND / 2031: invalid value parameter when no more specific parameter subtype is inferred from the messageCR_NO_PARAMETERS_EXISTS / 2033: invalid value parameter when no more specific parameter subtype is inferred from the messageCR_INVALID_PARAMETER_NO / 2034: invalid value parameter when no more specific parameter subtype is inferred from the messageCR_UNSUPPORTED_PARAM_TYPE / 2036: invalid value parameter when no more specific parameter subtype is inferred from the message |
parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType invalid binding |
- | - |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType not bindable |
- | - |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType already bound |
- | - |
| Parameters | SQL_INVALID_PARAMETER |
- | - |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType database |
ER_DB_DROP_EXISTS / 1008: database not foundER_NO_DB_ERROR / 1046: database not foundER_BAD_DB_ERROR / 1049: database not found |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType schema |
- | - |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType table or view |
ER_BAD_TABLE_ERROR / 1051: table or view not foundER_UNKNOWN_TABLE / 1109: table or view not foundER_NO_SUCH_TABLE / 1146: table or view not found |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType column |
ER_BAD_FIELD_ERROR / 1054: column not foundER_KEY_COLUMN_DOES_NOT_EXITS / 1072: column not found |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType routine |
ER_UNKNOWN_PROCEDURE / 1106: routine not foundER_CANT_FIND_UDF / 1122: routine not foundER_FUNCTION_NOT_DEFINED / 1128: routine not foundER_SP_DOES_NOT_EXIST / 1305: routine not foundER_FUNC_INEXISTENT_NAME_COLLISION / 1630: routine not found |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType sequence |
ER_UNKNOWN_SEQUENCES / 4091: sequence not found |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType collation |
- | - |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType index |
ER_CANT_DROP_FIELD_OR_KEY / 1091: index not foundER_KEY_DOES_NOT_EXITS / 1176: index not foundER_FT_MATCHING_KEY_NOT_FOUND / 1191: index not foundER_VEC_DISTANCE_TYPE / 4206: index not foundER_UNRESOLVED_INDEX_HINT_NAME / 4222: index not found |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType trigger |
ER_REFERENCED_TRG_DOES_NOT_EXIST_MYSQL / 3011: trigger not foundER_REFERENCED_TRG_DOES_NOT_EXIST / 4031: trigger not found |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType cursor |
- | - |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType prepared statement |
- | - |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType role |
ER_ROLE_DROP_EXISTS / 1976: role not found |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUND |
ER_PERIOD_NOT_FOUND / 4156: object not found |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType database |
ER_DB_CREATE_EXISTS / 1007: database already exists |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType schema |
- | - |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType table or view |
ER_TABLE_EXISTS_ERROR / 1050: table or view already exists |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType column |
ER_DUP_FIELDNAME / 1060: column already existsER_FIELD_SPECIFIED_TWICE / 1110: column already exists |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType routine |
ER_UDF_EXISTS / 1125: routine already existsER_SP_ALREADY_EXISTS / 1304: routine already exists |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType sequence |
- | - |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType index |
ER_DUP_KEYNAME / 1061: index already exists |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType trigger |
- | - |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType cursor |
- | - |
| Object already exists | SQL_OBJECT_ALREADY_EXISTSobjectType prepared statement |
- | - |
| Object already exists | SQL_OBJECT_ALREADY_EXISTS |
ER_CONNECTION_ALREADY_EXISTS / 1934: object already existsER_PLUGIN_INSTALLED / 1968: object already existsER_USER_CREATE_EXISTS / 1973: object already existsER_ROLE_CREATE_EXISTS / 1975: object already exists |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object state | SQL_OBJECT_STATE_ERRORobjectStateErrorType invalid state |
ER_SP_CURSOR_ALREADY_OPEN / 1325: invalid stateER_SP_CURSOR_NOT_OPEN / 1326: invalid stateER_QUERY_CACHE_IS_DISABLED / 1924: invalid stateER_SEQUENCE_ACCESS_ERROR / 4087: invalid stateER_VERS_ALREADY_VERSIONED / 4135: invalid stateER_BACKUP_LOCK_IS_ACTIVE / 4145: invalid stateER_BACKUP_NOT_RUNNING / 4146: invalid stateER_BACKUP_WRONG_STAGE / 4147: invalid stateER_BACKUP_STAGE_FAILED / 4148: invalid stateER_BACKUP_UNKNOWN_STAGE / 4149: invalid stateER_PREPARE_CLOSED / 45051 (mariadb): invalid state |
objectStateErrorTypeobjectType when inferredschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object state | SQL_OBJECT_STATE_ERRORobjectStateErrorType wrong object type |
ER_IT_IS_A_VIEW / 1965: wrong object typeER_NOT_SEQUENCE / 4089: wrong object typeER_NOT_SEQUENCE2 / 4090: wrong object typeER_VERS_NOT_VERSIONED / 4124: wrong object type |
objectStateErrorTypeobjectType when inferredschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object state | SQL_OBJECT_STATE_ERRORobjectStateErrorType object in use |
- | - |
| Object state | SQL_OBJECT_STATE_ERRORobjectStateErrorType dependent objects still exist |
- | - |
| Statement | SQL_SYNTAX_ERROR |
ER_PARSE_ERROR / 1064: syntax errorER_SYNTAX_ERROR / 1149: syntax error |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_AMBIGUOUS_IDENTIFIERidentifierErrorType ambiguous |
ER_NON_UNIQ_ERROR / 1052: ambiguous identifier |
identifier when inferredidentifierType when inferredidentifierErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_AMBIGUOUS_IDENTIFIERidentifierErrorType duplicate |
ER_NONUNIQ_TABLE / 1066: duplicate identifierER_DUP_QUERY_NAME / 4004: duplicate identifierER_DUP_WINDOW_NAME / 4010: duplicate identifierER_VERS_DUPLICATE_ROW_START_END / 4134: duplicate identifierER_DUPLICATE_FIELD / 45040 (mariadb): duplicate identifier |
identifier when inferredidentifierType when inferredidentifierErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_AMBIGUOUS_IDENTIFIER |
- | - |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType incomplete statement |
- | - |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid definition |
ER_CANT_CREATE_TABLE / 1005: invalid definitionER_WRONG_FIELD_SPEC / 1063: invalid definitionER_INVALID_DEFAULT / 1067: invalid definitionER_MULTIPLE_PRI_KEY / 1068: invalid definitionER_TOO_MANY_KEYS / 1069: invalid definitionER_TOO_MANY_KEY_PARTS / 1070: invalid definitionER_TOO_LONG_KEY / 1071: invalid definitionER_BLOB_USED_AS_KEY / 1073: invalid definitionER_TOO_BIG_FIELDLENGTH / 1074: invalid definitionER_WRONG_AUTO_KEY / 1075: invalid definitionER_WRONG_SUB_KEY / 1089: invalid definitionER_TABLE_MUST_HAVE_COLUMNS / 1113: invalid definitionER_NULL_COLUMN_IN_INDEX / 1121: invalid definitionER_WRONG_COLUMN_NAME / 1166: invalid definitionER_WRONG_KEY_COLUMN / 1167: invalid definitionER_BLOB_KEY_WITHOUT_LENGTH / 1170: invalid definitionER_PRIMARY_CANT_HAVE_NULL / 1171: invalid definitionER_REQUIRES_PRIMARY_KEY / 1173: invalid definitionER_CANNOT_ADD_FOREIGN / 1215: invalid definitionER_WRONG_FK_DEF / 1239: invalid definitionER_SPATIAL_CANT_HAVE_NULL / 1252: invalid definitionER_WRONG_NAME_FOR_INDEX / 1280: invalid definitionER_WRONG_NAME_FOR_CATALOG / 1281: invalid definitionER_SP_NORETURN / 1320: invalid definitionER_SP_BAD_CURSOR_QUERY / 1322: invalid definitionER_SP_BAD_CURSOR_SELECT / 1323: invalid definitionER_SP_UNDECLARED_VAR / 1327: invalid definitionER_SP_VARCOND_AFTER_CURSHNDLR / 1337: invalid definitionER_SP_CURSOR_AFTER_HANDLER / 1338: invalid definitionER_SP_BAD_SQLSTATE / 1407: invalid definitionER_TOO_BIG_SCALE / 1425: invalid definitionER_TOO_BIG_PRECISION / 1426: invalid definitionER_M_BIGGER_THAN_D / 1427: invalid definitionER_TOO_BIG_DISPLAYWIDTH / 1439: invalid definitionER_SP_BAD_VAR_SHADOW / 1453: invalid definitionER_SP_WRONG_NAME / 1458: invalid definitionER_GENERATED_COLUMN_FUNCTION_IS_NOT_ALLOWED / 1901: invalid definitionER_PRIMARY_KEY_BASED_ON_GENERATED_COLUMN / 1903: invalid definitionER_KEY_BASED_ON_GENERATED_VIRTUAL_COLUMN / 1904: invalid definitionER_WRONG_FK_OPTION_FOR_GENERATED_COLUMN / 1905: invalid definitionER_TABLE_DEFINITION_TOO_BIG / 1967: invalid definitionER_CANNOT_DISCARD_TEMPORARY_TABLE / 3007: invalid definitionER_MISSING_HA_CREATE_OPTION / 3014: invalid definitionER_NO_FT_MATERIALIZED_SUBQUERY / 3018: invalid definitionER_RECURSIVE_WITHOUT_ANCHORS / 4005: invalid definitionER_NOT_STANDARD_COMPLIANT_RECURSIVE / 4008: invalid definitionER_WRONG_WINDOW_SPEC_NAME / 4009: invalid definitionER_PARTITION_LIST_IN_REFERENCING_WINDOW_SPEC / 4011: invalid definitionER_ORDER_LIST_IN_REFERENCING_WINDOW_SPEC / 4012: invalid definitionER_WINDOW_FRAME_IN_REFERENCED_WINDOW_SPEC / 4013: invalid definitionER_BAD_COMBINATION_OF_WINDOW_FRAME_BOUND_SPECS / 4014: invalid definitionER_WRONG_PLACEMENT_OF_WINDOW_FUNCTION / 4015: invalid definitionER_WINDOW_FUNCTION_IN_WINDOW_SPEC / 4016: invalid definitionER_NOT_ALLOWED_WINDOW_FRAME / 4017: invalid definitionER_NO_ORDER_LIST_IN_WINDOW_SPEC / 4018: invalid definitionER_RANGE_FRAME_NEEDS_SIMPLE_ORDERBY / 4019: invalid definitionER_WRONG_TYPE_FOR_ROWS_FRAME / 4020: invalid definitionER_WRONG_TYPE_FOR_RANGE_FRAME / 4021: invalid definitionER_WINDOW_FUNCTION_DONT_HAVE_FRAME / 4023: invalid definitionER_INVALID_NTILE_ARGUMENT / 4024: invalid definitionER_PARTITION_DEFAULT_ERROR / 4030: invalid definitionER_INVISIBLE_NOT_NULL_WITHOUT_DEFAULT / 4108: invalid definitionER_VERS_FIELD_WRONG_TYPE / 4110: invalid definitionER_PARTITION_WRONG_TYPE / 4113: invalid definitionER_VERS_DROP_PARTITION_INTERVAL / 4116: invalid definitionER_VERS_ALTER_NOT_ALLOWED / 4119: invalid definitionER_VERS_RANGE_PROHIBITED / 4121: invalid definitionER_VERS_TABLE_MUST_HAVE_COLUMNS / 4123: invalid definitionER_VERS_PERIOD_COLUMNS / 4126: invalid definitionER_VERS_WRONG_PARTS / 4128: invalid definitionER_VERS_ALTER_SYSTEM_FIELD / 4130: invalid definitionER_DROP_VERSIONING_SYSTEM_TIME_PARTITION / 4131: invalid definitionER_PERIOD_TEMPORARY_NOT_ALLOWED / 4152: invalid definitionER_MORE_THAN_ONE_PERIOD / 4154: invalid definitionER_PERIOD_FIELD_WRONG_ATTRIBUTES / 4155: invalid definitionER_PERIOD_COLUMNS_UPDATED / 4157: invalid definitionER_NO_AUTOINCREMENT_WITH_UNIQUE / 4169: invalid definitionER_KEY_CONTAINS_PERIOD_FIELDS / 4170: invalid definitionER_KEY_CANT_HAVE_WITHOUT_OVERLAPS / 4171: invalid definitionER_PK_INDEX_CANT_BE_IGNORED / 4174: invalid definitionER_WITH_TIES_NEEDS_ORDER / 4180: invalid definitionER_CM_OPTION_MISSING_REQUIREMENT / 4191: invalid definitionER_SEQUENCE_TABLE_CANNOT_HAVE_ANY_KEYS / 4198: invalid definitionER_SEQUENCE_TABLE_CANNOT_HAVE_ANY_CONSTRAINTS / 4199: invalid definitionER_SEQUENCE_TABLE_ORDER_BY / 4200: invalid definition |
statementErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType type mismatch |
- | - |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid statement context |
ER_CANT_REMOVE_ALL_FIELDS / 1090: invalid statement contextER_NO_TABLES_USED / 1096: invalid statement contextER_UPDATE_WITHOUT_KEY_IN_SAFE_MODE / 1175: invalid statement contextER_LOCK_OR_ACTIVE_TRANSACTION / 1192: invalid statement contextER_SET_CONSTANTS_ONLY / 1204: invalid statement contextER_WRONG_USAGE / 1221: invalid statement contextER_DUP_ARGUMENT / 1225: invalid statement contextER_LOCAL_VARIABLE / 1228: invalid statement contextER_GLOBAL_VARIABLE / 1229: invalid statement contextER_VAR_CANT_BE_READ / 1233: invalid statement contextER_CANT_USE_OPTION_HERE / 1234: invalid statement contextER_UNKNOWN_STMT_HANDLER / 1243: invalid statement contextER_SP_BADRETURN / 1313: invalid statement contextER_SP_CURSOR_MISMATCH / 1324: invalid statement contextER_ILLEGAL_SUBQUERY_OPTIMIZER_SWITCHES / 1923: invalid statement contextER_STORED_FUNCTION_PREVENTS_SWITCH_SKIP_REPLICATION / 1930: invalid statement contextER_TARGET_NOT_EXPLAINABLE / 1933: invalid statement contextER_STORED_FUNCTION_PREVENTS_SWITCH_GTID_DOMAIN_ID_SEQ_NO / 1954: invalid statement contextER_PASSWORD_EXPIRE_ANONYMOUS_USER / 3016: invalid statement contextER_BAD_COMMAND_IN_MULTI / 4001: invalid statement contextER_NOT_AGGREGATE_FUNCTION / 4105: invalid statement contextER_INVALID_AGGREGATE_FUNCTION / 4106: invalid statement contextER_UPDATED_COLUMN_ONLY_ONCE / 4140: invalid statement contextER_ALTER_OPERATION_TABLE_OPTIONS_NEED_REBUILD / 4144: invalid statement contextER_NOT_ALLOWED_IN_THIS_CONTEXT / 4172: invalid statement contextER_JSON_TABLE_ALIAS_REQUIRED / 4177: invalid statement contextER_PSEUDO_THREAD_ID_OVERWRITE / 4196: invalid statement contextER_WARN_MALFORMED_HINT / 4224: invalid statement context |
statementErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid identifier |
ER_TOO_LONG_IDENT / 1059: invalid identifierER_WRONG_DB_NAME / 1102: invalid identifierER_WRONG_TABLE_NAME / 1103: invalid identifierER_SP_LILABEL_MISMATCH / 1308: invalid identifierER_SP_LABEL_REDEFINE / 1309: invalid identifierER_SP_LABEL_MISMATCH / 1310: invalid identifierER_USER_LOCK_WRONG_NAME / 3057: invalid identifierER_UNKNOWN_STRUCTURED_VARIABLE / 4081: invalid identifierER_END_IDENTIFIER_DOES_NOT_MATCH / 4083: invalid identifierER_NULL_ESCAPEID / 45006 (mariadb): invalid identifierER_NULL_CHAR_ESCAPEID / 45005 (mariadb): invalid identifierER_PRIVATE_FIELDS_USE / 45058 (mariadb): invalid identifier |
statementErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid reference |
ER_UPDATE_TABLE_USED / 1093: invalid referenceER_KEY_REF_DO_NOT_MATCH_TABLE_REF / 1240: invalid referenceER_ILLEGAL_REFERENCE / 1247: invalid referenceER_TABLENAME_NOT_ALLOWED_HERE / 1250: invalid referenceER_NO_EIS_FOR_FIELD / 1980: invalid referenceER_REF_TO_RECURSIVE_WITH_TABLE_IN_DERIVED / 4007: invalid referenceER_EXPRESSION_REFERS_TO_UNINIT_FIELD / 4029: invalid referenceER_FIELD_REFERENCE_IN_TVC / 4100: invalid referenceER_UNRESOLVED_TABLE_HINT_NAME / 4221: invalid reference |
statementErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid grouping |
ER_WRONG_FIELD_WITH_GROUP / 1055: invalid groupingER_WRONG_GROUP_FIELD / 1056: invalid groupingER_WRONG_SUM_SELECT / 1057: invalid groupingER_INVALID_GROUP_FUNC_USE / 1111: invalid groupingER_MIX_OF_GROUP_FUNC_AND_FIELDS / 1140: invalid groupingER_NON_GROUPING_FIELD_USED / 1463: invalid groupingER_WARN_AGGFUNC_DEPENDENCE / 1981: invalid groupingER_AGGREGATE_ORDER_FOR_UNION / 3028: invalid groupingER_AGGREGATE_ORDER_NON_AGG_QUERY / 3029: invalid groupingER_SUM_FUNC_WITH_WINDOW_FUNC_AS_ARG / 4074: invalid grouping |
statementErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid windowing |
- | - |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid recursion |
- | - |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid locator |
- | - |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType case not found |
- | - |
| Statement | SQL_INVALID_SQL_STATEMENTstatementErrorType invalid argument |
- | - |
| Statement | SQL_INVALID_SQL_STATEMENT |
ER_WRONG_OUTER_JOIN / 1120: invalid SQL statementER_CANT_CHANGE_TX_ISOLATION / 1568: invalid SQL statementER_COMMULTI_BADCONTEXT / 4000: invalid SQL statementER_INVALID_DEFAULT_PARAM / 4032: invalid SQL statementER_MYROCKS_CANT_NOPAD_COLLATION / 4077: invalid SQL statementER_* / MY-* wrong, bad, invalid, illegal, cant, or missing fallback: invalid SQL statement |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Execution | SQL_DIVISION_BY_ZERO |
ER_DIVISION_BY_ZER / 1365: division by zero |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Execution | SQL_CARDINALITY_VIOLATION |
ER_WRONG_VALUE_COUNT / 1058: cardinality violationER_WRONG_VALUE_COUNT_ON_ROW / 1136: cardinality violationER_TOO_MANY_ROWS / 1172: cardinality violationER_WRONG_NUMBER_OF_COLUMNS_IN_SELECT / 1222: cardinality violationER_OPERAND_COLUMNS / 1241: cardinality violationER_SUBQUERY_NO_1_ROW / 1242: cardinality violationER_WITH_COL_WRONG_LIST / 4002: cardinality violationER_WRONG_NUMBER_OF_VALUES_IN_TVC / 4099: cardinality violationER_SEQUENCE_TABLE_HAS_WRONG_NUMBER_OF_COLUMNS / 4197: cardinality violationER_INCORRECT_COLUMN_NAME_COUNT / 4202: cardinality violation |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Execution | SQL_ROUTINE_ERROR |
ER_STD_LOGIC_ERROR / 3052: routine errorER_STD_RUNTIME_ERROR / 3053: routine errorER_ERROR_EVALUATING_EXPRESSION / 4027: routine errorER_CALCULATING_DEFAULT_VALUE / 4028: routine errorWARN_SFORMAT_ERROR / 4183: routine error |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Transactions | TRANSACTION_ERRORtransactionErrorType invalid state |
- | - |
| Transactions | TRANSACTION_ERRORtransactionErrorType aborted |
- | - |
| Transactions | TRANSACTION_ERRORtransactionErrorType active transaction |
ER_CANT_DO_THIS_DURING_AN_TRANSACTION / 1179: active transactionER_INSIDE_TRANSACTION_PREVENTS_SWITCH_SKIP_REPLICATION / 1929: active transactionER_INSIDE_TRANSACTION_PREVENTS_SWITCH_GTID_DOMAIN_ID_SEQ_NO / 1953: active transactionER_UPDATES_WITH_CONSISTENT_SNAPSHOT / 4059: active transaction |
transactionErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Transactions | TRANSACTION_ERRORtransactionErrorType serialization failure |
- | - |
| Transactions | TRANSACTION_ERRORtransactionErrorType deadlock |
ER_LOCK_DEADLOCK / 1213: deadlockER_XA_RBDEADLOCK / 1614: deadlock |
transactionErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Transactions | TRANSACTION_ERRORtransactionErrorType transaction rolled back |
ER_ERROR_DURING_COMMIT / 1180: transaction rolled backER_ERROR_DURING_ROLLBACK / 1181: transaction rolled backER_WARNING_NOT_COMPLETE_ROLLBACK / 1196: transaction rolled backER_XA_RBROLLBACK / 1402: transaction rolled backER_PRIOR_COMMIT_FAILED / 1964: transaction rolled backER_ROLLBACK_ONLY / 4060: transaction rolled back |
transactionErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Transactions | TRANSACTION_ERRORtransactionErrorType outcome unknown |
ER_DATA_WAS_COMMITED_UNDER_ROLLBACK / 4173: outcome unknown |
transactionErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Transactions | TRANSACTION_ERRORtransactionErrorType invalid savepoint |
- | - |
| Transactions | TRANSACTION_ERRORtransactionErrorType 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_TIMEOUTtimeoutType connection |
ER_NET_READ_INTERRUPTED / 1159: connection timeoutER_NET_WRITE_INTERRUPTED / 1161: connection timeout |
timeoutTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Timeouts | SQL_TIMEOUTtimeoutType lock |
ER_LOCK_WAIT_TIMEOUT / 1205: lock timeoutER_XA_RBTIMEOUT / 1613: lock timeoutER_USER_LOCK_DEADLOCK / 3058: lock timeoutER_* / MY-* lock fallback: lock timeout |
timeoutTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Timeouts | SQL_TIMEOUTtimeoutType statement |
ER_QUERY_RESULT_INCOMPLETE / 1931: statement timeoutER_STATEMENT_TIMEOUT / 1969: statement timeoutER_QUERY_TIMEOUT / 3024: statement timeoutER_SLAVE_STATEMENT_TIMEOUT / 4192: statement timeout |
timeoutTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Timeouts | SQL_TIMEOUTtimeoutType transaction |
- | - |
| Timeouts | SQL_TIMEOUTtimeoutType idle transaction |
- | - |
| Timeouts | SQL_TIMEOUTtimeoutType cancelled |
ER_QUERY_INTERRUPTED / 1317: cancelled timeout |
timeoutTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Timeouts | SQL_TIMEOUTtimeoutType database file busy |
- | - |
| Connections | SQL_CONNECTION_ERRORerrorType connection lost |
ER_HANDSHAKE_ERROR / 1043: connection lostER_UNKNOWN_COM_ERROR / 1047: connection lostER_SERVER_SHUTDOWN / 1053: connection lostER_FORCING_CLOSE / 1080: connection lostER_IPSOCK_ERROR / 1081: connection lostER_ABORTING_CONNECTION / 1152: connection lostER_NET_READ_ERROR_FROM_PIPE / 1154: connection lostER_NET_FCNTL_ERROR / 1155: connection lostER_NET_PACKETS_OUT_OF_ORDER / 1156: connection lostER_NET_UNCOMPRESS_ERROR / 1157: connection lostER_NET_READ_ERROR / 1158: connection lostER_NET_ERROR_ON_WRITE / 1160: connection lostER_NEW_ABORTING_CONNECTION / 1184: connection lostER_MASTER_NET_READ / 1189: connection lostER_MASTER_NET_WRITE / 1190: connection lostER_CONNECT_TO_MASTER / 1218: connection lostER_CONNECTION_KILLED / 1927: connection lost |
errorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Connections | SQL_CONNECTION_ERRORerrorType temporarily unavailable |
ER_HOST_IS_BLOCKED / 1129: temporarily unavailableER_SERVER_OFFLINE_MODE / 3032: temporarily unavailableER_POOL_NO_CONNECTION / 45061 (mariadb): temporarily unavailable |
errorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Connections | SQL_CONNECTION_ERRORerrorType invalid connection configuration |
ER_BAD_HOST_ERROR / 1042: invalid connection configuration |
errorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Connections | SQL_CONNECTION_ERRORerrorType pool error |
- | - |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType memory |
ER_OUTOFMEMORY / 1037: memory resource limitER_OUT_OF_SORTMEMORY / 1038: memory resource limitER_OUT_OF_RESOURCES / 1041: memory resource limitER_STACK_OVERRUN / 1119: memory resource limitER_CANT_CREATE_THREAD / 1135: memory resource limitER_LOCK_TABLE_FULL / 1206: memory resource limitER_ZLIB_Z_MEM_ERROR / 1257: memory resource limitER_ENGINE_OUT_OF_MEMORY / 3015: memory resource limitER_STD_BAD_ALLOC_ERROR / 3044: memory resource limit |
resourceTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType disk |
ER_RECORD_FILE_FULL / 1114: disk resource limitER_TRANS_CACHE_FULL / 1197: disk resource limitER_INNODB_UNDO_LOG_FULL / 3019: disk resource limitER_INDEX_FILE_FULL / 4139: disk resource limit |
resourceTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType temp space |
- | - |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType connections |
ER_CON_COUNT_ERROR / 1040: connections resource limitER_TOO_MANY_USER_CONNECTIONS / 1203: connections resource limit |
resourceTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType pool |
ER_GET_CONNECTION_TIMEOUT / 45028 (mariadb): pool resource limit |
resourceTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType cpu |
- | - |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType file size |
- | - |
| Resources | SQL_RESOURCE_LIMIT_REACHED |
ER_TOO_BIG_SELECT / 1104: resource limit reachedER_TOO_MANY_TABLES / 1116: resource limit reachedER_TOO_MANY_FIELDS / 1117: resource limit reachedER_TOO_BIG_ROWSIZE / 1118: resource limit reachedER_USER_LIMIT_REACHED / 1226: resource limit reachedER_ZLIB_Z_BUF_ERROR / 1258: resource limit reachedER_TOO_LONG_BODY / 1437: resource limit reachedER_MAX_PREPARED_STMT_COUNT_REACHED / 1461: resource limit reachedER_DYN_COL_IMPLEMENTATION_LIMIT / 1920: resource limit reachedER_TOO_MANY_DEFINITIONS_IN_WITH_CLAUSE / 4003: resource limit reachedER_EXPRESSION_IS_TOO_BIG / 4026: resource limit reachedER_NET_OK_PACKET_TOO_LARGE / 4075: resource limit reachedER_MAX_ALLOWED_PACKET / 45046 (mariadb): resource limit reached |
resourceTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Access | SQL_AUTHENTICATION_ERROR |
ER_ACCESS_DENIED_ERROR / 1045: authentication errorER_ACCESS_DENIED_NO_PASSWORD_ERROR / 1698: authentication errorER_ACCESS_DENIED_CHANGE_USER_ERROR / 1873: authentication errorER_USER_IS_BLOCKED / 4150: authentication error |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Access | SQL_AUTHORIZATION_ERROR |
ER_DBACCESS_DENIED_ERROR / 1044: authorization errorER_HOST_NOT_PRIVILEGED / 1130: authorization error |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Access | SQL_PERMISSION_DENIED |
ER_KILL_DENIED_ERROR / 1095: permission deniedER_TABLEACCESS_DENIED_ERROR / 1142: permission deniedER_COLUMNACCESS_DENIED_ERROR / 1143: permission deniedER_ILLEGAL_GRANT_FOR_TABLE / 1144: permission deniedER_NO_PERMISSION_TO_CREATE_USER / 1211: permission deniedER_SPECIFIC_ACCESS_DENIED_ERROR / 1227: permission deniedER_REVOKE_GRANTS / 1269: permission deniedER_PROCACCESS_DENIED_ERROR / 1370: permission deniedER_NONEXISTING_PROC_GRANT / 1403: permission deniedER_CANT_CREATE_USER_WITH_GRANT / 1410: permission deniedER_CANNOT_GRANT_ROLE / 1961: permission deniedER_CANNOT_REVOKE_ROLE / 1962: permission deniedER_KILL_QUERY_DENIED_ERROR / 1979: permission deniedER_REPLACE_INACCESSIBLE_ROWS / 3059: permission deniedER_ACCOUNT_HAS_BEEN_LOCKED / 4151: permission deniedER_LOAD_INFILE_CAPABILITY_DISABLED / 4166: permission deniedER_LOCAL_INFILE_DISABLED / 45021 (mariadb): permission denied |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Access | SQL_READ_ONLY_VIOLATION |
ER_OPEN_AS_READONLY / 1036: read only violationER_TABLE_NOT_LOCKED_FOR_WRITE / 1099: read only violationER_READ_ONLY_TRANSACTION / 1207: read only violationER_CANT_UPDATE_WITH_READLOCK / 1223: read only violationER_CANT_EXECUTE_IN_READ_ONLY_TRANSACTION / 1792: read only violation |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Configuration | SQL_CONFIGURATION_ERRORconfigurationErrorType configuration file |
- | - |
| Configuration | SQL_CONFIGURATION_ERRORconfigurationErrorType lock file |
- | - |
| Configuration | SQL_CONFIGURATION_ERRORconfigurationErrorType runtime parameter |
ER_UNKNOWN_SYSTEM_VARIABLE / 1193: runtime parameter configuration errorER_INCORRECT_GLOBAL_LOCAL_VAR / 1238: runtime parameter configuration errorER_UNKNOWN_COLLATION / 1273: runtime parameter configuration errorER_UNKNOWN_KEY_CACHE / 1284: runtime parameter configuration errorER_UNKNOWN_STORAGE_ENGINE / 1286: runtime parameter configuration errorER_UNKNOWN_OPTION / 1911: runtime parameter configuration errorER_STORAGE_ENGINE_NOT_LOADED / 3003: runtime parameter configuration errorER_COL_COUNT_DOESNT_MATCH_PLEASE_UPDATE_V2 / 3009: runtime parameter configuration errorER_SQL_MODE_NO_EFFECT / 3027: runtime parameter configuration errorER_CF_DIFFERENT / 4065: runtime parameter configuration errorER_NO_SECURE_TRANSPORTS_CONFIGURED / 4167: runtime parameter configuration errorER_STORAGE_ENGINE_DISABLED / 4182: runtime parameter configuration errorER_PROVIDER_NOT_LOADED / 4185: runtime parameter configuration errorER_VARIABLE_IGNORED / 4201: runtime parameter configuration error |
configurationErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType read |
ER_CANT_READ_DIR / 1018: read I/O errorER_ERROR_ON_READ / 1024: read I/O errorER_LOCAL_INFILE_NOT_READABLE / 45022 (mariadb): read I/O errorER_SQL_FILE_ERROR / 45054 (mariadb): read I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType write |
ER_CANT_CREATE_FILE / 1004: write I/O errorER_CANT_CREATE_DB / 1006: write I/O errorER_ERROR_ON_WRITE / 1026: write I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType fsync |
- | - |
| I/O | SQL_IO_ERRORioErrorType truncate |
- | - |
| I/O | SQL_IO_ERRORioErrorType file stat |
ER_CANT_GET_STAT / 1013: file stat I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType lock |
ER_CANT_LOCK / 1015: lock I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType unlock |
- | - |
| I/O | SQL_IO_ERRORioErrorType delete |
- | - |
| I/O | SQL_IO_ERRORioErrorType file not found |
ER_FILE_NOT_FOUND / 1017: file not found I/O errorER_MISSING_SQL_FILE / 45053 (mariadb): file not found I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType access |
ER_LOCAL_INFILE_WRONG_FILENAME / 45034 (mariadb): access I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType shared memory |
- | - |
| I/O | SQL_IO_ERRORioErrorType seek |
- | - |
| I/O | SQL_IO_ERRORioErrorType mmap |
- | - |
| I/O | SQL_IO_ERRORioErrorType path |
ER_DB_DROP_RMDIR / 1010: path I/O errorER_ERROR_ON_RENAME / 1025: path I/O errorER_TEXTFILE_NOT_READABLE / 1085: path I/O errorER_FILE_EXISTS_ERROR / 1086: path I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType atomic write |
- | - |
| I/O | SQL_IO_ERRORioErrorType close |
- | - |
| I/O | SQL_IO_ERRORioErrorType reserved extension |
- | - |
| I/O | SQL_IO_ERRORioErrorType unknown |
ER_* / MY-* file, directory, read, write, or open fallback: unknown I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| External | SQL_EXTERNAL_DATA_SOURCE_ERROR |
ER_MASTER_LOG_PREFIX / 1935: external data source errorER_CANT_START_STOP_SLAVE / 1936: external data source errorER_SLAVE_STARTED / 1937: external data source errorER_SLAVE_STOPPED / 1938: external data source errorER_SQL_DISCOVER_ERROR / 1939: external data source errorER_FAILED_GTID_STATE_INIT / 1940: external data source errorER_INCORRECT_GTID_STATE / 1941: external data source errorER_CANNOT_UPDATE_GTID_STATE / 1942: external data source errorER_DUPLICATE_GTID_DOMAIN / 1943: external data source errorER_GTID_POSITION_NOT_FOUND_IN_BINLOG / 1945: external data source errorER_CANNOT_LOAD_SLAVE_GTID_STATE / 1946: external data source errorER_MASTER_GTID_POS_CONFLICTS_WITH_BINLOG / 1947: external data source errorER_MASTER_GTID_POS_MISSING_DOMAIN / 1948: external data source errorER_UNTIL_REQUIRES_USING_GTID / 1949: external data source errorER_GTID_STRICT_OUT_OF_ORDER / 1950: external data source errorER_GTID_START_FROM_BINLOG_HOLE / 1951: external data source errorER_SLAVE_UNEXPECTED_MASTER_SWITCH / 1952: external data source errorER_GTID_POSITION_NOT_FOUND_IN_BINLOG2 / 1955: external data source errorER_BINLOG_MUST_BE_EMPTY / 1956: external data source errorER_CHANGE_SLAVE_PARALLEL_THREADS_ACTIVE / 1963: external data source errorER_SLAVE_SKIP_NOT_IN_GTID / 1966: external data source errorCR_PROBE_REPLICA_STATUS / 2022: external data source error when the driver provides this symbolCR_PROBE_REPLICA_HOSTS / 2023: external data source error when the driver provides this symbolER_ERROR_ON_MASTER / 3001: external data source errorER_INCONSISTENT_ERROR / 3002: external data source errorER_BINLOG_UNSAFE_FULLTEXT_PLUGIN / 3006: external data source errorER_SLAVE_SQL_THREAD_MUST_STOP / 3017: external data source errorER_SLAVE_CHANNEL_IO_THREAD_MUST_STOP / 3021: external data source errorER_WARN_OPEN_TEMP_TABLES_MUST_BE_ZERO / 3022: external data source errorER_WARN_ONLY_MASTER_LOG_FILE_NO_POS / 3023: external data source errorER_SLAVE_WORKER_STOPPED_PREVIOUS_THD_ERROR / 3030: external data source errorER_DONT_SUPPORT_SLAVE_PRESERVE_COMMIT_ORDER / 3031: external data source errorER_BINLOG_NON_SUPPORTED_BULK / 4033: external data source errorER_SLAVE_SAME_ID / 4052: external data source errorER_REQUIRE_ROW_BINLOG_FORMAT / 4056: external data source errorER_RDB_STATUS_GENERAL / 4067: external data source errorER_RDB_STATUS_MSG / 4068: external data source errorER_KEY_CREATE_DURING_ALTER / 4072: external data source errorER_SK_POPULATE_DURING_ALTER / 4073: external data source errorER_SEQUENCE_BINLOG_FORMAT / 4088: external data source errorER_SLAVE_IGNORED_SHARED_TABLE / 4168: external data source errorER_BINLOG_UNSAFE_SKIP_LOCKED / 4175: external data source errorER_INCONSISTENT_SLAVE_TEMP_TABLE / 4188: external data source errorER_VERS_HIST_PART_FAILED / 4189: external data source errorER_INIT_SLAVE_ERROR / 4226: external data source errorER_* / MY-* replica, source, slave, master, GTID, RPL, binlog, or group replication fallback: external data source error |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Features | SQL_FEATURE_NOT_SUPPORTED |
ER_UNSUPPORTED_EXTENSION / 1112: feature not supportedER_UNKNOWN_CHARACTER_SET / 1115: feature not supportedER_NOT_ALLOWED_COMMAND / 1148: feature not supportedER_TABLE_CANT_HANDLE_BLOB / 1163: feature not supportedER_TABLE_CANT_HANDLE_AUTO_INCREMENT / 1164: feature not supportedER_CHECK_NOT_IMPLEMENTED / 1178: feature not supportedER_NOT_SUPPORTED_YET / 1235: feature not supportedER_SP_BADSELECT / 1312: feature not supportedER_SP_BADSTATEMENT / 1314: feature not supportedER_SP_SUBSELECT_NYI / 1335: feature not supportedER_STMT_NOT_ALLOWED_IN_SF_OR_TRG / 1336: feature not supportedER_SP_NO_RETSET / 1415: feature not supportedER_SP_NO_AGGREGATE / 1460: feature not supportedER_ALTER_OPERATION_NOT_SUPPORTED / 1845: feature not supportedER_ALTER_OPERATION_NOT_SUPPORTED_REASON / 1846: feature not supportedER_UNSUPPORTED_ACTION_ON_GENERATED_COLUMN / 1907: feature not supportedER_UNSUPPORTED_ENGINE_FOR_GENERATED_COLUMNS / 1910: feature not supportedER_QUERY_CACHE_IS_GLOBALY_DISABLED / 1925: feature not supportedER_SUBQUERIES_NOT_SUPPORTED / 1970: feature not supportedER_SET_STATEMENT_NOT_SUPPORTED / 1971: feature not supportedER_WARN_LEGACY_SYNTAX_CONVERTED / 3005: feature not supportedER_EXPLAIN_NOT_SUPPORTED / 3012: feature not supportedER_ALTER_OPERATION_NOT_SUPPORTED_REASON_GIS / 3060: feature not supportedER_FRAME_EXCLUSION_NOT_SUPPORTED / 4022: feature not supportedER_FLASHBACK_NOT_SUPPORTED / 4053: feature not supportedER_ISOLATION_MODE_NOT_SUPPORTED / 4057: feature not supportedER_UNSUPPORTED_COLLATION / 4063: feature not supportedER_RDB_TTL_UNSUPPORTED / 4069: feature not supportedER_VERS_ENGINE_UNSUPPORTED / 4111: feature not supportedER_VERS_ALTER_ENGINE_PROHIBITED / 4120: feature not supportedER_VERS_DB_NOT_SUPPORTED / 4132: feature not supportedER_VERS_NOT_SUPPORTED / 4137: feature not supportedER_VERS_TRX_PART_HISTORIC_ROW_NOT_SUPPORTED / 4138: feature not supportedER_GALERA_REPLICATION_NOT_SUPPORTED / 4165: feature not supportedER_PARTITION_CONVERT_SUBPARTITIONED / 4184: feature not supportedER_JSON_SCHEMA_KEYWORD_UNSUPPORTED / 4194: feature not supportedER_JSON_NO_VARIABLE_SCHEMA / 4195: feature not supportedER_HINTS_INSIDE_VIEWS_NOT_SUPPORTED / 4223: feature not supportedER_WARN_HINTS_ON_INSERT_PART_OF_INSERT_SELECT / 4225: feature not supported |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Corruption | SQL_DATABASE_CORRUPTEDcorruptionType database file |
ER_NOT_FORM_FILE / 1033: database file corruptionER_CRASHED_ON_USAGE / 1194: database file corruptionER_CRASHED_ON_REPAIR / 1195: database file corruptionER_CORRUPT_HELP_DB / 1244: database file corruption |
corruptionTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Corruption | SQL_DATABASE_CORRUPTEDcorruptionType index |
ER_NOT_KEYFILE / 1034: index corruptionER_OLD_KEYFILE / 1035: index corruptionER_INDEX_CORRUPT / 1712: index corruption |
corruptionTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Corruption | SQL_DATABASE_CORRUPTEDcorruptionType sequence |
ER_SEQUENCE_INVALID_DATA / 4085: sequence corruptionER_SEQUENCE_INVALID_TABLE_STRUCTURE / 4086: sequence corruption |
corruptionTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Corruption | SQL_DATABASE_CORRUPTEDcorruptionType virtual table |
- | - |
| Corruption | SQL_DATABASE_CORRUPTEDcorruptionType filesystem |
- | - |
| Corruption | SQL_DATABASE_CORRUPTEDcorruptionType checksum |
ER_TOO_BIG_FOR_UNCOMPRESS / 1256: checksum corruptionER_ZLIB_Z_DATA_ERROR / 1259: checksum corruptionER_FILE_CORRUPT / 3000: checksum corruptionER_METADATA_INCONSISTENCY / 4064: checksum corruption |
corruptionTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Internal | SQL_INTERNAL_ERRORerrorType engine internal |
ER_UNUSED_17 / 1101: engine internalER_UNACCEPTABLE_MUTUAL_RECURSION / 4006: engine internalER_JSON_DEPTH / 4040: engine internalER_JSON_PATH_DEPTH / 4043: engine internalER_UNSUPPORT_COMPRESSED_TEMPORARY_TABLE / 4047: engine internalER_ROLLBACK_TO_SAVEPOINT / 4061: engine internalER_ISOLATION_LEVEL_WITH_CONSISTENT_SNAPSHOT / 4062: engine internalER_ROW_VARIABLE_DOES_NOT_HAVE_FIELD / 4082: engine internalER_UNKNOWN_VIEW / 4092: engine internalER_PACKAGE_ROUTINE_IN_SPEC_NOT_DEFINED_IN_BODY / 4095: engine internalER_PACKAGE_ROUTINE_FORWARD_DECLARATION_NOT_DEFINED / 4096: engine internalER_COMPRESSED_COLUMN_USED_AS_KEY / 4097: engine internalER_CONFLICTING_FOR_SYSTEM_TIME / 4122: engine internalER_VERS_NO_TRX_ID / 4129: engine internalER_VERS_TRT_IS_DISABLED / 4133: engine internalER_EMPTY_ROW_IN_TVC / 4141: engine internalER_VERS_QUERY_IN_PARTITION / 4142: engine internalER_KEY_DOESNT_SUPPORT / 4143: engine internalER_PERIOD_CONSTRAINT_DROP / 4158: engine internalEE_* / error numbers 1-999 fallback: engine internalER_* / MY-* warning, note, or info fallback: engine internal |
errorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Internal | SQL_INTERNAL_ERRORerrorType api misuse |
CR_INVALID_BUFFER_USE / 2035: api misuseCR_* / error numbers 2001-2999 fallback: api misuse |
errorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Fallback | SQL_UNKNOWN |
unmapped explicit driver code or numeric error with no active-database symbol: unknown | databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |