Full Synchronization Error: value too long for type character varying

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: value too long for type character varying( %s) Where: COPY %s, line 1, column remarks.

Possible Causes

The length of the varchar column in the user-defined table in the destination database is insufficient. MySQL and GaussDB(DWS) define the length of the varchar data type differently. MySQL defines the length of the varchar data type as the number of characters, while GaussDB(DWS) defines the length of the varchar data type as the number of bytes.

Solution

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