Problem description

An error occurs when DTS parses the Binlog of the MySQL database. The error is as follows:

DTS-1050005 MySQL table xx.xx binlog column count check error, local count is 21, but binlog count is 22, at offset 9198@111547.

Note:

  • xx.xx is the database name and table name.
  • 21 is the number of fields of the table structure maintained locally in DTS.
  • 22 indicates the number of fields in the binary log for this table.
  • 9198 @ 111547 indicates the position of the statement in the Binlog.

Cause

The format of the table that corresponds to the logs to be parsed is different from that of the tables stored in DTS. The following two causes can be used:
  • Cause 1: The DDL statement for modifying the schema of this table fails to be parsed, and the structure of the table stored in the local disk is not updated.
  • Cause 2: The Source database has modified the table schema during full data migration or initialization.

Solution

A ticket is required to contact Alibaba Cloud technical support personnel to reload the schema of the locally stored table in DTS.

Application scope

  • Data Transmission Service (DTS)