Help Center> Data Replication Service> Troubleshooting> Failure Cases> Real-Time Migration and Synchronization from MySQL to MySQL> Incremental Phase Error: Can't DROP ***; check that column/key exists
Updated on 2023-01-17 GMT+08:00
View PDF

Incremental Phase Error: Can't DROP ***; check that column/key exists

Scenarios

During an incremental migration or synchronization, an error is reported, and the log information is as follows: service INCREMENT failed, cause by: Can't DROP ' %s'; check that column/key exists; sql is %s

Possible Causes

DDL is executed on the destination database table, causing the table structure in the destination database to be inconsistent with that in the source database.

Solution

  1. Contact the destination database O&M engineers to change the table structure of the destination database to be the same as that of the source database.
  2. In the task list, locate the target task and click Resume in the Operation column to resume the task.