[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

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

Igor created issue - 2019-11-12 14:16

Elena Stepanova made changes - 2019-11-18 22:12

Field	Original Value	New Value
Component/s		mariabackup [ 14500 ]
Fix Version/s		10.3 [ 22126 ]
Assignee		Vladislav Lesin [ vlad.lesin ]

Julien Fritsch made changes - 2021-03-15 08:38

Priority

Major [ 3 ]

Critical [ 2 ]

Julien Fritsch made changes - 2021-03-23 13:58

Assignee

Vladislav Lesin [ vlad.lesin ]

Sergei Golubchik [ serg ]

Julien Fritsch made changes - 2021-04-02 13:38

Assignee

Sergei Golubchik [ serg ]

Vladislav Vaintroub [ wlad ]

Vladislav Vaintroub made changes - 2021-04-02 18:23

Priority

Critical [ 2 ]

Major [ 3 ]

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?

Vladislav Vaintroub made changes - 2021-04-02 18:24

Labels

need_feedback

Julien Fritsch made changes - 2021-04-06 11:34

Priority

Major [ 3 ]

Critical [ 2 ]

Vladislav Vaintroub made changes - 2021-04-13 10:48

Status

Open [ 1 ]

In Progress [ 3 ]

Julien Fritsch made changes - 2021-05-07 09:55

Labels

need_feedback

Sergei Golubchik made changes - 2021-10-08 08:01

Assignee

Vladislav Vaintroub [ wlad ]

Alexander Barkov [ bar ]

Sergei Golubchik made changes - 2021-12-06 21:36

Workflow

MariaDB v3 [ 101074 ]

MariaDB v4 [ 144528 ]

Alexander Barkov made changes - 2022-04-14 09:05

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 detects 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

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

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 made changes - 2022-04-19 08:29

Assignee	Alexander Barkov [ bar ]	Andrei Elkin [ elkin ]
Status	In Progress [ 3 ]	In Review [ 10002 ]

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.

Alexander Barkov made changes - 2022-04-25 12:01

Assignee

Andrei Elkin [ elkin ]

Alexander Barkov [ bar ]

Alexander Barkov made changes - 2022-04-25 12:01

Status

In Review [ 10002 ]

Stalled [ 10000 ]

Alexander Barkov made changes - 2022-04-25 12:02

Fix Version/s		10.2.44 [ 27514 ]
Fix Version/s		10.3.35 [ 27512 ]
Fix Version/s		10.4.25 [ 27510 ]
Fix Version/s		10.5.16 [ 27508 ]
Fix Version/s		10.6.8 [ 27506 ]
Fix Version/s		10.7.4 [ 27504 ]
Fix Version/s		10.8.3 [ 27502 ]
Fix Version/s	10.3 [ 22126 ]

Alexander Barkov made changes - 2022-04-25 12:03

Resolution		Fixed [ 1 ]
Status	Stalled [ 10000 ]	Closed [ 6 ]

Julius Goryavsky made changes - 2023-03-17 11:05

Link

This issue relates to ~~MDEV-30666~~ [ ~~MDEV-30666~~ ]

Jira Automation (IT) made changes - 2024-07-04 03:20

Zendesk Related Tickets

198750 107893

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

Details

Description

Attachments

Issue Links

Activity

People

Dates

Git Integration