MariaDB10.6 -- Waiting for log copy thread to read lsn 0
Hi I am getting below error when i do backup on secondary (read only) server.
[00] 2023-01-17 03:00:00 >> log scanned up to (6213618627472) [01] 2023-01-17 03:00:01 ...done [01] 2023-01-17 03:00:01 Compressing and streaming ./aria_log.00000001 to <STDOUT> [00] 2023-01-17 03:00:01 >> log scanned up to (6213618660632) [01] 2023-01-17 03:00:02 ...done [00] 2023-01-17 03:00:02 Waiting for log copy thread to read lsn 0
Below is command which i am using to take backup
var/lib/mysql/bin/mariabackup --backup --host=hostname --port=3166 --user=marbackup --password=xxx --close-files --open-files-limit 90000 --slave-info --stream=xbstream --no-lock --safe-slave-backup --no-backup-locks --compress --compress-threads=12 --compress-chunk-size=5M > /mysql/files/backups/nfs/hostname_data/backup.xb
I added --close-files thinking it might resolve