Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-25978

rsync SST does not work with custom binlog name

    XMLWordPrintable

    Details

      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

          Activity

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            ramesh Ramesh Sivaraman
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Git Integration