Help Center/ Data Replication Service/ FAQs/ Data-Level Comparison/ What Can I Do If the Table Comparison Result Shows That an SQL Execution Error Occurs in the Source or Destination Database?
Updated on 2025-12-16 GMT+08:00
What Can I Do If the Table Comparison Result Shows That an SQL Execution Error Occurs in the Source or Destination Database?
The following are possible causes if the table comparison result shows that an SQL execution error occurs in the source or destination database:
- If MySQL is used as the source or destination database, and the size of the query field or single-line communication exceeds the value of max_allowed_packet, you are advised to change the value of max_allowed_packet to an appropriate value.
- If the SQL execution in the source or destination database times out, submit a service ticket to contact DRS customer service.
- During value comparison for data synchronization from MySQL to GaussDB Centralized or from GaussDB Centralized to MySQL, if the date, datetime, or timestamp field exceeds the valid time range, a comparison error may be reported.
Parent topic: Data-Level Comparison
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
