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 *** like ***. failed by:ERROR: syntax error at or near '%s'
Possible Causes
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.
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
