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

          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: