xtrabackup incremental is failing against Percona server 5.7


I met an ERROR when doing incremental backup:

Error: failed to execute query FLUSH NO_WRITE_TO_BINLOG CHANGED_PAGE_BITMAPS: Access denied; you need (at least one of) the SUPER privilege(s) for this operation

I did the incremental backup with a user only have RELOAD, LOCK TABLES, PROCESS and REPLICATION CLIENT privileges. I don’t want to give the backup user the SUPER privilege.

I did the full backup with the same user and it finished successfully. I didn’t know why I need SUPER privilege to do the incremental backup.

I appreciate if anyone can help me this out.


Mehman Jafarov

You will need the SUPER privilege, based on the documentation:

SUPER in order to start/stop the slave threads in a replication environment, use XtraDB Changed Page Tracking for Incremental Backups and for Improved FLUSH TABLES WITH READ LOCK handling,