Overview

This topic describes the error messages for MySQL tenants in OceanBase Database.

Format of error messages

OceanBase Database is highly compatible with MySQL. Specifically, OceanBase Database is compatible with general MySQL features, foreground and background MySQL protocols, and some native error codes of MySQL. Therefore, the error message format for MySQL tenants in OceanBase Database is the same as that in MySQL databases.

The format of error messages is as follows:

ERROR <err_num> (<sql_stat>): err_msg

The parameters are described as follows:

• err_num: the error code.

• sql_stat: the SQL state.

• err_msg: the error message.

Variables in error messages

In OceanBase Database, variables are embedded in error messages to help you troubleshoot issues. In this topic, these variables are represented by percent signs (%).

Here is an example:

ERROR 4626 (HY000): resource pool '%s' has already been granted to a tenant

The preceding error message may appear as the following message:

ERROR 4626 (HY000): resource pool 'pool1' has already been granted to a tenant

Error code description

The following table describes the system error codes by range.