[MDEV-25978] rsync SST does not work with custom binlog name - Jira

XML

Word

Printable

Details

Type: Bug
Status: Closed (View Workflow)
Priority: Blocker
Resolution: Fixed
Affects Version/s: 10.6.2, 10.2(EOL), 10.3(EOL), 10.4(EOL), 10.5(EOL)
Fix Version/s: 10.2.39, 10.3.30, 10.4.20, 10.5.11, 10.6.3
Component/s: Galera SST
Labels:
None

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

Attachments

Issue Links

relates to

MDEV-26201 MariaDB 10.5.11 cannot do SST when binary log is enabled on donor

Closed

Activity

People

Assignee:: Jan Lindström (Inactive)

Reporter:: Ramesh Sivaraman

Votes:: 0 Vote for this issue

Watchers:: 2 Start watching this issue

Dates

Created:: 2021-06-21 14:09

Updated:: 2022-04-11 23:25

Resolved:: 2021-06-23 10:50

Git Integration

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