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

galera.galera_toi_ddl_nonconflicting MTR failed: 1213: Deadlock found when trying to get lock

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Fixed
    • 10.4.12
    • N/A
    • Galera, Tests
    • None
    • kvm-zyp-opensuse150-amd64

    Description

      galera.galera_toi_ddl_nonconflicting failed on bb.

      stdout.log:

      10.4.12 6a8a4c19e2db22573207f32a714d354f8e870df0

      galera.galera_toi_ddl_nonconflicting 'innodb' w1 [ fail ]
              Test ended at 2020-01-15 20:00:46
       
      CURRENT_TEST: galera.galera_toi_ddl_nonconflicting
      mysqltest: At line 17: 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 AUTO_INCREMENT, f2 INTEGER);
      connection node_2;
      ALTER TABLE t1 ADD COLUMN f3 INTEGER; INSERT INTO t1 (f1, f2) VALUES (DEFAULT, 123);;
      connection node_1;
      CREATE UNIQUE INDEX i1 ON t1(f2);;
      connection node_2;
       
       - skipping '/dev/shm/var/1/log/galera.galera_toi_ddl_nonconflicting-innodb/'
       
      Retrying test galera.galera_toi_ddl_nonconflicting, attempt(2/3)...
       
      worker[1] > Restart  - not started
      worker[1] > Restart  - not started
      

      Attachments

        Activity

          stepan.patryshev Stepan Patryshev (Inactive) created issue -
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          Field Original Value New Value
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          Assignee Stepan Patryshev [ stepan.patryshev ] Jan Lindström [ jplindst ]
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          Labels disabled
          julien.fritsch Julien Fritsch made changes -
          Labels disabled Test_disabled disabled
          julien.fritsch Julien Fritsch made changes -
          Labels Test_disabled disabled Test_disabled
          stepan.patryshev Stepan Patryshev (Inactive) made changes -
          Labels Test_disabled Test_disabled test_disabled_ES
          jplindst Jan Lindström (Inactive) made changes -
          Status Open [ 1 ] In Progress [ 3 ]
          serg Sergei Golubchik made changes -
          Workflow MariaDB v3 [ 103143 ] MariaDB v4 [ 144542 ]
          jplindst Jan Lindström (Inactive) made changes -
          issue.field.resolutiondate 2022-01-21 05:53:47.0 2022-01-21 05:53:47.29
          jplindst Jan Lindström (Inactive) made changes -
          Fix Version/s N/A [ 14700 ]
          Fix Version/s 10.4 [ 22408 ]
          Resolution Fixed [ 1 ]
          Status In Progress [ 3 ] Closed [ 6 ]
          julien.fritsch Julien Fritsch made changes -
          janlindstrom Jan Lindström made changes -
          Labels Test_disabled test_disabled_ES

          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.