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

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

The possible causes are as follows:

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

Solution

Contact the user to modify the statement based on the destination database syntax and run the statement in the destination database. Then, contact Huawei engineers to skip this error and click Resume in the Operation column to resume the task.