Help Center/ Data Replication Service/ Troubleshooting/ Failure Cases/ Real-Time Migration and Synchronization from MySQL to MySQL/ Incremental Phase Error: Data truncation: Data too long for column
Updated on 2023-01-17 GMT+08:00
View PDF
Share

Incremental Phase Error: Data truncation: Data too long for column

Scenarios

During an incremental migration or synchronization, an error is reported, and the log information is as follows: service INCREMENT failed, cause by: Data truncation: Data too long for column ' %s' at row %s; sql is: %s

Possible Causes

The DDL statement fails to be executed because data is too long.

Solution

  1. Contact the destination database O&M engineers to check the structure of the table where the synchronization error is reported, adjust the length of the column where the error is reported, and adjust the column data type in the destination database.
  2. In the task list, locate the target task and click Resume in the Operation column to resume the task.