On January 27th, this site will be read-only as we migrate to Oracle Forums for an improved community experience. You will not be able to initiate activity until January 30th, when you will be able to use this site as normal.

    Forum Stats

  • 3,889,629 Users
  • 2,269,769 Discussions
  • 7,916,800 Comments

Discussions

mysql.backup_progress table does not exist on MySQL 8.0.18

1468683
1468683 Member Posts: 2
edited Dec 12, 2019 9:18AM in MySQL Community Space

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

Answers