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.