[MDEV-25978] rsync SST does not work with custom binlog name Created: 2021-06-21  Updated: 2022-04-11  Resolved: 2021-06-23

Status: Closed
Project: MariaDB Server
Component/s: Galera SST
Affects Version/s: 10.6.2, 10.2, 10.3, 10.4, 10.5
Fix Version/s: 10.2.39, 10.3.30, 10.4.20, 10.5.11, 10.6.3

Type: Bug Priority: Blocker
Reporter: Ramesh Sivaraman Assignee: Jan Lindström (Inactive)
Resolution: Fixed Votes: 0
Labels: None

Issue Links:
Relates
relates to MDEV-26201 MariaDB 10.5.11 cannot do SST when bi... Closed

 Description   

rsync SST does not work with custom binlog name. The rsync sst script attempts to copy the default binlog index name instead of the custom name.

10.6.2 da65cb4d97fbd55411dd08108ecc2cf72712851d (Debug)

 
 
 
2021-06-21 16:42:06 2 [Note] WSREP: server galapq state change: synced -> donor
 
2021-06-21 16:42:06 2 [Note] WSREP: Server status change synced -> donor
 
2021-06-21 16:42:06 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
 
2021-06-21 16:42:06 2 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
 
2021-06-21 16:42:06 0 [Note] WSREP: async IST sender starting to serve tcp://127.0.0.1:20624 sending 2-2, preload starts from 2
 
2021-06-21 16:42:06 0 [Note] WSREP: IST sender 2 -> 2
 
2021-06-21 16:42:06 0 [Note] WSREP: Donor monitor thread started to monitor
 
2021-06-21 16:42:06 0 [Note] WSREP: Running: 'wsrep_sst_rsync --role 'donor' --address '127.0.0.1:14721/rsync_sst' --local-port '36982' --socket '/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/node1/node1_socket.sock' --datadir '/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/node1/' --defaults-file '/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/n1.cnf' --gtid '760bdf6e-d296-11eb-adf1-3317e07183c4:2' --gtid-domain-id '0' --binlog 'binlog' --mysqld-args --defaults-file=/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/n1.cnf --wsrep-new-cluster'
 
2021-06-21 16:42:06 2 [Note] WSREP: sst_donor_thread signaled with 0
 
2021-06-21 16:42:06 0 [Note] WSREP: Flushing tables for SST...
 
2021-06-21 16:42:06 0 [Note] WSREP: pause
 
2021-06-21 16:42:06 0 [Note] WSREP: Provider paused at 760bdf6e-d296-11eb-adf1-3317e07183c4:2 (5)
 
2021-06-21 16:42:06 0 [Note] WSREP: Server paused at: 2
 
2021-06-21 16:42:06 0 [Note] WSREP: MYSQL_BIN_LOG::open(): Adding new xid_list_entry for binlog.000002 (2)
 
2021-06-21 16:42:06 3 [Note] WSREP: TC_LOG_BINLOG::mark_xid_done(): Removing xid_list_entry for binlog.000001 (1)
 
2021-06-21 16:42:06 0 [Note] WSREP: Tables flushed.
 
tail: cannot open 'mysql-bin.index' for reading: No such file or directory
 
2021-06-21 16:42:06 0 [ERROR] WSREP: Failed to read from: wsrep_sst_rsync --role 'donor' --address '127.0.0.1:14721/rsync_sst' --local-port '36982' --socket '/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/node1/node1_socket.sock' --datadir '/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/node1/' --defaults-file '/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/n1.cnf' --gtid '760bdf6e-d296-11eb-adf1-3317e07183c4:2' --gtid-domain-id '0' --binlog 'binlog' --mysqld-args --defaults-file=/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/n1.cnf --wsrep-new-cluster
 
2021-06-21 16:42:06 0 [ERROR] WSREP: Process completed with error: wsrep_sst_rsync --role 'donor' --address '127.0.0.1:14721/rsync_sst' --local-port '36982' --socket '/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/node1/node1_socket.sock' --datadir '/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/node1/' --defaults-file '/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/n1.cnf' --gtid '760bdf6e-d296-11eb-adf1-3317e07183c4:2' --gtid-domain-id '0' --binlog 'binlog' --mysqld-args --defaults-file=/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/n1.cnf --wsrep-new-cluster: 1 (Operation not permitted)
 
