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 2023-01-17 GMT+08:00
View PDF

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 destination database is read-only. The possible cause is that the space of the destination database is insufficient.

Solution

  1. Adjust the storage space of the destination database and restore the destination database to the Read/Write state.

    • If RDS for MySQL is used, see RDS for MySQL Performance Tuning or contact RDS customer service to adjust the destination database storage space.
    • If an on-premises MySQL database or a MySQL database built on another cloud is used, contact database O&M engineers to check and adjust the destination database storage space.

  2. After the adjustment is complete, click Resume in the Operation column to resume the task.