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

rpl.rpl_parallel_multi_domain_xa slave_parallel_mode=optimistic sync_with_master_gtid timeout >900 seconds

    XMLWordPrintable

Details

    Description

      rpl.rpl_parallel_multi_domain_xa, in any of the combinations of mix, stmt or row, times out after 900 seconds.

      Example failure:

      https://buildbot.mariadb.org/#/builders/75/builds/43350

      rpl.rpl_parallel_multi_domain_xa 'mix'   w12 [ fail ]  timeout after 900 seconds
              Test ended at 2025-09-15 06:36:52
       
      Test case timeout after 900 seconds
       
      == /home/buildbot/aarch64-rhel-8/build/mysql-test/var/12/log/rpl_parallel_multi_domain_xa.log == 
      SET @old_parallel_threads                    = @@GLOBAL.slave_parallel_threads;
      SET @old_slave_domain_parallel_threads       = @@GLOBAL.slave_domain_parallel_threads;
      SET @@global.slave_parallel_threads          = 5;
      SET @@global.slave_domain_parallel_threads = 3;
      SET @old_parallel_mode               = @@GLOBAL.slave_parallel_mode;
      CHANGE MASTER TO master_use_gtid=slave_pos;
      connection master;
      CREATE TABLE t1 (a int PRIMARY KEY, b INT) ENGINE=InnoDB;
      INSERT INTO t1 VALUES (1, 0);
      include/save_master_gtid.inc
      connection slave;
      include/start_slave.inc
      include/sync_with_master_gtid.inc
      include/stop_slave.inc
      SET @@global.slave_parallel_mode     ='optimistic';
      connection master;
      include/save_master_gtid.inc
      connection slave;
      include/start_slave.inc
      include/sync_with_master_gtid.inc
       
       == /home/buildbot/aarch64-rhel-8/build/mysql-test/var/12/tmp/analyze-timeout-mysqld.1.err ==
      mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local server through socket '/home/buildbot/aarch64-rhel-8/build/mysql-test/var/tmp/12/mysqld' (111)
      

      Successful test have been seen running in 100 seconds.

      10.6 version of this failure ends like

      rpl.rpl_parallel_multi_domain_xa 'innodb,stmt' w8 [ fail ]
              Test ended at 2024-04-17 14:42:47
       
      CURRENT_TEST: rpl.rpl_parallel_multi_domain_xa
      mysqltest: In included file "./include/sync_with_master_gtid.inc": 
      included from /home/buildbot/amd64-ubuntu-2204-debug-ps/build/mysql-test/suite/rpl/t/rpl_parallel_multi_domain_xa.test at line 85:
      At line 45: Failed to sync with master
       
      The result from queries just before the failure was:
      < snip >
      SET @old_slave_domain_parallel_threads       = @@GLOBAL.slave_domain_parallel_threads;
      SET @@global.slave_parallel_threads          = 5;
      SET @@global.slave_domain_parallel_threads = 3;
      SET @old_parallel_mode               = @@GLOBAL.slave_parallel_mode;
      CHANGE MASTER TO master_use_gtid=slave_pos;
      connection master;
      CREATE TABLE t1 (a int PRIMARY KEY, b INT) ENGINE=InnoDB;
      INSERT INTO t1 VALUES (1, 0);
      include/save_master_gtid.inc
      connection slave;
      include/start_slave.inc
      include/sync_with_master_gtid.inc
      include/stop_slave.inc
      SET @@global.slave_parallel_mode     ='optimistic';
      connection master;
      include/save_master_gtid.inc
      connection slave;
      include/start_slave.inc
      include/sync_with_master_gtid.inc
      Timeout in master_gtid_wait('0-1-523,1-1-518,2-1-518', 120), current slave GTID position is: 0-1-229,1-1-222,2-1-222.
      

      Didn't appear in 11.4+

      Attachments

        Issue Links

          Activity

            People

              Unassigned Unassigned
              danblack Daniel Black
              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.