2021-06-21 16:42:06 0 [Note] WSREP: resume
 
2021-06-21 16:42:06 0 [Note] WSREP: resuming provider at 5
 
2021-06-21 16:42:06 0 [Note] WSREP: Provider resumed.
 
2021-06-21 16:42:06 0 [Note] WSREP: SST sending failed: -1
 
2021-06-21 16:42:06 0 [Note] WSREP: server galapq state change: donor -> joined
 
2021-06-21 16:42:06 0 [Note] WSREP: Server status change donor -> joined
 
2021-06-21 16:42:06 0 [Note] WSREP: wsrep_notify_cmd is not defined, skipping notification.
 
2021-06-21 16:42:06 0 [ERROR] WSREP: Command did not run: wsrep_sst_rsync --role 'donor' --address '127.0.0.1:14721/rsync_sst' --local-port '36982' --socket '/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/node1/node1_socket.sock' --datadir '/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/node1/' --defaults-file '/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/n1.cnf' --gtid '760bdf6e-d296-11eb-adf1-3317e07183c4:2' --gtid-domain-id '0' --binlog 'binlog' --mysqld-args --defaults-file=/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/n1.cnf --wsrep-new-cluster
 
2021-06-21 16:42:06 0 [Note] WSREP: Donor monitor thread ended with total time 0 sec

n1.cnf

10.6.2 da65cb4d97fbd55411dd08108ecc2cf72712851d (Debug)

 
[mysqld]
 
gtid_strict_mode=1
 
log_slave_updates=ON
 
log_bin=binlog
 
wsrep_cluster_address=gcomm://127.0.0.1:14411,127.0.0.1:11736,
 
wsrep_provider_options="gmcast.listen_addr=tcp://127.0.0.1:14411;ist.recv_addr=127.0.0.1:19236;"
 
tmpdir=/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/tmp1
 
socket=/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/node1/node1_socket.sock
 
datadir=/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/node1
 
port=36982
 
log-error=/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/node1/node1.err
 
wsrep_sst_receive_address=127.0.0.1:19650
 
wsrep_node_address=127.0.0.1
 
wsrep_node_incoming_address=127.0.0.1
 
server-id=101
 
basedir=/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg
 
wsrep-debug=1
 
innodb_file_per_table
 
innodb_autoinc_lock_mode=2
 
wsrep-provider=/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/lib/libgalera_smm.so
 
wsrep_sst_method=rsync
 
wsrep_sst_auth=root:
 
binlog_format=ROW
 
core-file
 
log-output=none
 
wsrep_slave_threads=2
 
wsrep_on=1

n2.cnf

10.6.2 da65cb4d97fbd55411dd08108ecc2cf72712851d (Debug)

 
[mysqld]
 
gtid_strict_mode=1
 
log_slave_updates=ON
 
log_bin=binlog
 
wsrep_cluster_address=gcomm://127.0.0.1:14411,127.0.0.1:11736,
 
wsrep_provider_options="gmcast.listen_addr=tcp://127.0.0.1:11736;ist.recv_addr=127.0.0.1:20624;"
 
tmpdir=/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/tmp2
 
socket=/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/node2/node2_socket.sock
 
datadir=/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/node2
 
port=40374
 
log-error=/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/node2/node2.err
 
wsrep_sst_receive_address=127.0.0.1:14721
 
wsrep_node_address=127.0.0.1
 
wsrep_node_incoming_address=127.0.0.1
 
server-id=102
 
basedir=/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg
 
wsrep-debug=1
 
innodb_file_per_table
 
innodb_autoinc_lock_mode=2
 
wsrep-provider=/test/GAL_MD170621-mariadb-10.6.2-linux-x86_64-dbg/lib/libgalera_smm.so
 
wsrep_sst_method=rsync
 
wsrep_sst_auth=root:
 
binlog_format=ROW
 
core-file
 
log-output=none
 
wsrep_slave_threads=2
 
wsrep_on=1



 Comments   
Comment by Jan Lindström (Inactive) [ 2021-06-23 ]

To help merge 10.4 version: https://github.com/MariaDB/server/commit/da83af8bbe8709793b5ea56700a4dd2228ee6196 (later versions should be trivial)

Comment by Jan Lindström (Inactive) [ 2021-06-23 ]

Added test cases, 10.4 version as there is difference on result set, bb check.

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