Incremental Phase Error: Operation not allowed when innodb_force_recovery > 0

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 ***.*** failed: Operation not allowed when innodb_force_recovery > 0.

Possible Causes

The destination DB instance is abnormal. When the system variable innodb_force_recovery is set to be greater than 0 in the destination database, the INSERT, UPDATE, and DELETE operations are disabled in the destination database.

Solution

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