Help Center/ Data Replication Service/ Troubleshooting/ Failure Cases/ Real-Time Migration and Synchronization from MySQL to MySQL/ Full Phase Error: Unknown column *** in 'field list'
Updated on 2023-01-17 GMT+08:00
View PDF
Share

Full Phase Error: Unknown column *** in 'field list'

Scenarios

During a full migration or synchronization, an error is reported, and the log information is as follows: service DATAMOVE failed, cause by: apply event=[type=table_data, batch_index_in_shard=1, table_schema= %s, table_name= %s, record_num=5] occur error, msg=apply data of table=` %s`.` %s` failed: Unknown column ' %s' in'field list'.

Possible Causes

The table structures of the source and destination databases are inconsistent. The possible cause is that DDL is executed on the columns of the destination database table during full synchronization or the table consistency check is skipped during pre-check.

Solution

  1. Contact the O&M personnel to change the table structure of the destination database to be the same as that of the source database.
  2. After the change is complete, click Resume in the Operation column to resume the task.