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

galera_3nodes.galera_parallel_apply_3nodes MTR failed: query 'reap' failed: 1213: Deadlock found when trying to get lock

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Critical
    • Resolution: Fixed
    • 10.5.7
    • 10.4.18, 10.5.9, 10.6.0
    • Galera, Tests
    • None
    • kvm-deb-groovy-aarch64

    Description

      galera_3nodes.galera_parallel_apply_3nodes MTR failed on BB, 10.5: "query 'reap' failed: 1213: Deadlock found when trying to get lock".

      stdio.log:

      10.5.7 c27e53f45992d0b0b5eb5ff6242cfe1a78eba8b5

      galera_3nodes.galera_parallel_apply_3nodes 'innodb' w1 [ fail ]
              Test ended at 2020-10-26 21:05:15
       
      CURRENT_TEST: galera_3nodes.galera_parallel_apply_3nodes
      mysqltest: At line 27: query 'reap' failed: 1213: Deadlock found when trying to get lock; try restarting transaction
       
      The result from queries just before the failure was:
      connection node_2;
      connection node_1;
      CREATE TABLE t1 (f1 INTEGER PRIMARY KEY) ENGINE=InnoDB;
      INSERT INTO t1 VALUES (1);
      connection node_3;
      SET GLOBAL wsrep_slave_threads = 2;
      connection node_1;
      UPDATE t1 SET f1 = f1 + 10;;
      connection node_2;
      UPDATE t1 SET f1 = f1 + 100;;
      connection node_1;
      

      Attachments

        Activity

          People

            jplindst Jan Lindström (Inactive)
            stepan.patryshev Stepan Patryshev (Inactive)
            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.