Help Center/ Data Replication Service/ Troubleshooting/ Failure Cases/ Real-Time Migration and Synchronization from MySQL to MySQL/ Incremental Phase Error: source has more columns than target
Updated on 2023-01-17 GMT+08:00
View PDF
Share

Incremental Phase Error: source has more columns than target

Scenarios

During an incremental migration or synchronization, an error is reported, and the log information is as follows: service INCREMENT failed, cause by: Check table structure consistency fail! Table %s in source has more columns than target

Possible Causes

The table structure is modified in the destination database. As a result, the synchronization statement reports an error.

Solution

  1. Contact 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. After the change is complete, click Resume in the Operation column to resume the task.