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

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

            angelique.sklavounos Angelique Sklavounos (Inactive) created issue -
            angelique.sklavounos Angelique Sklavounos (Inactive) made changes -
            Field Original Value New Value
            Component/s Replication [ 10100 ]
            Component/s Tests [ 10800 ]
            angelique.sklavounos Angelique Sklavounos (Inactive) made changes -
            Description The test occasionally fails with:
            {noformat:title=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;
            {noformat}
            https://buildbot.mariadb.org/#/builders/192/builds/10092

            The test occasionally fails with:
            {noformat:title=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;
            {noformat}
            serg Sergei Golubchik made changes -
            Priority Major [ 3 ] Critical [ 2 ]
            serg Sergei Golubchik made changes -
            Assignee Andrei Elkin [ elkin ]
            serg Sergei Golubchik made changes -
            Fix Version/s 10.3 [ 22126 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Fix Version/s 10.7 [ 24805 ]
            Fix Version/s 10.8 [ 26121 ]
            Elkin Andrei Elkin made changes -
            Assignee Andrei Elkin [ elkin ] Brandon Nesterenko [ JIRAUSER48702 ]
            bnestere Brandon Nesterenko made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            bnestere Brandon Nesterenko made changes -
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.7 [ 24805 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.3 [ 22126 ]
            julien.fritsch Julien Fritsch made changes -
            Fix Version/s 10.8 [ 26121 ]
            knielsen Kristian Nielsen made changes -
            Assignee Brandon Nesterenko [ JIRAUSER48702 ] Kristian Nielsen [ knielsen ]
            knielsen Kristian Nielsen made changes -
            knielsen Kristian Nielsen made changes -
            Attachment mdev28776_reproduce.patch [ 71022 ]
            knielsen Kristian Nielsen made changes -
            Fix Version/s 10.4.32 [ 29300 ]
            Fix Version/s 10.4 [ 22408 ]
            Fix Version/s 10.5 [ 23123 ]
            Fix Version/s 10.6 [ 24028 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            Elkin Andrei Elkin made changes -
            Fix Version/s 10.5.23 [ 29012 ]
            Fix Version/s 10.6.16 [ 29014 ]
            Fix Version/s 10.10.7 [ 29018 ]
            Fix Version/s 10.11.6 [ 29020 ]
            Fix Version/s 11.0.4 [ 29021 ]
            Fix Version/s 10.9.8 [ 29015 ]

            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.