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

rpl.rpl_mysqldump_gtid_slave_pos fails in buildbot

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.5, 10.6, 10.11, 11.2, 11.4, 11.6
    • 10.5
    • Replication, Tests
    • None

    Description

      The test rpl.rpl_mysqldump_gtid_slave_pos, added in MDEV-15393, fails somewhat frequently on buildbot with various failures. A few examples:

      rpl.rpl_mysqldump_gtid_slave_pos 'mix'   w4 [ fail ]
              Test ended at 2024-07-25 08:21:02
       
      CURRENT_TEST: rpl.rpl_mysqldump_gtid_slave_pos
      --- /usr/share/mysql-test/suite/rpl/r/rpl_mysqldump_gtid_slave_pos.result	2024-07-25 07:06:08.000000000 +0000
      +++ /dev/shm/var/4/log/rpl_mysqldump_gtid_slave_pos.reject	2024-07-25 08:21:01.514074976 +0000
      @@ -36,14 +36,9 @@
       select * from mysql.gtid_slave_pos;
       domain_id	sub_id	server_id	seq_no
       0	2	1	1
      -0	3	1	2
      -0	4	1	3
      -0	5	1	4
      -0	6	1	5
      -0	7	1	6
       select @@global.gtid_slave_pos as "after initial slave got in sync";
       after initial slave got in sync
      -0-1-6
      +0-1-1
       # 2.
       include/stop_slave.inc
       # 3. A
      @@ -63,15 +58,15 @@
       # 6.
       select * from mysql.gtid_slave_pos;
       domain_id	sub_id	server_id	seq_no
      -0	2	1	6
      +0	2	1	1
       select @@global.gtid_slave_pos as "after dump restore";
       after dump restore
      -0-1-6
      +0-1-1
       # 7.
       reset slave;
       select @@global.gtid_slave_pos;
       @@global.gtid_slave_pos
      -0-1-6
      +0-1-1
       change master to master_use_gtid=no;
       connection master;
       insert into t1 select 1+max(a),2 from t1;
      @@ -81,7 +76,7 @@
       include/sync_with_master_gtid.inc
       select * from mysql.gtid_slave_pos;
       domain_id	sub_id	server_id	seq_no
      -0	2	1	6
      +0	2	1	1
       0	3	1	1
       0	4	1	2
       0	5	1	3
      @@ -107,15 +102,15 @@
       # 6.
       select * from mysql.gtid_slave_pos;
       domain_id	sub_id	server_id	seq_no
      -0	2	1	6
      +0	2	2	2
       select @@global.gtid_slave_pos as "after dump restore";
       after dump restore
      -0-1-6
      +0-2-2
       # 7.
       reset slave;
       select @@global.gtid_slave_pos;
       @@global.gtid_slave_pos
      -0-1-6
      +0-2-2
       change master to master_use_gtid=no;
       connection master;
       insert into t1 select 1+max(a),1 from t1;
      @@ -125,7 +120,7 @@
       include/sync_with_master_gtid.inc
       select * from mysql.gtid_slave_pos;
       domain_id	sub_id	server_id	seq_no
      -0	2	1	6
      +0	2	2	2
       0	3	1	1
       0	4	1	2
       0	5	1	3
       
      Result length mismatch
      

      rpl.rpl_mysqldump_gtid_slave_pos 'stmt'  w2 [ fail ]  Found warnings/errors in server log file!
              Test ended at 2024-09-20 12:49:04
      line
      2024-09-20 12:49:00 268 [Warning] Master is configured to log replication events with checksum, but will not send such events to slaves that cannot process them
      ^ Found warnings in /run/shm/var/2/log/mysqld.1.err
      ok
       
       - saving '/run/shm/var/2/log/rpl.rpl_mysqldump_gtid_slave_pos-stmt/' to '/run/shm/var/log/rpl.rpl_mysqldump_gtid_slave_pos-stmt/'
       
      Retrying test rpl.rpl_mysqldump_gtid_slave_pos, attempt(2/3)...
      

      Attachments

        Issue Links

          Activity

            People

              Elkin Andrei Elkin
              bnestere Brandon Nesterenko
              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.