Help Center/ Data Replication Service/ Troubleshooting/ Failure Cases/ Real-Time Migration and Synchronization from MySQL to MySQL/ Incremental Phase Error: The MySQL server is running with the --super-read-only option
Updated on 2024-11-30 GMT+08:00
View PDF
Share

Incremental Phase Error: The MySQL server is running with the --super-read-only option

Scenarios

During an incremental migration or synchronization, an error is reported, and the log information is as follows: service INCREMENT failed, cause by: write table %s. %s failed: record tid: %s,seqno: %s with PK applied failed in table %s. %s, The MySQL server is running with the --super-read-only option so it cannot execute this statement

Possible Causes

The destination database is in the read-only state. Generally, the destination database storage is insufficient.

Solution

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