Help Center/ Data Replication Service/ Troubleshooting/ Failure Cases/ Real-Time Migration and Synchronization from MySQL to MySQL/ Incremental Phase Error: you need (at least one of) the SUPER privilege(s) for this operation
Updated on 2022-09-21 GMT+08:00
View PDF

Incremental Phase Error: you need (at least one of) the SUPER privilege(s) for this operation

Scenarios

During an incremental migration, an error is reported, and the log information is as follows: service INCREMENT failed, cause by: Access denied; you need (at least one of) the SUPER privilege(s) for this operation; sql is: CREATE DEFINER= %s

Possible Causes

The possible causes are as follows:

  • The user retained the definer for migration, but the definer is abnormal or does not exist.

Solution

Contact the customer's O&M engineers to check the running status and disk space of the destination database.