Xtrabackup 8.0.14 - MySQL 8.0.21 - archive logs dir issue

Hi, another question on xtrabackup.
On the log of the backup i see this error:

Error: failed to fetch query result select innodb_redo_log_archive_start('', '1611929189201'): Label '' not found in server variable 'innodb_redo_log_archive_dirs'
xtrabackup: Redo Log Archiving is not used.

I have setted the innodb_redo_log_archive_dirs:

mysql> show VARIABLES LIKE 'innodb_redo_log_archive_dirs';
+------------------------------+-----------------------------+
| Variable_name                | Value                       |
+------------------------------+-----------------------------+
| innodb_redo_log_archive_dirs | arch1:/var/backup/arch_logs |
+------------------------------+-----------------------------+
1 row in set (0.01 sec)

But xtrabackup try to find it without the alias arch1, how can I tell to xtrabackup to use the alias arch1?

Thanks

2 Likes

Hi @StefanoG .

Xtrabackup will populate the label used in the mentioned query after it confirms it has access to the folder where you store your archive logs. Check a few lines before your error and you will see that xtrabackup reported an error while trying to access /var/backup/arch_logs .

Here is one example:

mysql> SHOW VARIABLES LIKE 'innodb_redo_log_archive_dirs';
+------------------------------+------------------+
| Variable_name                | Value            |
+------------------------------+------------------+
| innodb_redo_log_archive_dirs | label1:/backups1 |
+------------------------------+------------------+
1 row in set (0.00 sec)

Running xtrabackup while it has no access to /backup1 gives me the same error:

xtrabackup: Can't create directory '/backups1' (OS errno 13 - Permission denied)
Error: failed to fetch query result select innodb_redo_log_archive_start('', '1613390070006'): Label '' not found in server variable 'innodb_redo_log_archive_dirs'
xtrabackup: Redo Log Archiving is not used.
1 Like