Help Center>
Data Replication Service>
Troubleshooting>
Failure Cases>
Real-Time Synchronization from MySQL to GaussDB(DWS)>
Incremental Synchronization Error: source has more columns than target
Updated on 2023-01-17 GMT+08:00
Incremental Synchronization Error: source has more columns than target
Scenarios
During incremental synchronization, an error is reported, and the log information is as follows: service INCREMENT failed, cause by: Check table structure consistency fail! Table %s in source has more columns than target, the columns is= [%s, %s]
Possible Causes
- The filter conditions of DDL statements for adding columns in the source database are not synchronized to the destination database.
- As a result, columns are deleted in the destination database.
Solution
- Supplement the missing columns in the destination database based on the table structure of the source database.
- In the task list, locate the target task and click Resume in the Operation column to resume the task.
Parent topic: Real-Time Synchronization from MySQL to GaussDB(DWS)
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.
The system is busy. Please try again later.
For any further questions, feel free to contact us through the chatbot.
Chatbot