mysql.backup_progress table does not exist on MySQL 8.0.18

1468683

I'm trying to use MySQL Enterprise Backup 8.0.18 against InnoDB Cluster, and I get the following warning:

191204 11:42:50 MAIN WARNING: This backup operation cannot write to backup progress. The MySQL server is running with the --super-read-only option.

This is surprising because there were recent updates in order to support writing the backup progress to the primary node.

It turns out there is nothing wrong with the grants, or communication to the primary cluster node.  The table does not exist:

mysql> select count(*) from mysql.backup_progress;

ERROR 1146 (42S02): Table 'mysql.backup_progress' doesn't exist

https://dev.mysql.com/doc/mysql-enterprise-backup/8.0/en/trouble.logging.html

https://dev.mysql.com/doc/refman/8.0/en/group-replication-enterprise-backup.html

https://dev.mysql.com/doc/mysql-enterprise-backup/8.0/en/mysqlbackup.privileges.html

Why does it not exist?  Is it safe for me to create it manually.

I tried running an "upgrade", but it didn't help.

$ sudo -u mysql -H mysqld --upgrade=AUTO

Dave Stokes-MySQL Community Team-Oracle

Since you are a MySQL Enterprise Customer I highly recommend contacting MySQL Support for a quick resolution.

1468683

Currently running the trial version on VirtualBox, while trying to sort out the contract.

Also, if there is a quick answer, then it would make sense to share it with the community.

Dave Stokes-MySQL Community Team-Oracle

Sorry but there is no 'quick answer'.  Somewhere along the way the backup_progress table was not created which implies other parts of the setup process were not installed correctly.  MySQL support sees these types of problems on a regular basis and can probably find the answer faster than I could with a month of work.