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

Unable to change persistently slave_parallel_mode

    XMLWordPrintable

Details

    • Bug
    • Status: Confirmed (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.3, 10.4, 10.5, 10.6, 10.7, 10.8, 10.9, 10.10
    • 10.4, 10.5, 10.6
    • Replication
    • None
    • RHEL 8.6

    Description

      After updating MariaDB 10.4 to 10.5 there are lots of retried transaction(few thousand per hour) and lags in replication, switching slave_parallel_mode from optimistic back to conservative as was default on MariaDB 10.4 helps.

      I stop replication change every slave connection to "conservative" and start, also change server global variable slave_parallel_mode to "conservative" and add "slave_parallel_mode = conservative" to my.cnf but after server restart all conection are again in "optimistic" mode global variable is correctly set to "conservative".

      MTR test case and cnf

      --source include/not_embedded.inc
       
      --connect (slave1,127.0.0.1,root,,,$SERVER_MYPORT_3)
      --connect (master1,127.0.0.1,root,,,$SERVER_MYPORT_1)
      --connect (master2,127.0.0.1,root,,,$SERVER_MYPORT_2)
       
      --connection slave1
      --replace_result $SERVER_MYPORT_1 MYPORT_1
      eval CHANGE MASTER 'x1' TO master_port=$SERVER_MYPORT_1, master_host='127.0.0.1', master_user='root';
      eval CHANGE MASTER '' TO master_port=$SERVER_MYPORT_2, master_host='127.0.0.1', master_user='root';
       
      set default_master_connection = '';
      --source include/start_slave.inc
      --let $status_items= Parallel_Mode
      # will show minimal
      --source include/show_slave_status.inc
       
      set default_master_connection = 'x1';
      --source include/start_slave.inc
      --let $status_items= Parallel_Mode
      # should be minimal, but shows optimistic (>=10.5) or conservative (<10.5)
      --source include/show_slave_status.inc
       
      --source include/reset_master_slave.inc
      --disconnect slave1
       
      --connection master1
      --source include/reset_master_slave.inc
      --disconnect master1
       
      --connection master2
      --source include/reset_master_slave.inc
      --disconnect master2
      

      !include my.cnf
       
      [mysqld.3]
      slave_parallel_mode=minimal
      

      Attachments

        1. mdev29419.cnf
          0.1 kB
        2. mdev29419.result
          0.7 kB
        3. mdev29419.test
          1 kB
        4. variables.txt
          81 kB

        Activity

          People

            bnestere Brandon Nesterenko
            lathander Jozef Kováč
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.