MySQL Error Mapping¶
This page lists how native MySQL database or driver errors are represented as TsSqlErrorReason values. The table uses the same row catalog and row order as the other native database pages, so a - means this semantic case is not currently mapped for MySQL.
Database error shows the values exposed through databaseErrorCode and databaseErrorNumber when both are available. Connector-only signals include the connector inline. SQL_UNKNOWN is intentionally the last row.
Semantically classified mapper-known codes are listed individually. Broad SQLSTATE, registry, range, or message-pattern fallbacks are summarized when the mapper intentionally handles an open-ended family of errors; if the same native code appears in more than one row, the driver message determines the final mapped reason.
| Category | Reason | Database error | Filled fields |
|---|---|---|---|
| Constraints | SQL_CONSTRAINT_VIOLATEDconstraintType unique |
ER_DUP_KEY / 1022: unique constraint violationER_DUP_ENTRY / 1062: unique constraint violationER_DUP_UNIQUE / 1169: unique constraint violationER_FOREIGN_DUPLICATE_KEY_OLD_UNUSED / 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_INTERSECT_ALL_MAX_DUPLICATES_EXCEEDED / 4120: 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 violationER_BAD_NULL_ERROR_NOT_IGNORED / 3673: 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 violationER_USER_REFERENCED_AS_DEFINER / 4005: foreign key constraint violationER_CANNOT_USER_REFERENCED_AS_DEFINER / 4006: foreign key constraint violation |
constraintTypeconstraintName when inferredtableName when inferredcolumnName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Constraints | SQL_CONSTRAINT_VIOLATEDconstraintType check |
ER_CHECK_CONSTRAINT_VIOLATED / 3819: 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_SOURCE_PASSWORD_LENGTH / 3056: too longER_JSON_VALUE_TOO_BIG / 3150: too longER_JSON_KEY_TOO_BIG / 3151: too longER_SRS_ATTRIBUTE_STRING_TOO_LONG / 3718: too longER_FUNCTIONAL_INDEX_DATA_IS_TOO_LONG / 3907: too longER_CANT_SET_PERSISTED / 4159: 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_NUMERIC_JSON_VALUE_OUT_OF_RANGE / 3155: out of rangeER_JT_VALUE_OUT_OF_RANGE / 3669: out of rangeER_NONPOSITIVE_RADIUS / 3706: out of rangeER_SRS_INVALID_SEMI_MAJOR_AXIS / 3737: out of rangeER_SRS_INVALID_INVERSE_FLATTENING / 3738: out of rangeER_SRS_INVALID_ANGULAR_UNIT / 3739: out of rangeER_SRS_INVALID_PRIME_MERIDIAN / 3740: out of rangeER_INNODB_AUTOEXTEND_SIZE_OUT_OF_RANGE / 4025: out of rangeER_SRS_INVALID_LATITUDE_OF_ORIGIN / 4105: out of rangeER_SRS_INVALID_LONGITUDE_OF_ORIGIN / 4106: out of rangeER_SRS_INVALID_HEIGHT / 4124: out of rangeER_SRS_INVALID_SCALING / 4125: out of rangeER_SRS_INVALID_ZONE_WIDTH / 4126: out of rangeER_SRS_INVALID_LATITUDE_POLAR_STERE_VAR_A / 4127: 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 valueCR_DATA_TRUNCATED / 2032: invalid value |
errorTypetableName when inferredcolumnName when inferredtypeName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Values | SQL_INVALID_VALUEerrorType invalid format |
- | - |
| Values | SQL_INVALID_VALUEerrorType invalid encoding |
- | - |
| Values | SQL_INVALID_VALUEerrorType invalid json |
ER_INVALID_JSON_TEXT / 3140: invalid jsonER_INVALID_JSON_TEXT_IN_PARAM / 3141: invalid jsonER_INVALID_JSON_CHARSET / 3144: invalid jsonER_INVALID_JSON_CHARSET_IN_FUNCTION / 3145: invalid jsonER_INVALID_TYPE_FOR_JSON / 3146: invalid jsonER_INVALID_CAST_TO_JSON / 3147: invalid jsonER_INVALID_JSON_VALUE_FOR_CAST / 3156: invalid jsonER_JSON_DOCUMENT_TOO_DEEP / 3157: invalid jsonER_JSON_DOCUMENT_NULL_KEY / 3158: invalid jsonER_INVALID_JSON_TYPE / 3853: invalid jsonER_INVALID_JSON_VALUE_FOR_FUNC_INDEX / 3903: invalid jsonER_MISSING_JSON_VALUE / 3966: invalid jsonER_MULTIPLE_JSON_VALUES / 3967: invalid jsonER_WARN_AUDIT_LOG_FORMAT_UNIX_TIMESTAMP_ONLY_WHEN_JSON / 4051: 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 |
- | - |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType missing |
ER_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 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 argumentsERR_MYSQL_WRONG_NUMBER_OF_PARAMETERS_PROVIDED (Bun SQL): wrong count parameter |
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_INVALID_BUFFER_USE / 2035: invalid type parameter when the message reports an unsupported buffer 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_REPLICA_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 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_INVALID_BUFFER_USE / 2035: 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 messageCR_DUPLICATE_CONNECTION_ATTR / 2060: invalid value parameterCR_INVALID_FACTOR_NO / 2072: invalid value parameter |
parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType invalid binding |
ERR_MYSQL_INVALID_QUERY_BINDING (Bun SQL): invalid binding parameterERR_MYSQL_NOT_TAGGED_CALL (Bun SQL): invalid binding parameter |
parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Parameters | SQL_INVALID_PARAMETERparameterErrorType not bindable |
Bun SQL simple query parameter message: not bindable parameter | parameterErrorTypeparameterName when inferredparameterIndex when inferredexpectedParameterCount when inferredactualParameterCount when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| 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 foundER_NO_SUCH_DB / 3503: 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 |
- | - |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType collation |
EE_UNKNOWN_COLLATION / 28: collation not found |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| 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 found |
objectTypeschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Object not found | SQL_OBJECT_NOT_FOUNDobjectType trigger |
- | - |
| 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 |
- | - |
| Object not found | SQL_OBJECT_NOT_FOUND |
ER_SRS_NOT_FOUND / 3548: object not foundER_UNIT_NOT_FOUND / 3902: 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_SRS_ID_ALREADY_EXISTS / 3712: 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 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 |
- | - |
| Object state | SQL_OBJECT_STATE_ERRORobjectStateErrorType object in use |
- | - |
| Object state | SQL_OBJECT_STATE_ERRORobjectStateErrorType dependent objects still exist |
ER_CANT_MODIFY_SRS_USED_BY_COLUMN / 3716: dependent objects still exist |
objectStateErrorTypeobjectType when inferredschemaName when inferredtableName when inferredcolumnName when inferredobjectName when inferreddatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Statement | SQL_SYNTAX_ERROR |
ER_PARSE_ERROR / 1064: syntax errorER_SYNTAX_ERROR / 1149: syntax errorER_DA_NO_ERROR_LOG_PARSER_CONFIGURED / 4001: syntax errorER_BULK_PARSER_MISSING_ENCLOSED_BY / 4143: syntax errorER_BULK_PARSER_ROW_BUFFER_MAX_TOTAL_COLS_EXCEEDED / 4144: syntax errorER_BULK_PARSER_UNEXPECTED_CHAR_AFTER_COLUMN_TERMINATOR / 4150: syntax errorER_BULK_PARSER_INCOMPLETE_ESCAPE_SEQUENCE / 4151: 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 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_BLOB_CANT_HAVE_DEFAULT / 1101: 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_CANNOT_DISCARD_TEMPORARY_TABLE / 3007: invalid definitionER_MISSING_HA_CREATE_OPTION / 3014: invalid definitionER_NO_FT_MATERIALIZED_SUBQUERY / 3018: invalid definitionER_TABLE_NO_PRIMARY_KEY / 4130: invalid definitionER_REQUIRE_TABLE_PRIMARY_KEY_CHECK_GENERATE_WITH_GR / 4155: 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_GET_STACKED_DA_WITHOUT_ACTIVE_HANDLER / 3004: invalid statement contextER_PASSWORD_EXPIRE_ANONYMOUS_USER / 3016: invalid statement contextER_COMMAND_SERVICE_BACKEND_FAILED / 4116: 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_ALTER_OPERATION_NOT_SUPPORTED_REASON_COLUMN_TYPE_INSTANT / 4083: 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_TABLE_NOT_EMPTY / 4129: 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_AGGREGATE_ORDER_FOR_UNION / 3028: invalid groupingER_AGGREGATE_ORDER_NON_AGG_QUERY / 3029: 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_UNUSED / 1120: invalid SQL statementER_CANT_CHANGE_TX_CHARACTERISTICS / 1568: invalid SQL statementER_CANT_USE_SAME_UUID_AS_GROUP_NAME / 4021: invalid SQL statementER_INNODB_INVALID_AUTOEXTEND_SIZE_VALUE / 4023: invalid SQL statementER_INVALID_CAST_TO_GEOMETRY / 4032: invalid SQL statementER_SDI_GET_KEYS_INVALID_TABLESPACE / 4036: invalid SQL statementER_CANT_USE_SAME_UUID_AS_VIEW_CHANGE_UUID / 4039: invalid SQL statementER_INVALID_ASSIGNMENT_TARGET / 4048: invalid SQL statementER_INVALID_USER_FOR_REGISTRATION / 4060: invalid SQL statementER_MFA_METHODS_INVALID_ORDER / 4062: invalid SQL statementER_INVALID_MFA_OPERATIONS_FOR_PASSWORDLESS_USER / 4064: invalid SQL statementER_DEFINITION_CONTAINS_INVALID_STRING / 4089: invalid SQL statementER_BAD_TIMESTAMP_FORMAT / 4122: invalid SQL statementER_CANT_RUN_COMMAND_SERVICES_RECURSIVELY / 4167: 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_ZERO / 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 violation |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Execution | SQL_ROUTINE_ERROR |
- | - |
| Transactions | TRANSACTION_ERRORtransactionErrorType invalid state |
ERR_MYSQL_INVALID_TRANSACTION_STATE (Bun SQL): invalid state |
transactionErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Transactions | TRANSACTION_ERRORtransactionErrorType aborted |
- | - |
| Transactions | TRANSACTION_ERRORtransactionErrorType active transaction |
ER_CANT_DO_THIS_DURING_AN_TRANSACTION / 1179: 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_TRANSACTION_ROLLBACK_DURING_COMMIT / 3101: transaction rolled back |
transactionErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Transactions | TRANSACTION_ERRORtransactionErrorType outcome unknown |
- | - |
| Transactions | TRANSACTION_ERRORtransactionErrorType invalid savepoint |
- | - |
| Transactions | TRANSACTION_ERRORtransactionErrorType unsupported operation |
ERR_MYSQL_UNSAFE_TRANSACTION (Bun SQL): unsupported operation |
transactionErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| 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 timeoutER_STOP_REPLICA_MONITOR_IO_THREAD_TIMEOUT / 4011: connection timeoutPROTOCOL_SEQUENCE_TIMEOUT (mysql2): connection timeoutETIMEDOUT (mysql2): connection timeoutESOCKETTIMEDOUT (mysql2): 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 |
- | - |
| Timeouts | SQL_TIMEOUTtimeoutType transaction |
- | - |
| Timeouts | SQL_TIMEOUTtimeoutType idle transaction |
- | - |
| Timeouts | SQL_TIMEOUTtimeoutType cancelled |
ER_QUERY_INTERRUPTED / 1317: cancelled timeoutERR_MYSQL_QUERY_CANCELLED (Bun SQL): 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_SOURCE_NET_READ / 1189: connection lostER_SOURCE_NET_WRITE / 1190: connection lostER_CONNECT_TO_SOURCE / 1218: connection lostCR_SOCKET_CREATE_ERROR / 2001: connection lostCR_CONNECTION_ERROR / 2002: connection lostCR_CONN_HOST_ERROR / 2003: connection lostCR_IPSOCK_ERROR / 2004: connection lostCR_SERVER_GONE_ERROR / 2006: connection lostCR_VERSION_ERROR / 2007: connection lostCR_WRONG_HOST_INFO / 2009: connection lostCR_SERVER_HANDSHAKE_ERR / 2012: connection lostCR_SERVER_LOST / 2013: connection lostCR_NAMEDPIPEWAIT_ERROR / 2016: connection lostCR_NAMEDPIPEOPEN_ERROR / 2017: connection lostCR_NAMEDPIPESETSTATE_ERROR / 2018: connection lostCR_PROBE_REPLICA_CONNECT / 2024: connection lostCR_PROBE_SOURCE_CONNECT / 2025: connection lostCR_MALFORMED_PACKET / 2027: connection lostCR_SHARED_MEMORY_CONNECT_REQUEST_ERROR / 2038: connection lostCR_SHARED_MEMORY_CONNECT_ANSWER_ERROR / 2039: connection lostCR_SHARED_MEMORY_CONNECT_FILE_MAP_ERROR / 2040: connection lostCR_SHARED_MEMORY_CONNECT_MAP_ERROR / 2041: connection lostCR_SHARED_MEMORY_FILE_MAP_ERROR / 2042: connection lostCR_SHARED_MEMORY_MAP_ERROR / 2043: connection lostCR_SHARED_MEMORY_EVENT_ERROR / 2044: connection lostCR_SHARED_MEMORY_CONNECT_ABANDONED_ERROR / 2045: connection lostCR_SHARED_MEMORY_CONNECT_SET_ERROR / 2046: connection lostCR_CONN_UNKNOW_PROTOCOL / 2047: connection lostCR_SERVER_LOST_EXTENDED / 2055: connection lostPROTOCOL_CONNECTION_LOST (mysql2): connection lostERR_MYSQL_CONNECTION_CLOSED (Bun SQL): connection lostECONNRESET (mysql2): connection lostEPIPE (mysql2): connection lostECONNREFUSED (mysql2): connection lostENOTFOUND (mysql2): connection lostEAI_AGAIN (mysql2): connection lostEHOSTUNREACH (mysql2): connection lostENETUNREACH (mysql2): 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 unavailablePOOL_NONEONLINE (mysql2): temporarily unavailable |
errorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Connections | SQL_CONNECTION_ERRORerrorType invalid connection configuration |
ER_BAD_HOST_ERROR / 1042: invalid connection configurationCR_UNKNOWN_HOST / 2005: invalid connection configurationCR_SSL_CONNECTION_ERROR / 2026: invalid connection configurationCR_SSL_FIPS_MODE_ERR / 2064: invalid connection configurationCR_COMPRESSION_WRONGLY_CONFIGURED / 2066: invalid connection configurationCR_DNS_SRV_LOOKUP_FAILED / 2070: invalid connection configurationCR_TLS_SERVER_NOT_FOUND / 2075: invalid connection configuration |
errorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Connections | SQL_CONNECTION_ERRORerrorType pool error |
POOL_NOEXIST (mysql2): pool error |
errorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType memory |
EE_OUTOFMEMORY / 5: memory resource limitEE_CAPACITY_EXCEEDED / 34: memory resource limitER_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 limitCR_OUT_OF_MEMORY / 2008: 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 |
EE_DISK_FULL / 20: disk resource limitEE_DISK_FULL_WITH_RETRY_MSG / 35: disk resource limitER_RECORD_FILE_FULL / 1114: disk resource limitER_TRANS_CACHE_FULL / 1197: disk resource limitER_INNODB_UNDO_LOG_FULL / 3019: 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 |
- | - |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType cpu |
- | - |
| Resources | SQL_RESOURCE_LIMIT_REACHEDresourceType file size |
- | - |
| Resources | SQL_RESOURCE_LIMIT_REACHED |
EE_OUT_OF_FILERESOURCES / 23: resource limit reachedER_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 reachedCR_NET_PACKET_TOO_LARGE / 2020: 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 errorCR_UNUSED_1 / 2049: authentication errorCR_AUTH_PLUGIN_CANNOT_LOAD / 2059: authentication errorCR_AUTH_PLUGIN_ERR / 2061: authentication errorCR_KERBEROS_USER_NOT_FOUND / 2067: authentication errorER_AUTHENTICATION_POLICY_MISMATCH / 4058: 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 deniedCR_LOAD_DATA_LOCAL_INFILE_REJECTED / 2068: permission deniedER_REPLACE_INACCESSIBLE_ROWS / 3059: 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 violationER_CANT_CHANGE_SYS_VAR_IN_READ_ONLY_MODE / 4156: 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 |
EE_UNKNOWN_CHARSET / 22: runtime parameter configuration errorEE_FAILED_TO_OPEN_DEFAULTS_FILE / 47: runtime parameter configuration errorEE_FAILED_TO_HANDLE_DEFAULTS_FILE / 48: runtime parameter configuration errorEE_WRONG_DIRECTIVE_IN_CONFIG_FILE / 49: runtime parameter configuration errorEE_INCORRECT_GRP_DEFINITION_IN_CONFIG_FILE / 51: runtime parameter configuration errorEE_OPTION_WITHOUT_GRP_IN_CONFIG_FILE / 52: runtime parameter configuration errorEE_CONFIG_FILE_PERMISSION_ERROR / 53: runtime parameter configuration errorEE_IGNORE_WORLD_WRITABLE_CONFIG_FILE / 54: runtime parameter configuration errorEE_SSL_ERROR_FROM_FILE / 59: runtime parameter configuration errorEE_SSL_ERROR / 60: runtime parameter configuration errorEE_UNKNOWN_PROTOCOL_OPTION / 63: runtime parameter configuration errorEE_FAILED_TO_LOCATE_SERVER_PUBLIC_KEY / 64: runtime parameter configuration errorEE_PUBLIC_KEY_NOT_IN_PEM_FORMAT / 65: runtime parameter configuration errorEE_UNKNOWN_VARIABLE / 67: runtime parameter configuration errorEE_UNKNOWN_OPTION / 68: runtime parameter configuration errorEE_UNKNOWN_SHORT_OPTION / 69: runtime parameter configuration errorEE_OPTION_WITHOUT_ARGUMENT / 70: runtime parameter configuration errorEE_OPTION_REQUIRES_ARGUMENT / 71: runtime parameter configuration errorEE_SHORT_OPTION_REQUIRES_ARGUMENT / 72: runtime parameter configuration errorEE_OPTION_IGNORED_DUE_TO_INVALID_VALUE / 73: runtime parameter configuration errorEE_OPTION_WITH_EMPTY_VALUE / 74: runtime parameter configuration errorEE_FAILED_TO_ASSIGN_MAX_VALUE_TO_OPTION / 75: runtime parameter configuration errorEE_INCORRECT_BOOLEAN_VALUE_FOR_OPTION / 76: runtime parameter configuration errorEE_FAILED_TO_SET_OPTION_VALUE / 77: runtime parameter configuration errorEE_INCORRECT_INT_VALUE_FOR_OPTION / 78: runtime parameter configuration errorEE_INCORRECT_UINT_VALUE_FOR_OPTION / 79: runtime parameter configuration errorEE_INVALID_DECIMAL_VALUE_FOR_OPTION / 84: runtime parameter configuration errorER_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 errorCR_CANT_READ_CHARSET / 2019: runtime parameter configuration errorCR_WRONG_LICENSE / 2028: runtime parameter configuration errorCR_INVALID_CLIENT_CHARSET / 2074: 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_CHANGE_REPLICATION_SOURCE_NO_OPTIONS_FOR_GTID_ONLY / 4065: runtime parameter configuration error |
configurationErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType read |
EE_READ / 2: read I/O errorEE_EOFERR / 9: read I/O errorEE_DIR / 12: read I/O errorEE_CANT_READLINK / 24: read I/O errorER_CANT_READ_DIR / 1018: read I/O errorER_ERROR_ON_READ / 1024: read I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType write |
EE_CANTCREATEFILE / 1: write I/O errorEE_WRITE / 3: write I/O errorEE_CANT_MKDIR / 21: write I/O errorEE_CANT_SYMLINK / 25: write I/O errorER_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 |
EE_SYNC / 27: fsync I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType truncate |
- | - |
| I/O | SQL_IO_ERRORioErrorType file stat |
EE_STAT / 13: file stat I/O errorER_CANT_GET_STAT / 1013: file stat I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType lock |
EE_CANTLOCK / 10: lock I/O errorER_CANT_LOCK / 1015: lock I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType unlock |
EE_CANTUNLOCK / 11: unlock I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType delete |
EE_DELETE / 6: delete I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType file not found |
EE_FILENOTFOUND / 29: file not found I/O errorER_FILE_NOT_FOUND / 1017: file not found I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType access |
EE_CHANGE_OWNERSHIP / 31: access I/O errorEE_CHANGE_PERMISSIONS / 32: access I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType shared memory |
- | - |
| I/O | SQL_IO_ERRORioErrorType seek |
EE_CANT_SEEK / 33: seek I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType mmap |
- | - |
| I/O | SQL_IO_ERRORioErrorType path |
EE_LINK / 7: path I/O errorEE_CANT_CHSIZE / 14: path I/O errorEE_CANT_OPEN_STREAM / 15: path I/O errorEE_GETWD / 16: path I/O errorEE_SETWD / 17: path I/O errorEE_REALPATH / 26: path I/O errorER_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 errorCR_FILE_NAME_TOO_LONG / 2063: path I/O errorCR_LOAD_DATA_LOCAL_INFILE_REALPATH_FAIL / 2069: path I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType atomic write |
- | - |
| I/O | SQL_IO_ERRORioErrorType close |
EE_BADCLOSE / 4: close I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| I/O | SQL_IO_ERRORioErrorType reserved extension |
- | - |
| I/O | SQL_IO_ERRORioErrorType unknown |
ER_INVALID_CAST_POLYGON_RING_DIRECTION / 4033: unknown I/O errorER_BULK_LOADER_FILE_CONTAINS_LESS_LINES_THAN_IGNORE_CLAUSE / 4142: unknown I/O errorER_* / MY-* file, directory, read, write, or open fallback: unknown I/O error |
ioErrorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| External | SQL_EXTERNAL_DATA_SOURCE_ERROR |
CR_PROBE_REPLICA_STATUS / 2022: external data source errorCR_PROBE_REPLICA_HOSTS / 2023: external data source errorER_DONT_SUPPORT_REPLICA_PRESERVE_COMMIT_ORDER / 3031: external data source errorER_STARTING_REPLICA_MONITOR_IO_THREAD / 4012: external data source errorER_CANT_USE_ANONYMOUS_TO_GTID_WITH_GTID_MODE_NOT_ON / 4013: external data source errorER_CANT_COMBINE_ANONYMOUS_TO_GTID_AND_AUTOPOSITION / 4014: external data source errorER_ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_REQUIRES_GTID_MODE_ON / 4015: external data source errorER_SQL_REPLICA_SKIP_COUNTER_USED_WITH_GTID_MODE_ON / 4016: external data source errorER_USING_ASSIGN_GTIDS_TO_ANONYMOUS_TRANSACTIONS_AS_LOCAL_OR_UUID / 4017: external data source errorER_CANT_SET_SQL_AFTER_OR_BEFORE_GTIDS_WITH_ANONYMOUS_TO_GTID / 4019: external data source errorER_ANONYMOUS_TO_GTID_UUID_SAME_AS_GROUP_NAME / 4020: external data source errorER_GRP_RPL_RECOVERY_CHANNEL_STILL_RUNNING / 4022: external data source errorER_CHANGE_RPL_SRC_WRONG_COMPRESSION_ALGORITHM_SIZE / 4037: external data source errorER_ANONYMOUS_TO_GTID_UUID_SAME_AS_VIEW_CHANGE_UUID / 4040: external data source errorER_GRP_RPL_VIEW_CHANGE_UUID_FAIL_GET_VARIABLE / 4041: external data source errorER_GRP_RPL_FAILOVER_CHANNEL_STATUS_PROPAGATION / 4050: external data source errorER_CHANGE_REP_SOURCE_CANT_DISABLE_AUTO_POS_WITHOUT_POSITIONS / 4069: external data source errorER_REGEXP_MISSING_RESOURCE / 4076: external data source errorER_CANT_EXECUTE_COMMAND_WITH_ASSIGNED_GTID_NEXT / 4090: 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 supportedCR_NOT_IMPLEMENTED / 2054: feature not supportedCR_DEPRECATED_COMPRESSION_NOT_SUPPORTED / 2065: 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_IDENTIFIED_BY_UNSUPPORTED / 4053: feature not supportedER_INNODB_INSTANT_ADD_DROP_NOT_SUPPORTED_MAX_SIZE / 4157: feature not supportedER_INNODB_INSTANT_ADD_NOT_SUPPORTED_MAX_FIELDS / 4158: 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 |
- | - |
| 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 corruption |
corruptionTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Internal | SQL_INTERNAL_ERRORerrorType engine internal |
ER_WARN_HYPERGRAPH_EXPERIMENTAL / 4000: engine internalER_DA_ERROR_LOG_MULTIPLE_FILTERS / 4003: engine internalER_REGEX_NUMBER_TOO_BIG / 4007: engine internalER_SPVAR_NONINTEGER_TYPE / 4008: engine internalWARN_UNSUPPORTED_ACL_TABLES_READ / 4009: engine internalER_INNODB_INCOMPATIBLE_WITH_TABLESPACE / 4024: engine internalER_CANNOT_USE_AUTOEXTEND_SIZE_CLAUSE / 4026: engine internalER_INNODB_COMPRESSION_FAILURE / 4029: engine internalER_WARN_ASYNC_CONN_FAILOVER_NETWORK_NAMESPACE / 4030: engine internalER_RELOAD_KEYRING_FAILURE / 4035: engine internalER_WARN_ADUIT_LOG_MAX_SIZE_AND_PRUNE_SECONDS / 4042: engine internalER_WARN_ADUIT_LOG_MAX_SIZE_CLOSE_TO_ROTATE_ON_SIZE / 4043: engine internalER_KERBEROS_CREATE_USER / 4044: engine internalER_INSTALL_PLUGIN_CONFLICT_CLIENT / 4045: engine internalER_DA_ERROR_LOG_COMPONENT_FLUSH_FAILED / 4046: engine internalER_WARN_SQL_AFTER_MTS_GAPS_GAP_NOT_CALCULATED / 4047: engine internalER_OPERATION_NOT_ALLOWED_ON_GR_SECONDARY / 4049: engine internalER_MFA_METHOD_NOT_EXISTS / 4057: engine internalER_PLUGIN_REGISTRATION_DONE / 4059: engine internalER_USER_REGISTRATION_FAILED / 4061: engine internalER_MFA_METHODS_IDENTICAL / 4063: engine internalER_VALUE_OUT_OF_RANGE / 4074: engine internalER_FULLTEXT_WITH_ROLLUP / 4075: engine internalER_WARN_REGEXP_USING_DEFAULT / 4077: engine internalER_CONCURRENT_PROCEDURE_USAGE / 4080: engine internalER_DA_GLOBAL_CONN_LIMIT / 4081: engine internalER_DA_CONN_LIMIT / 4082: engine internalER_INNODB_MAX_ROW_VERSION / 4092: engine internalER_WARN_DEPRECATED_DATETIME_DELIMITER / 4095: engine internalER_WARN_DEPRECATED_SUPERFLUOUS_DELIMITER / 4096: engine internalER_CANNOT_PERSIST_SENSITIVE_VARIABLES / 4097: engine internalER_IF_NOT_EXISTS_UNSUPPORTED_TRG_EXISTS_ON_DIFFERENT_TABLE / 4100: engine internalER_GIPK_COLUMN_EXISTS / 4108: engine internalER_GIPK_COLUMN_ALTER_NOT_ALLOWED / 4110: engine internalER_DROP_PK_COLUMN_TO_DROP_GIPK / 4111: engine internalER_WARN_DEPRECATED_IDENT / 4119: engine internalER_TP_QUERY_THRS_PER_GRP_EXCEEDS_TXN_THR_LIMIT / 4121: engine internalER_SHAPE_PRIDICTION_UDF / 4123: engine internalER_WARN_DEPRECATED_CLIENT_NO_SCHEMA_OPTION / 4128: engine internalER_TABLE_IN_SHARED_TABLESPACE / 4131: engine internalER_INDEX_OTHER_THAN_PK / 4132: engine internalER_LOAD_BULK_DATA_UNSORTED / 4133: engine internalER_BULK_READER_SERVER_ERROR / 4137: engine internalER_BULK_READER_COMMUNICATION_ERROR / 4138: engine internalER_BULK_LOAD_DATA_FAILED / 4139: engine internalER_BULK_LOADER_COLUMN_TOO_BIG_FOR_LEFTOVER_BUFFER / 4140: engine internalER_BULK_LOADER_COMPONENT_ERROR / 4141: engine internalER_LOAD_BULK_DATA_FAILED / 4152: engine internalER_LOAD_BULK_DATA_WARN_NULL_TO_NOTNULL / 4154: engine internalER_INSTALL_COMPONENT_SET_NULL_VALUE / 4160: engine internalER_VALIDATE_PASSWORD_INSUFFICIENT_CHANGED_CHARACTERS / 4165: engine internalER_WARN_DEPRECATED_WITH_NOTE / 4166: 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_COMMANDS_OUT_OF_SYNC / 2014: api misuseCR_NULL_POINTER / 2029: api misuseCR_NO_PREPARE_STMT / 2030: api misuseCR_INVALID_CONN_HANDLE / 2048: api misuseCR_FETCH_CANCELED / 2050: api misuseCR_NO_DATA / 2051: api misuseCR_NO_STMT_METADATA / 2052: api misuseCR_NO_RESULT_SET / 2053: api misuseCR_STMT_CLOSED / 2056: api misuseCR_NEW_STMT_METADATA / 2057: api misuseCR_ALREADY_CONNECTED / 2058: api misuseCR_INSECURE_API_ERR / 2062: api misuseCR_MANDATORY_TRACKER_NOT_FOUND / 2071: api misuseCR_CANT_GET_SESSION_DATA / 2073: api misusemysql2 and Bun SQL API misuse messages: api misuse CR_* / error numbers 2001-2999 fallback: api misuse |
errorTypedatabaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |
| Fallback | SQL_UNKNOWN |
CR_UNKNOWN_ERROR / 2000: unknownERR_MYSQL_UNKNOWN_ERROR (Bun SQL): unknown SQL errorunmapped explicit driver code or numeric error with no active-database symbol: unknown |
databaseErrorCode when availabledatabaseErrorNumber when availabledatabaseErrorMessage |