Help Center> Data Replication Service> Troubleshooting> Failure Cases> Real-Time Synchronization from MySQL to GaussDB(DWS)> Incremental Synchronization Error: *** doesn't in the target table
Updated on 2023-01-17 GMT+08:00

Incremental Synchronization Error: *** 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 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

  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.