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

        • Type: Bug
        • Status: Closed
        • Priority: Major
        • Resolution: Fixed
        • Affects Version/s: 10.0.9
        • Fix Version/s: 10.0.11
        • Component/s: None
        • Labels:

          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

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                knielsen Kristian Nielsen added a comment -

                Pushed to 10.0

                Show
                knielsen Kristian Nielsen added a comment - Pushed to 10.0
                Hide
                Permalink
                elenst Elena Stepanova added a comment -

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

                Show
                elenst Elena Stepanova added a comment - Re-opening for a minute to amend the 'Fix version' field

                  People

                  • Assignee:
                    knielsen Kristian Nielsen
                    Reporter:
                    knielsen Kristian Nielsen
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    3 Start watching this issue

                    Dates

                    • Created:
                      Updated:
                      Resolved: