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

Galera MTR tests failed: galera.MW-328A galera.MW-328B

Details

    Description

      galera.MW-328A galera.MW-328B failed in AZURE.

      rhel6, rhel8, sles15,ubuntu16.04 - both

      debian 8 and debian 9 - only galera.MW-328A

      logs:

      galera.MW-328A:

      galera.MW-328A 'innodb' w2 [ fail ] timeout after 7200 seconds
      Test ended at 2019-12-19 00:19:42

      Test case timeout after 7200 seconds

      == /var/tmp/mtr/2/log/MW-328A.log ==
      CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, f2 CHAR(20) DEFAULT 'abc') ENGINE=InnoDB;
      INSERT INTO t1 (f1) VALUES (1);
      CREATE TABLE t2 (f1 CHAR(20)) ENGINE=InnoDB;
      CREATE PROCEDURE proc_update ()
      BEGIN
      DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
      SET SESSION wsrep_sync_wait = 0;
      WHILE 1 DO
      UPDATE t1 SET f2 = LEFT(MD5(RAND()), 4);
      END WHILE;
      END|
      connect node_1X, 127.0.0.1, root, , test, $NODE_MYPORT_1;
      connection node_1X;
      CALL proc_update();;
      connection node_2;
      SET SESSION wsrep_retry_autocommit = 0;

      == /var/tmp/mtr/2/tmp/analyze-timeout-mysqld.2.err ==
      mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/var/tmp/mtr/tmp/2/mysqld.2.sock' (111)

      == /var/tmp/mtr/2/tmp/analyze-timeout-mysqld.1.err ==
      mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/var/tmp/mtr/tmp/2/mysqld.1.sock' (111)

      • saving '/var/tmp/mtr/2/log/galera.MW-328A-innodb/' to '/var/tmp/mtr/log/galera.MW-328A-innodb/'
        ***Warnings generated in error logs during shutdown after running tests: galera.GAL-419 galera.MW-328A galera.MW-286

      Attempting backtrace. You can use the following information to find out
      Attempting backtrace. You can use the following information to find out

      galera.MW-328B:

      galera.MW-328B 'innodb' w1 [ fail ] timeout after 7200 seconds
      Test ended at 2019-12-19 00:58:30

      Test case timeout after 7200 seconds

      == /var/tmp/mtr/1/log/MW-328B.log ==
      CREATE TABLE t1 (f1 INTEGER AUTO_INCREMENT PRIMARY KEY, f2 CHAR(20) DEFAULT 'abc') ENGINE=InnoDB;
      INSERT INTO t1 (f1) VALUES (1);
      CREATE TABLE t2 (f1 CHAR(20)) ENGINE=InnoDB;
      CREATE PROCEDURE proc_update ()
      BEGIN
      DECLARE CONTINUE HANDLER FOR SQLEXCEPTION BEGIN END;
      SET SESSION wsrep_sync_wait = 0;
      WHILE 1 DO
      UPDATE t1 SET f2 = LEFT(MD5(RAND()), 4);
      END WHILE;
      END|
      connect node_1X, 127.0.0.1, root, , test, $NODE_MYPORT_1;
      connection node_1X;
      CALL proc_update();;
      connection node_2;
      SET SESSION wsrep_retry_autocommit = 0;

      == /var/tmp/mtr/1/tmp/analyze-timeout-mysqld.2.err ==
      mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/var/tmp/mtr/tmp/1/mysqld.2.sock' (111)

      == /var/tmp/mtr/1/tmp/analyze-timeout-mysqld.1.err ==
      mysqltest: Could not open connection 'default' after 500 attempts: 2002 Can't connect to local MySQL server through socket '/var/tmp/mtr/tmp/1/mysqld.1.sock' (111)

      • saving '/var/tmp/mtr/1/log/galera.MW-328B-innodb/' to '/var/tmp/mtr/log/galera.MW-328B-innodb/'
        ***Warnings generated in error logs during shutdown after running tests: galera.MW-328B

      Attempting backtrace. You can use the following information to find out
      Attempting backtrace. You can use the following information to find out

      Attachments

        1. galera.mw328
          186 kB
          Timofey Turenko

        Activity

          tturenko remember to get the component Tests and to assign Stepan

          julien.fritsch Julien Fritsch added a comment - tturenko remember to get the component Tests and to assign Stepan

          also happened with sles12 and 10.3

          tturenko Timofey Turenko added a comment - also happened with sles12 and 10.3

          + 10.e Debian and Ubuntu

          tturenko Timofey Turenko added a comment - + 10.e Debian and Ubuntu

          longer log attached galera.mw328

          tturenko Timofey Turenko added a comment - longer log attached galera.mw328

          I would need error logs from both nodes if these tests fail again.

          jplindst Jan Lindström (Inactive) added a comment - I would need error logs from both nodes if these tests fail again.

          The tests are now enabled in 10.2 and 10.3, but not 10.4, because on a merge, the tests galera.MW-328A galera.MW-328B would fail.
          In 10.4, even after MDEV-22466 was fixed, the test galera.MW-328C is missing.

          marko Marko Mäkelä added a comment - The tests are now enabled in 10.2 and 10.3, but not 10.4, because on a merge , the tests galera.MW-328A galera.MW-328B would fail. In 10.4, even after MDEV-22466 was fixed, the test galera.MW-328C is missing.

          People

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