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

rpl.rpl_mark_optimize_tbl_ddl fails with timeout on sync_with_master

    XMLWordPrintable

Details

    Description

      https://buildbot.mariadb.org/#/builders/192/builds/10092

      The test occasionally fails with:

      10.5 22f935d6d

      rpl.rpl_mark_optimize_tbl_ddl 'innodb,mix' w6 [ fail ]
              Test ended at 2022-06-02 22:23:29
       
      CURRENT_TEST: rpl.rpl_mark_optimize_tbl_ddl
      analyze: sync_with_master
      mysqltest: At line 46: sync_with_master failed: 'select master_pos_wait('master-bin.000001', 1388, 300, '')' returned -1 indicating timeout after 300 seconds
       
      The result from queries just before the failure was:
      < snip >
      connection server_1;
      FLUSH TABLES;
      ALTER TABLE mysql.gtid_slave_pos ENGINE=InnoDB;
      connection server_2;
      SET @save_slave_parallel_threads= @@GLOBAL.slave_parallel_threads;
      SET @save_slave_parallel_mode= @@GLOBAL.slave_parallel_mode;
      include/stop_slave.inc
      SET GLOBAL slave_parallel_threads=2;
      SET GLOBAL slave_parallel_mode=optimistic;
      include/start_slave.inc
      connection server_1;
      CREATE TABLE t1(a INT) ENGINE=INNODB;
      OPTIMIZE TABLE t1;
      Table	Op	Msg_type	Msg_text
      test.t1	optimize	note	Table does not support optimize, doing recreate + analyze instead
      test.t1	optimize	status	OK
      INSERT INTO t1 VALUES(1);
      INSERT INTO t1  SELECT 1+a FROM t1;
      INSERT INTO t1  SELECT 2+a FROM t1;
      connection server_2;
      

      Attachments

        Issue Links

          Activity

            People

              knielsen Kristian Nielsen
              angelique.sklavounos Angelique Sklavounos (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              5 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.