Skip to Main Content

MySQL Database

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

mysql.backup_progress table does not exist on MySQL 8.0.18

1468683Dec 4 2019 — edited Dec 12 2019

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

Comments
Post Details
Added on Dec 4 2019
3 comments
246 views