Problem description

When DTS is used for data transmission, the following error message is displayed.

Note: the format of database connection information is xx.xx.xx.xx:xx,3 indicates the number of dictionary columns, 4 indicates the number of Binlog columns, and 3 @ 4105797 indicates the number of the Binlog file with the error or the offset.

DTS-1050005 MySQL table xxx.xxx binlog column count check error, local count is 3, but binlog count is 4, at offset 3@4105797.

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

GRANT the DTS source database account the query permission for all information_schema. For details about authorization, see GRANT.

Note: If the issue persists, you can submit a ticket to Alibaba Cloud and describe the DDL operation that was recently executed. Alibaba Cloud technical support personnel to reload the schema of the DTS table stored in the local disk.

Application scope

  • DTS