Help Center> Data Replication Service> Troubleshooting> Failure Cases> Real-time Synchronization from MySQL to GaussDB(DWS)> Incremental Synchronization Error: %s doesn't in the target table
Updated on 2022-09-21 GMT+08:00

Incremental Synchronization Error: %s doesn't in the target table

Scenarios

During incremental synchronization, an error is reported, and the log information is as follows: service INCREMENT failed, cause by: insert %s failed: %s doesn't in the target table: %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.
  • 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.