Help Center> Data Replication Service> Troubleshooting> Failure Cases> Real-Time Migration and Synchronization from MySQL to MySQL> Full Phase Error: Too many keys specified; max 64 keys allowed
Updated on 2023-11-13 GMT+08:00
View PDF

Full Phase Error: Too many keys specified; max 64 keys allowed

Scenarios

During a full migration or synchronization, an error is reported, and the log information is as follows: service DATAMOVE failed, cause by: retry structures failed events=the fail structures are [type=constraint_data, index=0, schema_name=DB, object_name=TABLE]reason:[Too many keys specified; max 64 keys allowed]

Possible Causes

A maximum of 64 secondary indexes can be created for a single MySQL table. The total number of new and existing indexes in the destination database exceeds 64.

Solution

  1. After manually creating the required indexes in the destination database, contact DRS O&M personnel to skip the migtation of secondary indexes in the table.
  2. In the task list, locate the target task and click Resume in the Operation column to resume the task.