Comment 3 for bug 2061889

Revision history for this message
Jay Jahns (jayjahns) wrote :

I think the problem with this is that when upgrading from 2023.1 to 2023.2 or later, the mariadb version changes from 10.6 to 10.11.

The mariabackup command that gets executed uses the --history option. In 10.6 this information gets written to PERCONA_SCHEMA.xtrabackup_history. In 10.11 that has changed to mysql.mariadb_backup_history.

After our own investigation, it was determined that the variable mariadb_backup_database_schema needs to be changed from "PERCONA_SCHEMA" to "mysql" in order to ensure the correct database/tables have the correct permissions.