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

relay log nums diff

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Minor
    • Resolution: Unresolved
    • 10.11.15
    • 10.11, 11.4
    • Replication
    • None

    Description

      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
      

      the result is 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
      

      there are 2 slave-relay-bin,however if add sleep before flush relay logs;,like 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
      

      there will be 3 slave-relay-bin,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
      

      it should be test in debug mode

      Attachments

        1. relay_log_num.result.txt
          0.3 kB
          小舟从此逝
        2. relay_log_num.test.txt
          0.5 kB
          小舟从此逝
        3. relay_log_num_with_sleep.result.txt
          0.3 kB
          小舟从此逝
        4. relay_log_num_with_sleep.test.txt
          0.5 kB
          小舟从此逝

        Issue Links

          Activity

            People

              susil.behera Susil Behera
              ohye3188 小舟从此逝
              Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

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