Help Center/ Data Replication Service/ Troubleshooting/ Failure Cases/ Real-Time Migration and Synchronization from MySQL to MySQL/ Incremental Phase Error: You have an error in your SQL syntax
Updated on 2024-11-30 GMT+08:00
View PDF
Share

Incremental Phase Error: You have an error in your SQL syntax

Scenarios

During an incremental migration or synchronization, an error is reported, and the log information is as follows: service INCREMENT failed, cause by: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near'START TRANSACTION' at line 39

Possible Causes

During the pre-check, the system skips version check. The syntax of the later version fails to be executed in the earlier version.

Solution

  1. Contact the user to modify the statement based on the destination database syntax and run the statement in the destination database.
  2. Contact Huawei engineers to skip this error.
  3. In the task list, locate the target task and click Resume in the Operation column to resume the task.