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

Lock wait timeout exceeded in galera_var_ignore_apply_errors

    XMLWordPrintable

Details

    Description

      galera_var_ignore_apply_errors test failed:

      galera.galera_var_ignore_apply_errors 'innodb' w2 [ fail ]
             Test ended at 2019-08-29 16:37:40
       
      CURRENT_TEST: galera.galera_var_ignore_apply_errors
       
      mysqltest: At line 72: query 'SELECT COUNT(*) = 0 FROM t1' failed: 1205: Lock wait timeout exceeded; try restarting transactionThe result from queries just before the failure was:
       
      < snip >
      CREATE TABLE t1 (f1 INTEGER);
      SET GLOBAL wsrep_on = OFF;
      ALTER TABLE t1 ADD COLUMN f2 INTEGER;
      SET GLOBAL wsrep_on = ON;
      ALTER TABLE t1 DROP COLUMN f2;
      DROP TABLE t1;
      connection node_2;
      SET GLOBAL wsrep_ignore_apply_errors = 2;
      connection node_1;
      CREATE TABLE t1 (f1 INTEGER);
      SET GLOBAL wsrep_on = OFF;
      INSERT INTO t1 VALUES (1);
      SET GLOBAL wsrep_on = ON;
      DELETE FROM t1 WHERE f1 = 1;
      connection node_1;
      SELECT COUNT(*) = 0 FROM t1;
      COUNT(*) = 0
      1
      connection node_2;
      SELECT COUNT(*) = 0 FROM t1;More results from queries before failure can be found in /dev/shm/var/2/log/galera_var_ignore_apply_errors.log - saving '/dev/shm/var/2/log/galera.galera_var_ignore_apply_errors-innodb/' to '/dev/shm/var/log/galera.galera_var_ignore_apply_errors-innodb/'Retrying test galera.galera_var_ignore_apply_errors, attempt(2/3)...worker[2] > Restart  - not started
      worker[2] > Restart  - not started
       
      galera.galera_ddl_multiline 'innodb'     w1 [ pass ]   2182
      galera.galera_defaults 'innodb'          w1 [ pass ]   2020
      galera.galera_delete_limit 'innodb'      w1 [ pass ]   2040
      galera.galera_var_ignore_apply_errors 'innodb' w2 [ retry-pass ]   2161
      

      Attachments

        Issue Links

          Activity

            People

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