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

Galera test failure on galera_binlog_stmt_autoinc

Details

    Description

      galera.galera_binlog_stmt_autoinc 'innodb' w2 [ fail ]
              Test ended at 2019-07-04 16:14:53
       
      CURRENT_TEST: galera.galera_binlog_stmt_autoinc
      --- /usr/share/mysql/mysql-test/suite/galera/r/galera_binlog_stmt_autoinc.result	2019-07-04 12:47:59.000000000 -0400
      +++ /dev/shm/var/2/log/galera_binlog_stmt_autoinc.reject	2019-07-04 16:14:52.855149693 -0400
      @@ -12,21 +12,21 @@
       insert into t1(i) values(null);
       select * from t1;
       i	c
      -1	dummy_text
      +2	dummy_text
       insert into t1(i) values(null), (null), (null);
       select * from t1;
       i	c
      -1	dummy_text
      -3	dummy_text
      -5	dummy_text
      -7	dummy_text
      +2	dummy_text
      +4	dummy_text
      +6	dummy_text
      +8	dummy_text
       connection node_2;
       select * from t1;
       i	c
      -1	dummy_text
      -3	dummy_text
      -5	dummy_text
      -7	dummy_text
      +2	dummy_text
      +4	dummy_text
      +6	dummy_text
      +8	dummy_text
       SET GLOBAL wsrep_forced_binlog_format='none';
       connection node_1;
       SET GLOBAL wsrep_forced_binlog_format='none';
      @@ -70,7 +70,7 @@
       show variables like '%auto_increment%';
       Variable_name	Value
       auto_increment_increment	2
      -auto_increment_offset	1
      +auto_increment_offset	2
       wsrep_auto_increment_control	ON
       SET GLOBAL wsrep_auto_increment_control='OFF';
       show variables like '%auto_increment%';
      @@ -92,21 +92,21 @@
       insert into t1(i) values(null);
       select * from t1;
       i	c
      -1	dummy_text
      +2	dummy_text
       insert into t1(i) values(null), (null), (null);
       select * from t1;
       i	c
      -1	dummy_text
      -3	dummy_text
      -5	dummy_text
      -7	dummy_text
      +2	dummy_text
      +4	dummy_text
      +6	dummy_text
      +8	dummy_text
       connection node_2;
       select * from t1;
       i	c
      -1	dummy_text
      -3	dummy_text
      -5	dummy_text
      -7	dummy_text
      +2	dummy_text
      +4	dummy_text
      +6	dummy_text
      +8	dummy_text
       SET GLOBAL wsrep_forced_binlog_format='none';
       connection node_1;
       SET GLOBAL wsrep_forced_binlog_format='none';
      @@ -149,7 +149,7 @@
       show variables like '%auto_increment%';
       Variable_name	Value
       auto_increment_increment	2
      -auto_increment_offset	1
      +auto_increment_offset	2
       wsrep_auto_increment_control	ON
       SET GLOBAL wsrep_auto_increment_control='OFF';
       show variables like '%auto_increment%';
       
      mysqltest: Result content mismatch
       
       - skipping '/dev/shm/var/2/log/galera.galera_binlog_stmt_autoinc-innodb/'
       
      Retrying test galera.galera_binlog_stmt_autoinc, attempt(2/3)...
      

      Attachments

        Issue Links

          Activity

            alice Alice Sherepa added a comment -

            http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles150-amd64/builds/5742/steps/mtr-galera/logs/stdio
            10.3 663bc849b5a26a5325adf0

            galera.galera_binlog_stmt_autoinc 'innodb' w1 [ fail ]
                    Test ended at 2021-06-03 23:11:23
             
            CURRENT_TEST: galera.galera_binlog_stmt_autoinc
            --- /usr/share/mysql-test/suite/galera/r/galera_binlog_stmt_autoinc.result	2021-06-03 20:37:12.000000000 +0000
            +++ /dev/shm/var/1/log/galera_binlog_stmt_autoinc.reject	2021-06-03 23:11:23.548287161 +0000
            @@ -12,21 +12,21 @@
             insert into t1(i) values(null);
             select * from t1;
             i	c
            -1	dummy_text
            +2	dummy_text
             insert into t1(i) values(null), (null), (null);
             select * from t1;
             i	c
            -1	dummy_text
            -3	dummy_text
            -5	dummy_text
            -7	dummy_text
            +2	dummy_text
            +4	dummy_text
            +6	dummy_text
            +8	dummy_text
             connection node_2;
             select * from t1;
             i	c
            -1	dummy_text
            -3	dummy_text
            -5	dummy_text
            -7	dummy_text
            +2	dummy_text
            +4	dummy_text
            +6	dummy_text
            +8	dummy_text
             SET GLOBAL wsrep_forced_binlog_format='none';
             connection node_1;
             SET GLOBAL wsrep_forced_binlog_format='none';
            @@ -70,7 +70,7 @@
             show variables like '%auto_increment%';
             Variable_name	Value
             auto_increment_increment	2
            -auto_increment_offset	1
            +auto_increment_offset	2
             wsrep_auto_increment_control	ON
             SET GLOBAL wsrep_auto_increment_control='OFF';
             show variables like '%auto_increment%';
            @@ -92,21 +92,21 @@
             insert into t1(i) values(null);
             select * from t1;
             i	c
            -1	dummy_text
            +2	dummy_text
             insert into t1(i) values(null), (null), (null);
             select * from t1;
             i	c
            -1	dummy_text
            -3	dummy_text
            -5	dummy_text
            -7	dummy_text
            +2	dummy_text
            +4	dummy_text
            +6	dummy_text
            +8	dummy_text
             connection node_2;
             select * from t1;
             i	c
            -1	dummy_text
            -3	dummy_text
            -5	dummy_text
            -7	dummy_text
            +2	dummy_text
            +4	dummy_text
            +6	dummy_text
            +8	dummy_text
             SET GLOBAL wsrep_forced_binlog_format='none';
             connection node_1;
             SET GLOBAL wsrep_forced_binlog_format='none';
            @@ -149,7 +149,7 @@
             show variables like '%auto_increment%';
             Variable_name	Value
             auto_increment_increment	2
            -auto_increment_offset	1
            +auto_increment_offset	2
             wsrep_auto_increment_control	ON
             SET GLOBAL wsrep_auto_increment_control='OFF';
             show variables like '%auto_increment%';
             
            mysqltest: Result content mismatch
             
             - saving '/dev/shm/var/1/log/galera.galera_binlog_stmt_autoinc-innodb/' to '/dev/shm/var/log/galera.galera_binlog_stmt_autoinc-innodb/'
             
            Retrying test galera.galera_binlog_stmt_autoinc, attempt(2/3)...
            

            alice Alice Sherepa added a comment - http://buildbot.askmonty.org/buildbot/builders/kvm-zyp-sles150-amd64/builds/5742/steps/mtr-galera/logs/stdio 10.3 663bc849b5a26a5325adf0 galera.galera_binlog_stmt_autoinc 'innodb' w1 [ fail ] Test ended at 2021-06-03 23:11:23   CURRENT_TEST: galera.galera_binlog_stmt_autoinc --- /usr/share/mysql-test/suite/galera/r/galera_binlog_stmt_autoinc.result 2021-06-03 20:37:12.000000000 +0000 +++ /dev/shm/var/1/log/galera_binlog_stmt_autoinc.reject 2021-06-03 23:11:23.548287161 +0000 @@ -12,21 +12,21 @@ insert into t1(i) values(null); select * from t1; i c -1 dummy_text +2 dummy_text insert into t1(i) values(null), (null), (null); select * from t1; i c -1 dummy_text -3 dummy_text -5 dummy_text -7 dummy_text +2 dummy_text +4 dummy_text +6 dummy_text +8 dummy_text connection node_2; select * from t1; i c -1 dummy_text -3 dummy_text -5 dummy_text -7 dummy_text +2 dummy_text +4 dummy_text +6 dummy_text +8 dummy_text SET GLOBAL wsrep_forced_binlog_format='none'; connection node_1; SET GLOBAL wsrep_forced_binlog_format='none'; @@ -70,7 +70,7 @@ show variables like '%auto_increment%'; Variable_name Value auto_increment_increment 2 -auto_increment_offset 1 +auto_increment_offset 2 wsrep_auto_increment_control ON SET GLOBAL wsrep_auto_increment_control='OFF'; show variables like '%auto_increment%'; @@ -92,21 +92,21 @@ insert into t1(i) values(null); select * from t1; i c -1 dummy_text +2 dummy_text insert into t1(i) values(null), (null), (null); select * from t1; i c -1 dummy_text -3 dummy_text -5 dummy_text -7 dummy_text +2 dummy_text +4 dummy_text +6 dummy_text +8 dummy_text connection node_2; select * from t1; i c -1 dummy_text -3 dummy_text -5 dummy_text -7 dummy_text +2 dummy_text +4 dummy_text +6 dummy_text +8 dummy_text SET GLOBAL wsrep_forced_binlog_format='none'; connection node_1; SET GLOBAL wsrep_forced_binlog_format='none'; @@ -149,7 +149,7 @@ show variables like '%auto_increment%'; Variable_name Value auto_increment_increment 2 -auto_increment_offset 1 +auto_increment_offset 2 wsrep_auto_increment_control ON SET GLOBAL wsrep_auto_increment_control='OFF'; show variables like '%auto_increment%';   mysqltest: Result content mismatch   - saving '/dev/shm/var/1/log/galera.galera_binlog_stmt_autoinc-innodb/' to '/dev/shm/var/log/galera.galera_binlog_stmt_autoinc-innodb/'   Retrying test galera.galera_binlog_stmt_autoinc, attempt(2/3)...

            I'm not sure what Test_disabled label here means, but the test still runs and fails in buildbot.
            https://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-amd64/builds/27868/steps/mtr-galera/logs/stdio
            jplindst,
            Could it please be fixed or disabled for real?

            10.3 06562b84f65fe5089288f3ca180d0636

             
            galera.galera_binlog_stmt_autoinc 'innodb' w1 [ fail ]
                    Test ended at 2022-05-04 23:55:13
             
            CURRENT_TEST: galera.galera_binlog_stmt_autoinc
            --- /usr/share/mysql/mysql-test/suite/galera/r/galera_binlog_stmt_autoinc.result	2022-05-04 21:52:00.000000000 -0400
            +++ /dev/shm/var/1/log/galera_binlog_stmt_autoinc.reject	2022-05-04 23:55:13.237459827 -0400
            @@ -12,21 +12,21 @@
             insert into t1(i) values(null);
             select * from t1;
             i	c
            -1	dummy_text
            +2	dummy_text
             insert into t1(i) values(null), (null), (null);
             select * from t1;
             i	c
            -1	dummy_text
            -3	dummy_text
            -5	dummy_text
            -7	dummy_text
            +2	dummy_text
            +4	dummy_text
            +6	dummy_text
            +8	dummy_text
             connection node_2;
             select * from t1;
             i	c
            -1	dummy_text
            -3	dummy_text
            -5	dummy_text
            -7	dummy_text
            +2	dummy_text
            +4	dummy_text
            +6	dummy_text
            +8	dummy_text
             SET GLOBAL wsrep_forced_binlog_format='none';
             connection node_1;
             SET GLOBAL wsrep_forced_binlog_format='none';
            @@ -70,7 +70,7 @@
             show variables like '%auto_increment%';
             Variable_name	Value
             auto_increment_increment	2
            -auto_increment_offset	1
            +auto_increment_offset	2
             wsrep_auto_increment_control	ON
             SET GLOBAL wsrep_auto_increment_control='OFF';
             show variables like '%auto_increment%';
            @@ -92,21 +92,21 @@
             insert into t1(i) values(null);
             select * from t1;
             i	c
            -1	dummy_text
            +2	dummy_text
             insert into t1(i) values(null), (null), (null);
             select * from t1;
             i	c
            -1	dummy_text
            -3	dummy_text
            -5	dummy_text
            -7	dummy_text
            +2	dummy_text
            +4	dummy_text
            +6	dummy_text
            +8	dummy_text
             connection node_2;
             select * from t1;
             i	c
            -1	dummy_text
            -3	dummy_text
            -5	dummy_text
            -7	dummy_text
            +2	dummy_text
            +4	dummy_text
            +6	dummy_text
            +8	dummy_text
             SET GLOBAL wsrep_forced_binlog_format='none';
             connection node_1;
             SET GLOBAL wsrep_forced_binlog_format='none';
            @@ -149,7 +149,7 @@
             show variables like '%auto_increment%';
             Variable_name	Value
             auto_increment_increment	2
            -auto_increment_offset	1
            +auto_increment_offset	2
             wsrep_auto_increment_control	ON
             SET GLOBAL wsrep_auto_increment_control='OFF';
             show variables like '%auto_increment%';
             
            mysqltest: Result content mismatch
            

            elenst Elena Stepanova added a comment - I'm not sure what Test_disabled label here means, but the test still runs and fails in buildbot. https://buildbot.askmonty.org/buildbot/builders/kvm-deb-stretch-amd64/builds/27868/steps/mtr-galera/logs/stdio jplindst , Could it please be fixed or disabled for real? 10.3 06562b84f65fe5089288f3ca180d0636   galera.galera_binlog_stmt_autoinc 'innodb' w1 [ fail ] Test ended at 2022-05-04 23:55:13   CURRENT_TEST: galera.galera_binlog_stmt_autoinc --- /usr/share/mysql/mysql-test/suite/galera/r/galera_binlog_stmt_autoinc.result 2022-05-04 21:52:00.000000000 -0400 +++ /dev/shm/var/1/log/galera_binlog_stmt_autoinc.reject 2022-05-04 23:55:13.237459827 -0400 @@ -12,21 +12,21 @@ insert into t1(i) values(null); select * from t1; i c -1 dummy_text +2 dummy_text insert into t1(i) values(null), (null), (null); select * from t1; i c -1 dummy_text -3 dummy_text -5 dummy_text -7 dummy_text +2 dummy_text +4 dummy_text +6 dummy_text +8 dummy_text connection node_2; select * from t1; i c -1 dummy_text -3 dummy_text -5 dummy_text -7 dummy_text +2 dummy_text +4 dummy_text +6 dummy_text +8 dummy_text SET GLOBAL wsrep_forced_binlog_format='none'; connection node_1; SET GLOBAL wsrep_forced_binlog_format='none'; @@ -70,7 +70,7 @@ show variables like '%auto_increment%'; Variable_name Value auto_increment_increment 2 -auto_increment_offset 1 +auto_increment_offset 2 wsrep_auto_increment_control ON SET GLOBAL wsrep_auto_increment_control='OFF'; show variables like '%auto_increment%'; @@ -92,21 +92,21 @@ insert into t1(i) values(null); select * from t1; i c -1 dummy_text +2 dummy_text insert into t1(i) values(null), (null), (null); select * from t1; i c -1 dummy_text -3 dummy_text -5 dummy_text -7 dummy_text +2 dummy_text +4 dummy_text +6 dummy_text +8 dummy_text connection node_2; select * from t1; i c -1 dummy_text -3 dummy_text -5 dummy_text -7 dummy_text +2 dummy_text +4 dummy_text +6 dummy_text +8 dummy_text SET GLOBAL wsrep_forced_binlog_format='none'; connection node_1; SET GLOBAL wsrep_forced_binlog_format='none'; @@ -149,7 +149,7 @@ show variables like '%auto_increment%'; Variable_name Value auto_increment_increment 2 -auto_increment_offset 1 +auto_increment_offset 2 wsrep_auto_increment_control ON SET GLOBAL wsrep_auto_increment_control='OFF'; show variables like '%auto_increment%';   mysqltest: Result content mismatch

            People

              jplindst Jan Lindström (Inactive)
              jplindst Jan Lindström (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              3 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.