Updated on 2022-09-21 GMT+08:00

Incremental Phase Error: Lock wait timeout exceeded

Scenarios

During an incremental migration or synchronization, an error is reported, and the log information is as follows: service INCREMENT failed, cause by: Lock wait timeout exceeded; try restarting transaction

Possible Causes

The possible cause is as follows:

  • The lock wait times out when the destination database is accessed.

Solution

Contact destination database O&M engineers to check the status and load of the destination database.