On this page

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

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

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.

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback