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 2022-09-21 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: INCREMENT failed, cause by: Table %s in source has more columns than target, the columns is= [ %s, %s].

Possible Causes

The possible causes are as follows:

  • 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

Supplement the missing columns in the destination database based on the table structure of the source database.