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

Most of the mtr tests in the galera_3nodes suite fail

    XMLWordPrintable

Details

    Description

      Most of the mtr tests in the galera_3nodes suite fail for a variety of reasons with a variety of errors. Some tests simply need to add the missing "connection" lines to the result files, but many of them fail due to substantial errors that require reworking test files. For example:

      galera_3nodes.galera_garbd 'innodb'      [ fail ]
              Test ended at 2019-01-29 13:06:57
       
      CURRENT_TEST: galera_3nodes.galera_garbd
      mysqltest: At line 35: exec of 'pkill --oldest --full garbd.*@OPT.port' failed, error: 15, status: 0, errno: 11
      Output from before failure:
      Killing garbd ...
      

      or:

      galera_3nodes.galera_evs_suspect_timeout 'innodb' [ fail ]  timeout after 900 seconds
              Test ended at 2019-01-29 13:24:53
       
      Test case timeout after 900 seconds
       
      == /home/panda/mariadb_work/build/mysql-test/var/log/galera_evs_suspect_timeout.log == 
      connection node_3;
      Suspending node ...
      connection node_1;
      SET SESSION wsrep_sync_wait = 0;
      SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
      VARIABLE_VALUE = 2
      1
      CREATE TABLE t1 (f1 INTEGER);
      INSERT INTO t1 VALUES (1);
      connection node_2;
      SET SESSION wsrep_sync_wait = 0;
      SELECT VARIABLE_VALUE = 2 FROM INFORMATION_SCHEMA.GLOBAL_STATUS WHERE VARIABLE_NAME = 'wsrep_cluster_size';
      VARIABLE_VALUE = 2
      1
      SET SESSION wsrep_sync_wait = DEFAULT;
      SELECT COUNT(*) = 1 FROM t1;
      COUNT(*) = 1
      1
      DROP TABLE t1;
      connection node_3;
      

      or (only under debug build of the galera library):

      galera_3nodes.galera_ist_gcache_rollover 'innodb' [ fail ]
              Test ended at 2019-01-29 17:43:16
       
      CURRENT_TEST: galera_3nodes.galera_ist_gcache_rollover
      mysqltest: In included file "./suite/galera/include/galera_unload_provider.inc": 
      included from /home/panda/mariadb_work/mysql-test/suite/galera_3nodes/t/galera_ist_gcache_rollover.test at line 35:
      At line 7: query 'SET GLOBAL wsrep_provider = 'none'' failed: 2013: Lost connection to MySQL server during query
       
      The result from queries just before the failure was:
      connection node_1;
      connection node_2;
      connection node_3;
      CREATE TABLE t1 (f1 INTEGER PRIMARY KEY);
      INSERT INTO t1 VALUES (01), (02), (03), (04), (05);
      connection node_2;
      Unloading wsrep provider ...
      SET GLOBAL wsrep_provider = 'none';
      connection node_3;
      Unloading wsrep provider ...
      SET GLOBAL wsrep_provider = 'none';
      

      Attachments

        Activity

          People

            sysprg Julius Goryavsky
            sysprg Julius Goryavsky
            Votes:
            0 Vote for this issue
            Watchers:
            2 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.