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

        Activity

          tturenko Timofey Turenko created issue -
          tturenko Timofey Turenko made changes -
          Field Original Value New Value
          julien.fritsch Julien Fritsch made changes -
          Component/s Tests [ 14999 ]
          julien.fritsch Julien Fritsch made changes -
          Assignee Stepan Patryshev [ stepan.patryshev ]

          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
          tturenko Timofey Turenko made changes -
          Fix Version/s 10.3 [ 23605 ]
          Affects Version/s 10.3 [ 23605 ]

          also happened with sles12 and 10.3

          tturenko Timofey Turenko added a comment - also happened with sles12 and 10.3
          tturenko Timofey Turenko made changes -
          Component/s Galera [ 14918 ]

          + 10.e Debian and Ubuntu

          tturenko Timofey Turenko added a comment - + 10.e Debian and Ubuntu
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          tturenko Timofey Turenko made changes -
          Attachment galera.mw328 [ 50120 ]

          longer log attached galera.mw328

          tturenko Timofey Turenko added a comment - longer log attached galera.mw328
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          Assignee Stepan Patryshev [ stepan.patryshev ] Jan Lindström [ jplindst ]
          julien.fritsch Julien Fritsch made changes -
          Priority Major [ 3 ] Critical [ 2 ]
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          jplindst Jan Lindström (Inactive) made changes -
          Component/s Galera [ 10124 ]
          Component/s Tests [ 10800 ]
          Component/s Galera [ 14918 ]
          Component/s Tests [ 14999 ]
          Fix Version/s 10.2 [ 14601 ]
          Fix Version/s 10.3 [ 22126 ]
          Fix Version/s 10.3 [ 23605 ]
          Fix Version/s 10.2 [ 23606 ]
          Key MENT-575 MDEV-21483
          Affects Version/s 10.2 [ 14601 ]
          Affects Version/s 10.3 [ 22126 ]
          Affects Version/s 10.3 [ 23605 ]
          Affects Version/s 10.2 [ 23606 ]
          Project MariaDB Enterprise [ 11500 ] MariaDB Server [ 10000 ]
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          Labels disabled
          julien.fritsch Julien Fritsch made changes -
          Labels disabled Test_disabled disabled
          julien.fritsch Julien Fritsch made changes -
          Labels Test_disabled disabled Test_disabled
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          Labels Test_disabled Test_disabled test_disabled_ES
          jplindst Jan Lindström (Inactive) made changes -
          Labels Test_disabled test_disabled_ES test_disabled_ES
          jplindst Jan Lindström (Inactive) made changes -
          Labels test_disabled_ES need_feedback test_disabled_ES

          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.
          jplindst Jan Lindström (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          jplindst Jan Lindström (Inactive) made changes -
          Status In Progress [ 3 ] Stalled [ 10000 ]

          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.
          jplindst Jan Lindström (Inactive) made changes -
          Status Stalled [ 10000 ] In Progress [ 3 ]
          jplindst Jan Lindström (Inactive) made changes -
          issue.field.resolutiondate 2020-05-18 11:38:59.0 2020-05-18 11:38:59.212
          jplindst Jan Lindström (Inactive) made changes -
          Fix Version/s 10.2.33 [ 24307 ]
          Fix Version/s 10.3.24 [ 24306 ]
          Fix Version/s 10.4.14 [ 24305 ]
          Fix Version/s 10.5.4 [ 24264 ]
          Fix Version/s 10.2 [ 14601 ]
          Fix Version/s 10.3 [ 22126 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          jplindst Jan Lindström (Inactive) made changes -
          Labels need_feedback test_disabled_ES test_disabled_ES
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          julien.fritsch Julien Fritsch made changes -
          Labels test_disabled_ES
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 102580 ] MariaDB v4 [ 157126 ]

          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.