Help Center> Data Replication Service> Troubleshooting> Failure Cases> Real-Time Migration and Synchronization from MySQL to MySQL> Incremental Phase Error: not equals to target db column count
Updated on 2023-01-17 GMT+08:00
View PDF

Incremental Phase Error: not equals to target db column count

Scenarios

During an incremental migration or synchronization, an error is reported, and the log information is as follows: service INCREMENT failed, cause by: write table %s. %s failed: table= %s. %s has field list size=[***] not equals to target db column count= %s

Possible Causes

DDL is executed on the destination database table, causing the table structure in the destination database to be inconsistent with that in the source database.

Solution

  1. Contact the destination database O&M engineers to change the table structure of the destination database to be the same as that of the source database.
  2. In the task list, locate the target task and click Resume in the Operation column to resume the task.