Help Center> Data Replication Service> Troubleshooting> Failure Cases> Real-Time Synchronization from MySQL to GaussDB(DWS)> Incremental Synchronization Error: source has more columns than target
Updated on 2023-01-17 GMT+08:00

Incremental Synchronization Error: source has more columns than target

Scenarios

During incremental 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, the columns is= [%s, %s]

Possible Causes

  • The filter conditions of DDL statements for adding columns in the source database are not synchronized to the destination database.
  • As a result, columns are deleted in the destination database.

Solution

  1. Supplement the missing columns in the destination database based on the table structure of the source database.
  2. In the task list, locate the target task and click Resume in the Operation column to resume the task.