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

rpl.rpl_delayed_parallel_slave_sbm sometimes fails with Seconds_Behind_Master should not have used second transaction timestamp

Details

    Description

      https://buildbot.mariadb.net/buildbot/builders/kvm-fulltest2/builds/39795

      10.7 bc656c4fa

      rpl.rpl_delayed_parallel_slave_sbm 'row' w3 [ fail ]
              Test ended at 2023-02-07 10:31:30
       
      CURRENT_TEST: rpl.rpl_delayed_parallel_slave_sbm
      mysqltest: At line 102: Seconds_Behind_Master should not have used second transaction timestamp
       
      The result from queries just before the failure was:
      < snip >
      connection slave;
      UNLOCK TABLES;
      include/sync_with_master_gtid.inc
      #
      # Pt 2) If the SQL thread has not entered an idle state, ensure
      # following events do not update SBM
      # Stop slave IO thread so it receives both events together on restart
      connection slave;
      include/stop_slave_io.inc
      connection master;
      # Sleep 2 to allow a buffer between events for SBM check
      insert into t1 values (1);
      # Sleep 3 to create gap between events
      insert into t1 values (2);
      connection slave;
      LOCK TABLES t1 WRITE;
      START SLAVE IO_THREAD;
      # Wait for first transaction to complete SQL delay and begin execution..
      # Validate SBM calculation doesn't use the second transaction because SQL thread shouldn't have gone idle..
      # SBM 0 was more recent than time since last transaction (1 seconds)
      

      Attachments

        Issue Links

          Activity

            angelique.sklavounos Angelique Sklavounos (Inactive) created issue -
            angelique.sklavounos Angelique Sklavounos (Inactive) made changes -
            Field Original Value New Value
            Assignee Angelique Sklavounos [ JIRAUSER50741 ]
            angelique.sklavounos Angelique Sklavounos (Inactive) made changes -
            Summary rpl.rpl_delayed_parallel_slave_sbm sometimes fails with Seconds_Behind_Master should not have used second transaction timestamp [Draft] rpl.rpl_delayed_parallel_slave_sbm sometimes fails with Seconds_Behind_Master should not have used second transaction timestamp
            angelique.sklavounos Angelique Sklavounos (Inactive) made changes -
            Affects Version/s 10.10 [ 27530 ]
            angelique.sklavounos Angelique Sklavounos (Inactive) made changes -
            angelique.sklavounos Angelique Sklavounos (Inactive) made changes -
            Assignee Angelique Sklavounos [ JIRAUSER50741 ] Brandon Nesterenko [ JIRAUSER48702 ]
            Summary [Draft] rpl.rpl_delayed_parallel_slave_sbm sometimes fails with Seconds_Behind_Master should not have used second transaction timestamp rpl.rpl_delayed_parallel_slave_sbm sometimes fails with Seconds_Behind_Master should not have used second transaction timestamp
            angelique.sklavounos Angelique Sklavounos (Inactive) made changes -
            bnestere Brandon Nesterenko 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 ]
            Fix Version/s 10.9 [ 26905 ]
            Fix Version/s 10.10 [ 27530 ]
            Fix Version/s 11.0 [ 28320 ]
            bnestere Brandon Nesterenko made changes -
            Status Open [ 1 ] In Progress [ 3 ]
            bnestere Brandon Nesterenko made changes -
            issue.field.resolutiondate 2023-02-09 21:36:14.0 2023-02-09 21:36:14.769
            bnestere Brandon Nesterenko made changes -
            Fix Version/s 10.4.29 [ 28510 ]
            Fix Version/s 10.5.20 [ 28512 ]
            Fix Version/s 10.6.13 [ 28514 ]
            Fix Version/s 10.8.8 [ 28518 ]
            Fix Version/s 10.9.6 [ 28520 ]
            Fix Version/s 10.10.4 [ 28522 ]
            Fix Version/s 10.11.3 [ 28524 ]
            Fix Version/s 11.0.1 [ 28548 ]
            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 ]
            Fix Version/s 10.9 [ 26905 ]
            Fix Version/s 10.10 [ 27530 ]
            Fix Version/s 11.0 [ 28320 ]
            Resolution Fixed [ 1 ]
            Status In Progress [ 3 ] Closed [ 6 ]
            bnestere Brandon Nesterenko made changes -

            People

              bnestere Brandon Nesterenko
              angelique.sklavounos Angelique Sklavounos (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              2 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.