Help Center/ Data Admin Service/ API Reference/ APIs/ Intelligent O&M/ Viewing Binlog Parsing Errors
Updated on 2026-08-25 GMT+08:00

Viewing Binlog Parsing Errors

Function

This API is used to view binlog parsing errors.

Authorization Information

Each account has permissions to call all APIs, but IAM users must have the required permissions specifically assigned.

  • If you are using role/policy-based authorization, see the required permissions in Permissions Policies and Supported Actions.
  • If you are using identity policy-based authorization, the following identity policy-based permissions are required.

    Action

    Access Level

    Resource Type (*: required)

    Condition Key

    Alias

    Dependencies

    das:clouddba:listBinlog

    List

    Instance

    -

    -

    -

URI

GET /v3/{project_id}/connections/{connection_id}/binlog-parse/search-error-info

Table 1 URI parameters

Parameter

Mandatory

Type

Description

project_id

Yes

String

Definition

Project ID of a tenant in a region.

To obtain this value, see Obtaining a Project ID.

Constraints

N/A

Range

The value can contain 32 characters. Only letters and digits are supported.

Default Value

N/A

connection_id

Yes

String

Definition

Connection ID established between a database account and the database. The database user ID is created using the API in Creating an Instance Connection.

Constraints

N/A

Range

The value is a UUID containing 36 characters. Only letters, digits, and hyphens (-) are allowed.

Default Value

N/A

Table 2 Query parameters

Parameter

Mandatory

Type

Description

task_id

Yes

Long

Definition

ID of a parsing task

Constraints

N/A

Range

N/A

Default Value

N/A

file_name

No

String

Definition

File name

Constraints

N/A

Range

N/A

Default Value

N/A

db_name

No

String

Definition

Database name

Constraints

N/A

Range

N/A

Default Value

N/A

table_name

No

String

Definition

Table name

Constraints

N/A

Range

N/A

Default Value

N/A

Request Parameters

None

Response Parameters

Status code: 200

Table 3 Response body parameters

Parameter

Type

Description

total

Integer

Definition

Total number

Range

[0, 2^31-1]

error_trans_infos

Array of Table 4 objects

Definition

Binlog parsing errors

Table 4 ErrorTransInfo

Parameter

Type

Description

id

Long

Definition

ID of a parsing task

Range

N/A

file_name

String

Definition

File name

Range

N/A

object_key

String

Definition

Object key

Range

N/A

begin_position

Long

Definition

Parsing start position

Range

N/A

end_position

Long

Definition

Parsing end position

Range

N/A

db_name

String

Definition

Database name

Range

N/A

tb_name

String

Definition

Table name

Range

N/A

create_time

Date

Definition

Task creation time, in milliseconds

Range

N/A

error_msg

String

Definition

Error message

Range

N/A

Example Requests

GET https://das.cn-north-1.myhuaweicloud.com/v3/054e292c9880d4992f02c0196d3ea468/connections/179e525e-0e9c-4dcc-9dd7-ee2f36121e23/binlog-parse/search-error-info?task_id=1234

Example Responses

Status code: 200

Success.

{
    "total": 2,
    "error_trans_infos": [
      {
        "id": 1001,
        "file_name": "mysql-bin.000123",
        "object_key": "datatrack/binlog/mysql-bin.000123",
        "begin_position": 4567,
        "end_position": 5120,
        "db_name": "order_db",
        "tb_name": "t_order",
        "create_time": "2026-07-03T10:30:00.000+08:00",
        "error_msg": "Duplicate entry '1024' for key 'PRIMARY'"
      },
      {
        "id": 1002,
        "file_name": "mysql-bin.000124",
        "object_key": "datatrack/binlog/mysql-bin.000124",
        "begin_position": 890,
        "end_position": 1200,
        "db_name": "user_db",
        "tb_name": "t_user",
        "create_time": "2026-07-03T11:15:30.000+08:00",
        "error_msg": "Cannot delete or update a parent row: a foreign key constraint fails"
      }
    ]
 }

Status Codes

Status Code

Description

200

Success.

400

Client error.

500

Server error.

Error Codes

See Error Codes.