[MDEV-21037] mariabackup does not detect multi-source replication slave - Jira

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Critical
Resolution: Fixed
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
Component/s: Backup, mariabackup
Labels:
None
Environment:

Hide
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)

Show
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)

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

Attachments

Issue Links

relates to

MDEV-30666 Different GTID for the same binlog File + Position (xtrabackup_binlog_info vs binlog_gtid_pos)

Closed

Activity

Ascending order - Click to sort in descending order

Vladislav Vaintroub added a comment - 2021-04-02 18:23

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

Vladislav Vaintroub added a comment - 2021-04-02 18:23 greenny380 , what is the actual problem? Is backup functionality affected in any way?

Alexander Barkov added a comment - 2022-04-19 08:29

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

Alexander Barkov added a comment - 2022-04-19 08:29 Elkin , please review a patch for this bug. https://github.com/MariaDB/server/commit/b8dc32c9fecd9e9decbfd9bea7682a20bb164dae

Alexander Barkov added a comment - 2022-04-25 04:11

Hello Elkin, please review an updated patch:

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

Thanks.

Alexander Barkov added a comment - 2022-04-25 04:11 Hello Elkin , please review an updated patch: https://github.com/MariaDB/server/commit/40a5962a89139bd081c8e6221158156dd4554128 Thanks.

People

Assignee:: Alexander Barkov

Reporter:: Igor

Votes:: 1 Vote for this issue

Watchers:: 7 Start watching this issue

Dates

Created:: 2019-11-12 14:16

Updated:: 2024-07-07 22:32

Resolved:: 2022-04-25 12:03

Git Integration

Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.

MariaDB Server