3 Replies Latest reply on Dec 12, 2019 2:18 PM by Dave Stokes-MySQL Community Team-Oracle

    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