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 2024-11-30 GMT+08:00
View PDF
Share

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

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

  1. Contact the O&M engineers to check the status of the destination database and rectify the database fault.
  2. After the destination database is restored, click Resume in the Operation column to resume the task.