Updated on 2022-09-21 GMT+08:00

Full Phase Error: Unknown column '%s' 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 possible causes are as follows:

  • 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

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