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

Full Synchronization Error: column '%s' does not exist

Scenarios

During full synchronization, an error is reported, and the log information is as follows: service DATAMOVE failed, cause by: retry structures failed events=the fail structures are [type=function, index=0, schema_name= %s, object_name=' %s']reason:[ERROR: column ' %s' does not exist Position: %s].

Possible Causes

  • During the full synchronization, DDL operations are executed in the destination database. As a result, the table structure in the destination database is inconsistent with that in the source database.
  • During the full synchronization, DDL operations are executed in the source database. As a result, the table structure in the destination database is inconsistent with that in the source database.

Contact the customer to confirm whether they executed DDL operations.

Solution

Create a synchronization task again. During the full synchronization, ensure that no DDL operation is executed on the source database and no data is written to the destination database. Otherwise, data may be inconsistent or the synchronization may fail.