Skip to main content

Error Codes

This document describes error codes you may encounter when operating CloudBase MySQL Database and their solutions.

Business Error Codes

Business error codes identify business logic errors that occur when the CloudBase platform processes MySQL database operations.

Error CodeError MessageDescriptionSolution
AuthFailure.DataSourceOperationAuthFailurePermission denied. Please check permissions in the permission module.Permission denied, insufficient database operation permissionsGo to CloudBase Platform/MySQL Database/Permission Management to check and configure permissions
AuthFailure.SetOwnerNotAllowedSetting user identifier field is not allowed.Setting user identifier field _openid is not allowedRemove explicit assignment operations to the _openid field, which is automatically managed by the system
AuthFailure.PermissionNotConfiguredPermission not configured. Please configure proper permissions in the permission module.Data access permission not configuredGo to CloudBase Platform/MySQL Database/Permission Management to configure corresponding permission rules
AuthFailure.AuthErrorPermission error.Permission verification failed, usually due to missing system-dependent _openid field in custom tableConfirm that the table structure includes the _openid field (VARCHAR type), or disable permission verification
FailedOperation.EmptyDatabaseEndpointDatabase endpoint is empty.Database connection information is emptyCheck if the database instance is started normally and confirm if the connection configuration is correct
FailedOperation.DatabaseConnectErrorFailed to establish database connection.Database connection failedCheck network connection, database instance status, and if username/password are correct
FailedOperation.DatabaseExecSqlErrorExecute sql error.SQL execution failed, please refer to the "MySQL Native Error Codes" section for detailed error informationView complete error information and troubleshoot according to MySQL error codes
FailedOperation.DatabaseSchemaErrorDatabase schema error.Database schema metadata information is abnormalCheck if the table structure definition is correct, contact customer service for technical support if necessary
FailedOperation.DatabaseBuildSqlErrorBuild sql error.SQL construction failed, possibly due to incorrect request parameters or missing metadata informationCheck if the request parameter format is correct, contact customer service for technical support if necessary
FailedOperation.DatabaseDataProcessErrorProcess data error.Data processing failedCheck if the data format meets requirements, contact customer service for technical support if necessary
ResourceNotFound.InstanceNotFoundDatabase instance not found.Database instance does not existConfirm if the instance ID is correct, or go to the console to create a new instance
ResourceNotFound.SchemaNotFoundDatabase schema not found.Database schema does not existConfirm if the database name is correct, or go to the console to create a database
ResourceNotFound.TableNotFoundTable not found.Data table does not existConfirm if the table name is correct, or go to the console to create a data table
UnsupportedOperation.TooManyTablesNumber of tables exceeds the limit.Number of data tables exceeds the limitDelete unnecessary tables, or contact customer service to apply for expansion
InvalidParameter.ResponseUnacceptableSingleErrorResponse does not meet the requirement for a single record.Response data does not meet single record format requirementsCheck the Accept parameter setting in the request header to ensure it matches the query result

MySQL Native Error Codes

When the business error code is FailedOperation.DatabaseExecSqlError, the error details will include the native error code returned by the MySQL database. You can determine the error type based on the error code range and consult the MySQL official documentation for detailed explanations.

Error Code Classification Rules

MySQL error codes are classified into the following categories by numerical range:

Server Error

Error Code Range: 1000-1999, 3000-5000+

Error Characteristics: Issues at the database engine, query optimizer, or storage engine level

Typical Example:

Error 1054 (42S22): Unknown column 'username' in 'field list'

Troubleshooting Approach:

  • Check if SQL statement syntax is correct
  • Confirm if table structure, field names, indexes, etc. exist
  • Check if data types match

Client Error

Error Code Range: 2000-2999

Error Characteristics: Issues at the client driver, connection library, or network level

Typical Example:

Error 2003 (HY000): Can't connect to MySQL server on '192.168.1.100'

Troubleshooting Approach:

  • Check if network connection is normal
  • Confirm if database service is started
  • Check firewall and security group configuration

Global Error

Error Code Range: 1-999

Error Characteristics: System-level generic errors

Typical Example:

Error 13 (HY000): Can't settle log file (OS errno 13 - Permission denied)

Troubleshooting Approach:

  • Check file system permissions
  • Confirm if disk space is sufficient
  • Check system resource usage

CynosDB Error

Error Code Range: 9000-9999

Error Characteristics: Tencent Cloud CynosDB product-specific errors

Typical Example:

Error 9449 (08S01): CynosDB serverless instance is resuming, please try connecting again

Error Code Documentation CynosDB Error Code Reference

Official Documentation Reference

Depending on the error code type, you can consult the following MySQL official documentation:

Server Error

MySQL VersionOfficial Documentation Link
MySQL 8.0Server Error Reference
MySQL 5.7Server Error Reference

Client Error

MySQL VersionOfficial Documentation Link
MySQL 8.0Client Error Reference
MySQL 5.7Client Error Reference

Global Error

MySQL VersionOfficial Documentation Link
MySQL 8.0Global Error Reference
MySQL 5.7Global Error Reference
💡 Tip
  • When encountering errors, it is recommended to first record the complete error information (including error code, SQLSTATE, and error description)
  • Quickly determine the source of the problem (server-side vs client-side) based on the error code range
  • Consult the official documentation for the corresponding version to get detailed error explanations and solution suggestions
  • If the problem cannot be resolved on your own, you can contact Technical Support for help