Help Center> Data Replication Service> Troubleshooting> Failure Cases> Real-Time Migration and Synchronization from MySQL to MySQL> Incremental Phase Error: write table %s.%s failed: Duplicate entry '%s' for key 'PRIMARY'
Updated on 2022-09-21 GMT+08:00

Incremental Phase Error: write table %s.%s failed: Duplicate entry '%s' for key 'PRIMARY'

Scenarios

During an incremental synchronization, an error is reported, and the log information is as follows: service INCREMENT failed, cause by: write table %s. %s failed: Duplicate entry ' %s' for key 'PRIMARY'

Possible Causes

The possible causes are as follows:

  • A primary key conflict is reported when the synchronization policy is selected.

Solution

The migration task needs to be recreated.