Help Center/ Data Replication Service/ Troubleshooting/ Failure Cases/ Real-time Synchronization from MySQL to GaussDB(DWS)/ Full Synchronization Error: column name 'tid' conflicts with a system column name
Updated on 2022-09-21 GMT+08:00

Full Synchronization Error: column name 'tid' conflicts with a system column name

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=table_structure, index=%s, schema_name=%s, object_name=%s]reason:[ERROR: column name 'tid' conflicts with a system column name]

Possible Causes

The possible causes are as follows:

  • tid is a reserved character of GaussDB(DWS) and exists in the source database table.

Solution

This scenario is not supported due to the restrictions of the destination database. You can change the column names of the source database table.