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

test galera.galera_log_bin is not deterministic

    XMLWordPrintable

Details

    Description

      Sporadic, although apparently very rare, occasion when the test fails for non existent table error in node 1:

      galera.galera_log_bin 'innodb'           w1 [ fail ]
              Test ended at 2023-01-11 22:41:03
       
      CURRENT_TEST: galera.galera_log_bin
      mysqltest: In included file "/usr/share/mysql-test/suite/galera/t/galera_log_bin.inc": 
      included from /usr/share/mysql-test/suite/galera/t/galera_log_bin.test at line 2:
      At line 31: query 'ALTER TABLE t1 ADD COLUMN f2 INTEGER' failed: 1146: Table 'test.t1' doesn't exist
       
      The result from queries just before the failure was:
      < snip >
      reset master;
      set global wsrep_on=ON;
      connection node_2;
      set global wsrep_on=OFF;
      reset master;
      set global wsrep_on=ON;
      CREATE TABLE t1 (id INT PRIMARY KEY) ENGINE=InnoDB;
      INSERT INTO t1 VALUES (1);
      CREATE TABLE t2 (id INT) ENGINE=InnoDB;
      INSERT INTO t2 VALUES (1);
      INSERT INTO t2 VALUES (1);
      connection node_2;
      SELECT COUNT(*) = 1 FROM t1;
      COUNT(*) = 1
      1
      SELECT COUNT(*) = 2 FROM t2;
      COUNT(*) = 2
      1
      connection node_1;
      ALTER TABLE t1 ADD COLUMN f2 INTEGER;
      

      Attachments

        Activity

          People

            sysprg Julius Goryavsky
            seppo Seppo Jaakola
            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.