Help Center/
Data Replication Service/
Troubleshooting/
Failure Cases/
Real-time Synchronization from MySQL to GaussDB(DWS)/
Full Synchronization Error: date/time field value out of range
Updated on 2022-09-21 GMT+08:00
Full Synchronization Error: date/time field value out of range
Scenarios
During full synchronization, an error is reported, and the log information is as follows: service DATAMOVE failed, cause by: retry structures failed events=the fail structures are [type=table_structure, index= %s, schema_name= %s, object_name= %s]reason:[ERROR: date/time field value out of range: '0000-00-00 00:00:00'].
Possible Causes
The possible causes are as follows:
- GaussDB(DWS) does not support 0000-00-00 00:00:00.
Solution
This scenario is not supported due to the restrictions of the destination database. You can change the column names of the source database table.
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.
The system is busy. Please try again later.
