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

relay log nums diff

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 10.11.15
    • N/A
    • Replication
    • None
    • Not for Release Notes

    Description

      before flush add sleep relay log num will be diff

      relay_log_num.test

      --source include/have_innodb.inc
      – source include/have_binlog_format_row.inc
      --source include/master-slave.inc

      --enable_connect_log
      --connection server_2
      --let $datadir = `select @@datadir`
      set global relay_log_purge=OFF;
      --source include/stop_slave.inc
      CHANGE MASTER TO master_use_gtid=current_pos;
      --source include/start_slave.inc
      flush relay logs;
      --cat_file $datadir/slave-relay-bin.index

      --connection server_1
      --source include/rpl_end.inc
      relay_log_num.result

      include/master-slave.inc
      [connection master]
      connection server_2;
      set global relay_log_purge=OFF;
      include/stop_slave.inc
      CHANGE MASTER TO master_use_gtid=current_pos;
      include/start_slave.inc
      flush relay logs;
      ./slave-relay-bin.000001
      ./slave-relay-bin.000002
      connection server_1;
      include/rpl_end.inc
      relay_log_num_with_sleep.test

      --source include/have_innodb.inc
      – source include/have_binlog_format_row.inc
      --source include/master-slave.inc

      --enable_connect_log
      --connection server_2
      --let $datadir = `select @@datadir`
      set global relay_log_purge=OFF;
      --source include/stop_slave.inc
      CHANGE MASTER TO master_use_gtid=current_pos;
      --source include/start_slave.inc
      --sleep 3
      flush relay logs;
      --cat_file $datadir/slave-relay-bin.index

      --connection server_1
      --source include/rpl_end.inc

      relay_log_num_with_sleep.result

      include/master-slave.inc
      [connection master]
      connection server_2;
      set global relay_log_purge=OFF;
      include/stop_slave.inc
      CHANGE MASTER TO master_use_gtid=current_pos;
      include/start_slave.inc
      flush relay logs;
      ./slave-relay-bin.000001
      ./slave-relay-bin.000002
      ./slave-relay-bin.000003
      connection server_1;
      include/rpl_end.inc

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              ohye3188 小舟从此逝
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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