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

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

    XMLWordPrintable

    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

            People

            Assignee:
            jplindst Jan Lindström
            Reporter:
            tturenko Timofey Turenko
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: