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: apply data of table=` %s`.` %s` failed: 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:

  • The destination database is read-only. The possible cause is that the space of the destination database is insufficient.

Solution

Contact destination database O&M engineers to rectify the fault.