Checking Whether Tables Structures Are Consistent
MySQL -> CSS/ES Synchronization
Check Item |
Whether tables structures are consistent |
---|---|
Description |
Check whether the table structures at the source end and destination are consistent. |
Failure Cause and Handling Suggestion |
Failure cause: The source table columns are not a subset of the destination indexes. Handling suggestion: Return to the Set Synchronization Task page, select the tables that meet the requirements. Alternatively, create indexes required in the destination table. Statement for querying the destination database: GET /<index>/_mapping?include_type_name |
MySQL -> GaussDB(DWS) Synchronization
Check Item |
Whether tables structures are consistent |
---|---|
Description |
Check whether the table structures at the source end and destination are consistent. |
Failure Cause and Handling Suggestion |
Failure cause: The destination table does not contain all columns of the source table or the not-null constraints of the columns are inconsistent. The possible causes are as follows:
Handling suggestion: Return to the Set Synchronization Task page, select the tables that meet the requirements. Alternatively, modify columns required in the destination table. Ensure that the source table columns are a subset of the destination columns. |
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