[MDEV-21037] mariabackup does not detect multi-source replication slave Created: 2019-11-12  Updated: 2023-03-17  Resolved: 2022-04-25

Status: Closed
Project: MariaDB Server
Component/s: Backup, mariabackup
Affects Version/s: 10.3.20
Fix Version/s: 10.2.44, 10.3.35, 10.4.25, 10.5.16, 10.6.8, 10.7.4, 10.8.3

Type: Bug Priority: Critical
Reporter: Igor Assignee: Alexander Barkov
Resolution: Fixed Votes: 1
Labels: None
Environment:

Ubuntu 18.04

dpkg -l | grep maria
ii libmariadb3:amd64 1:10.3.20+maria~bionic amd64 MariaDB database client library
ii mariadb-backup 1:10.3.20+maria~bionic amd64 Backup tool for MariaDB server
ii mariadb-client-10.3 1:10.3.20+maria~bionic amd64 MariaDB database client binaries
ii mariadb-client-core-10.3 1:10.3.20+maria~bionic amd64 MariaDB database core client binaries
ii mariadb-common 1:10.3.20+maria~bionic all MariaDB database common files (e.g. /etc/mysql/conf.d/mariadb.cnf)
ii mariadb-server-10.3 1:10.3.20+maria~bionic amd64 MariaDB database server binaries
ii mariadb-server-core-10.3 1:10.3.20+maria~bionic amd64 MariaDB database core server files
ii mysql-common 1:10.3.20+maria~bionic all MariaDB database common files (e.g. /etc/mysql/my.cnf)

Issue Links:
Relates
relates to MDEV-30666 Different GTID for the same binlog Fi... Closed

 Description   

I am running multi-source slave and trying to backup database with mariabackup.
mariabackup --compress --open-files-limit=9046 --slave-info --safe-slave-backup --safe-slave-backup-timeout=500 --backup --target-dir /backup/mysqld1/2019-11-12

But mariabackup does not detect multi-source slave configuration ( i don't have default_master_connection configured, only named connections)

[00] 2019-11-12 12:02:48 Failed to get master binlog coordinates from SHOW SLAVE STATUS.This means that the server is not a replication slave. Ignoring the --slave-info option

[00] 2019-11-12 12:02:48 Compressing xtrabackup_binlog_info
[00] 2019-11-12 12:02:48 ...done
[00] 2019-11-12 12:02:48 Executing FLUSH NO_WRITE_TO_BINLOG ENGINE LOGS...
[00] 2019-11-12 12:02:48 mariabackup: The latest check point (for incremental): '587720589969'
mariabackup: Stopping log copying thread.[00] 2019-11-12 12:02:48 >> log scanned up to (587723317367)

[00] 2019-11-12 12:02:48 >> log scanned up to (587723317367)
[00] 2019-11-12 12:02:48 Executing UNLOCK TABLES
[00] 2019-11-12 12:02:48 All tables unlocked

 Comments   
Comment by Vladislav Vaintroub [ 2021-04-02 ]

greenny380, what is the actual problem? Is backup functionality affected in any way?

Comment by Alexander Barkov [ 2022-04-19 ]

Elkin, please review a patch for this bug.
https://github.com/MariaDB/server/commit/b8dc32c9fecd9e9decbfd9bea7682a20bb164dae

Comment by Alexander Barkov [ 2022-04-25 ]

Hello Elkin, please review an updated patch:

https://github.com/MariaDB/server/commit/40a5962a89139bd081c8e6221158156dd4554128

Thanks.

Generated at Thu Feb 08 09:04:07 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.