Help Center> Data Replication Service> Troubleshooting> Failure Cases> Real-time Synchronization from MySQL to GaussDB(DWS)> Full Synchronization Error: column 'database_table' of relation '%s' does not exist
Updated on 2022-09-21 GMT+08:00

Full Synchronization Error: column 'database_table' of relation '%s' 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

The possible causes are as follows:

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

Solution

Contact destination database O&M engineers to add additional columns to the destination database table.