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

Galera test failure on MW-328[A|B|C]

Details

    Description

      • MariaDB Version 10.2.20-MariaDB-debug
      • commit d0bf132a6ace31c29813b4004fab2a8af780deaa

      All these fail on timeout like this:

      galera.MW-328C 'innodb'                  w3 [ fail ]  timeout after 900 seconds
              Test ended at 2018-11-27 10:15:29
       
      Test case timeout after 900 seconds
       
      == /home/jan/mysql/10.2-sst/mysql-test/var/3/log/MW-328C.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 = 10000;
      

      Attachments

        Activity

          jplindst Jan Lindström (Inactive) created issue -
          jplindst Jan Lindström (Inactive) made changes -
          Field Original Value New Value
          Description All these fail on timeout like this:
          {noformat}
          galera.MW-328C 'innodb' w3 [ fail ] timeout after 900 seconds
                  Test ended at 2018-11-27 10:15:29

          Test case timeout after 900 seconds

          == /home/jan/mysql/10.2-sst/mysql-test/var/3/log/MW-328C.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 = 10000;
          {noformat}
          * MariaDB Version 10.2.20-MariaDB-debug
          * commit d0bf132a6ace31c29813b4004fab2a8af780deaa

          All these fail on timeout like this:
          {noformat}
          galera.MW-328C 'innodb' w3 [ fail ] timeout after 900 seconds
                  Test ended at 2018-11-27 10:15:29

          Test case timeout after 900 seconds

          == /home/jan/mysql/10.2-sst/mysql-test/var/3/log/MW-328C.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 = 10000;
          {noformat}
          jplindst Jan Lindström (Inactive) made changes -
          Assignee Mario Karuza [ mkaruza ] Julius Goryavsky [ sysprg ]
          jplindst Jan Lindström (Inactive) made changes -
          jplindst Jan Lindström (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          jplindst Jan Lindström (Inactive) made changes -
          Fix Version/s 10.3 [ 22126 ]
          jplindst Jan Lindström (Inactive) made changes -
          Fix Version/s 10.4 [ 22408 ]
          jplindst Jan Lindström (Inactive) made changes -
          Assignee Julius Goryavsky [ sysprg ] Jan Lindström [ jplindst ]
          jplindst Jan Lindström (Inactive) made changes -
          issue.field.resolutiondate 2019-08-13 09:53:00.0 2019-08-13 09:53:00.125
          jplindst Jan Lindström (Inactive) made changes -
          Fix Version/s 10.2.27 [ 23717 ]
          Fix Version/s 10.3.18 [ 23719 ]
          Fix Version/s 10.4.8 [ 23721 ]
          Fix Version/s 10.2 [ 14601 ]
          Fix Version/s 10.3 [ 22126 ]
          Fix Version/s 10.4 [ 22408 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 90912 ] MariaDB v4 [ 155278 ]

          People

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