Help Center/
Data Replication Service/
Troubleshooting/
Failure Cases/
Real-Time Migration and Synchronization from MySQL to MySQL/
Full Phase Error: The MySQL server is running with the --super-read-only option so it cannot execute this statement
Updated on 2022-09-21 GMT+08:00
Full Phase Error: The MySQL server is running with the --super-read-only option so it cannot execute this statement
Scenarios
During a full migration or 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=constraint_data, index=0, schema_name= %s, object_name= %s]reason:[The MySQL server is running with the --super-read-only option so it cannot execute this statement]
Possible Causes
The possible causes are as follows:
- When DRS migrates indexes, the destination database is in the read-only state. The possible cause is that the space of the destination database is insufficient.
Solution
Contact the O&M engineers to check the running status and disk space of the destination database.
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.
