Help Center> Data Replication Service> Troubleshooting> Failure Cases> Real-Time Synchronization from MySQL to GaussDB(DWS)> Full Synchronization Error: column 'database_table' of relation *** does not exist
Updated on 2023-01-17 GMT+08:00
View PDF

Full Synchronization Error: column 'database_table' of relation *** does not exist

Scenarios

During full 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= %s, table_schema= %s, table_name= %s, record_num= %s] occur error, msg=apply to %s failed: ERROR: column 'database_table' of relation ' %s' does not exist.

Possible Causes

No additional column is added when a table is created in the destination database.

Solution

  1. Contact destination database O&M engineers to add additional columns to the destination database table.
  2. In the task list, locate the target task and click Resume in the Operation column to resume the task.