This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-15. For the latest, interactive version please visit https://mariadb.com/kb/.

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

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.