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

galera.lp1376747-4 MTR fails differently on various branches

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.2.37, 10.3.28, 10.4.18, 10.5.9, 10.6.0
    • Fix Version/s: 10.2, 10.3, 10.4, 10.5
    • Component/s: Galera, Tests
    • Labels:
      None
    • Environment:
      kvm-rpm-centos74-amd64-debug, kvm-deb-focal-amd64, kvm-deb-stretch-aarch64, kvm-rpm-centos74-aarch64, kvm-rpm-centos73-ppc64

      Description

      galera.lp1376747-4 fails on BB 10.3 CS, BB 10.4 CS and BB 10.5 CS: Result length mismatch

      stdio.log:

      10.3.28, da88e1ec12b0ba39552bf54367c1bb3b89eac4a8,

      galera.lp1376747-4 'innodb'              w2 [ fail ]
              Test ended at 2021-02-11 22:40:42
       
      CURRENT_TEST: galera.lp1376747-4
      --- /usr/share/mysql/mysql-test/suite/galera/r/lp1376747-4.result	2021-02-11 12:21:08.000000000 -0500
      +++ /dev/shm/var/2/log/lp1376747-4.reject	2021-02-11 22:40:42.084747929 -0500
      @@ -24,6 +24,7 @@
       Table	Create Table
       t1	CREATE TABLE `t1` (
         `id` int(11) NOT NULL,
      +  `f2` int(11) DEFAULT NULL,
         PRIMARY KEY (`id`)
       ) ENGINE=InnoDB DEFAULT CHARSET=latin1
       connection node_2a;
       
      mysqltest: Result length mismatch
       
       - saving '/dev/shm/var/2/log/galera.lp1376747-4-innodb/' to '/dev/shm/var/log/galera.lp1376747-4-innodb/'
       
      Retrying test galera.lp1376747-4, attempt(2/3)...
       
      worker[2] > Restart  - not started
      worker[2] > Restart  - not started
      

      galera.lp1376747-4 failed on BB 10.2 CS with another ouput: Result length mismatch: +Warning 1639 debug sync point wait timed out.

      stdio.log:

      10.2.37, 95003eab451cac2fd2c0552f374a85842f2773f2, kvm-rpm-centos74-amd64-debug

      galera.lp1376747-4 'innodb'              w1 [ fail ]
              Test ended at 2021-02-11 15:34:52
       
      CURRENT_TEST: galera.lp1376747-4
      --- /usr/share/mysql-test/suite/galera/r/lp1376747-4.result	2021-02-11 12:47:20.000000000 +0000
      +++ /dev/shm/var/1/log/lp1376747-4.reject	2021-02-11 15:34:51.270402200 +0000
      @@ -29,6 +29,8 @@
       ) ENGINE=InnoDB DEFAULT CHARSET=latin1
       set debug_sync= 'RESET';
       connection node_2a;
      +Warnings:
      +Warning	1639	debug sync point wait timed out
       UNLOCK TABLES;
       SET SESSION wsrep_sync_wait = DEFAULT;
       SHOW CREATE TABLE t1;
       
      mysqltest: Result length mismatch
       
       - saving '/dev/shm/var/1/log/galera.lp1376747-4-innodb/' to '/dev/shm/var/log/galera.lp1376747-4-innodb/'
       
      Retrying test galera.lp1376747-4, attempt(2/3)...
       
      worker[1] > Restart  - not started
      worker[1] > Restart  - not started
      

      And galera.lp1376747-4 failed on BB 10.6 CS with another ouput:

      stdio.log: query 'SHOW CREATE TABLE t1' failed: 2000: Unknown MySQL error

      10.6.0, 4df0249b9acc2c79c450c3836ae60f3e9076ae6e, kvm-deb-focal-amd64

      galera.lp1376747-4 'innodb'              w2 [ fail ]
              Test ended at 2021-02-15 11:31:34
       
      CURRENT_TEST: galera.lp1376747-4
      mysqltest: At line 41: query 'SHOW CREATE TABLE t1' failed: 2000: Unknown MySQL error
       
      The result from queries just before the failure was:
      < snip >
      connection node_1;
      ALTER TABLE t1 ADD COLUMN f2 INTEGER;
      INSERT INTO t1 VALUES (2,3);
      connection node_2a;
      SET session wsrep_sync_wait=0;
      # node_1 DDL should not yet be applied
      SHOW CREATE TABLE t1;
      Table	Create Table
      t1	CREATE TABLE `t1` (
        `id` int(11) NOT NULL,
        PRIMARY KEY (`id`)
      ) ENGINE=InnoDB DEFAULT CHARSET=latin1
      FLUSH TABLES t1 WITH READ LOCK;;
      connection node_2;
      UNLOCK TABLES;
      # node_1 DDL should not yet be applied 2
      SHOW CREATE TABLE t1;
       
      More results from queries before failure can be found in /dev/shm/var/2/log/lp1376747-4.log
       
       - saving '/dev/shm/var/2/log/galera.lp1376747-4-innodb/' to '/dev/shm/var/log/galera.lp1376747-4-innodb/'
       
      Retrying test galera.lp1376747-4, attempt(2/3)...
       
      worker[2] > Restart  - not started
      worker[2] > Restart  - not started
      

        Attachments

          Issue Links

            Activity

              People

              Assignee:
              jplindst Jan Lindström
              Reporter:
              stepan.patryshev Stepan Patryshev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated:

                  Git Integration