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

rpl.rpl_heartbeat can fail when (BB) mtr reorders tests

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.11, 11.0(EOL), 11.1(EOL), 11.2, 11.4
    • None
    • Tests
    • None

    Description

      The test fails like

      rpl.rpl_heartbeat                        w8 [ fail ]
              Test ended at 2024-04-29 19:24:42
       
      CURRENT_TEST: rpl.rpl_heartbeat
      analyze: sync_with_master
      Slave position:  file:   position: 4
      Master position: file: master-bin.000001  position: 640
      mysqltest: At line 119: sync_slave_with_master failed: 'select master_pos_wait('master-bin.000001', 640, 300, '')' returned -1 indicating timeout after 300 seconds
       
      The result from queries just before the failure was:
      < snip >
      Value	5.001
      reset slave;
      set @@global.slave_net_timeout= 5;
      change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root', master_heartbeat_period= 4;
      show status like 'Slave_heartbeat_period';;
      Variable_name	Slave_heartbeat_period
      Value	4.000
      set @@global.slave_net_timeout= 3 /* must be a warning */;
      reset slave;
      connection master;
      drop table if exists t1;
      connection slave;
      set @@global.slave_net_timeout= 10;
      change master to master_host='127.0.0.1',master_port=MASTER_PORT, master_user='root', master_ssl_verify_server_cert=0, master_heartbeat_period= 0.5;
      show status like 'Slave_heartbeat_period';;
      Variable_name	Slave_heartbeat_period
      Value	0.500
      start slave;
      connection master;
      create table t1 (f1 int);
      
      

      and with the slave error

      Last_IO_Error	Got fatal error 1236 from master when reading data from binary log: 'Error: connecting slave requested to start from GTID 0-1-3, which is not in the master's binlog'
      
      

      when a prior test, e.g rpl.rpl_gtid_misc, does not require the slave server restart and
      the early test leave a non-empty GTID state.

      rpl.rpl_heartbeat turns out to miss a standard include/master-slave header.
      That needs fixing.

      Attachments

        Activity

          People

            Unassigned Unassigned
            Elkin Andrei Elkin
            Votes:
            0 Vote for this issue
            Watchers:
            1 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.