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

Exec_master_log_pos not updated at log rotate in parallel replication

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.0.9
    • 10.0.11
    • None

    Description

      It appears that Exec_master_log_pos is not correctly updated after a log
      rotate when parallel replication is used.

      Here is a test case:

      --let $rpl_topology=1->2
      --source include/rpl_init.inc
       
      --connection server_2
      SET @old_parallel_threads=@@GLOBAL.slave_parallel_threads;
      --source include/stop_slave.inc
      SET GLOBAL slave_parallel_threads=1;
      --source include/start_slave.inc
       
      --connection server_1
      CREATE TABLE t1 (a INT PRIMARY KEY, b INT);
      INSERT INTO t1 VALUES (1,1);
      INSERT INTO t1 VALUES (2,2), (3,8);
      INSERT INTO t1 VALUES (4,16);
      --save_master_pos
       
      --connection server_2
      --sync_with_master
      --let $status_items= Master_Log_File,Read_Master_Log_Pos,Relay_Log_File,Relay_Log_Pos,Relay_Master_Log_File,Exec_Master_Log_Pos
      --source include/show_slave_status.inc
       
      --connection server_1
      FLUSH LOGS;
      --save_master_pos
       
      --connection server_2
      --sync_with_master
      # exec_master_log_pos is not updated here by the format description event execution
      --source include/show_slave_status.inc
       
      --connection server_1
      UPDATE t1 SET b=b*b;
      --save_master_pos
       
      --connection server_2
      --sync_with_master
      # it's not even updated with the UPDATE statement.
      --source include/show_slave_status.inc
       
       
      --connection server_2
      --source include/stop_slave.inc
      SET GLOBAL slave_parallel_threads=@old_parallel_threads;
      --source include/start_slave.inc
       
      --connection server_1
      DROP TABLE t1;
       
      --source include/rpl_end.inc

      Attachments

        Activity

          knielsen Kristian Nielsen created issue -
          knielsen Kristian Nielsen made changes -
          Field Original Value New Value
          Status Open [ 1 ] In Progress [ 3 ]

          Pushed to 10.0

          knielsen Kristian Nielsen added a comment - Pushed to 10.0
          knielsen Kristian Nielsen made changes -
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]

          Re-opening for a minute to amend the 'Fix version' field

          elenst Elena Stepanova added a comment - Re-opening for a minute to amend the 'Fix version' field
          elenst Elena Stepanova made changes -
          Resolution Fixed [ 1 ]
          Status Closed [ 6 ] Reopened [ 4 ]
          elenst Elena Stepanova made changes -
          Fix Version/s 10.0.11 [ 15200 ]
          elenst Elena Stepanova made changes -
          Resolution Fixed [ 1 ]
          Status Reopened [ 4 ] Closed [ 6 ]
          serg Sergei Golubchik made changes -
          Workflow defaullt [ 37002 ] MariaDB v2 [ 43690 ]
          ratzpo Rasmus Johansson (Inactive) made changes -
          Workflow MariaDB v2 [ 43690 ] MariaDB v3 [ 62846 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 62846 ] MariaDB v4 [ 147688 ]

          People

            knielsen Kristian Nielsen
            knielsen Kristian Nielsen
            Votes:
            0 Vote for this issue
            Watchers:
            3 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.