[MDEV-26201] MariaDB 10.5.11 cannot do SST when binary log is enabled on donor Created: 2021-07-21  Updated: 2022-04-11  Resolved: 2022-04-11

Status: Closed
Project: MariaDB Server
Component/s: Galera SST
Affects Version/s: 10.5.11, 10.9.0, 10.2.43, 10.3.34, 10.4.24, 10.6.7, 10.7.3, 10.8.2
Fix Version/s: 10.2.44, 10.3.35, 10.4.25, 10.5.16, 10.6.8, 10.7.4, 10.8.3, 10.9.1

Type: Bug Priority: Critical
Reporter: Oli Sennhauser Assignee: Julius Goryavsky
Resolution: Fixed Votes: 0
Labels: None
Environment:

Debian 10


Issue Links:
Relates
relates to MDEV-25978 rsync SST does not work with custom b... Closed
relates to MDEV-27524 Incorrect binlogs after Galera SST us... Closed

 Description   

If we do a SST on Debian 10 from a donor with binary logging DISABLED SST works without problems.
If we do a SST on Debian 10 from the same donor with binary logging ENABLED SST fails with error (on donor)
:
tail: cannot open 'mysql-bin.index' for reading: No such file or directory
[ERROR] WSREP: Failed to read from: wsrep_sst_rsync --role 'donor' --address '188.34.159.129:4444/rsync_sst' --local-port '3306' --socket '/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --gtid 'eb3f6b4b-ea20-11eb-83bb-86bdcfe45310:25' --gtid-domain-id '0' --binlog 'binary-log' --mysqld-args --wsrep-new-cluster --wsrep_start_position=eb3f6b4b-ea20-11eb-83bb-86bdcfe45310:1
[ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'donor' --address '188.34.159.129:4444/rsync_sst' --local-port '3306' --socket '/run/mysqld/mysqld.sock' --datadir '/var/lib/mysql/' --gtid 'eb3f6b4b-ea20-11eb-83bb-86bdcfe45310:25' --gtid-domain-id '0' --binlog 'binary-log' --mysqld-args --wsrep-new-cluster --wsrep_start_position=eb3f6b4b-ea20-11eb-83bb-86bdcfe45310:1: 1 (Operation not permitted)

We tried to disable apparmor but it did not change anything...



 Comments   
Comment by Oli Sennhauser [ 2021-07-21 ]

Possibly caused or related to https://jira.mariadb.org/browse/MDEV-25978

Comment by Julius Goryavsky [ 2022-04-11 ]

Partially fixed in MDEV-25978 and finally fixed (for any --binlog value, including with path) in the MDEV-27524

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