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

Incremental Synchronization Error: syntax error at or near

Scenarios

During incremental synchronization, an error is reported, and the log information is as follows: service INCREMENT failed, cause by: Check whether dws supports the DDL. For support, please contact dws Services. DDL: CREATE TABLE xxx like xxx. failed by:ERROR: syntax error at or near '%s'

Possible Causes

The possible causes are as follows:

  • The DDL statement conversion in the source database does not comply with the syntax of the destination database.

Solution

DRS does not convert the syntax for incremental DDL synchronization from MySQL to GaussDB (DWS). The DDL executed in the MySQL database will be executed in GaussDB(DWS). Contact Huawei technical support.