Help Center/ Data Replication Service/ Troubleshooting/ Failure Cases/ Real-Time Migration and Synchronization from MySQL to MySQL/ Full Phase Error: Column name 'AUTO_PK_ROW_ID' is reserved.
Updated on 2022-09-21 GMT+08:00
View PDF

Full Phase Error: Column name 'AUTO_PK_ROW_ID' is reserved.

Scenarios

An error is reported during full migration or synchronization, and the following log information is displayed: service LOGMANAGER failed, cause by: create table xxx error. Column name 'AUTO_PK_ROW_ID' is reserved. Operation 'CREATE' is not permitted.

Possible Causes

The possible cause is as follows:

  • The AUTO_PK_ROW_ID column name is a reserved column name for the RDS for MySQL database and cannot be created by users.

Solution

  • Check the tables whose column names contain AUTO_PK_ROW_ID in the source database, change the column names, and resume the task.
  • Create a task again and do not select the tables whose column names contain AUTO_PK_ROW_ID.