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

    XMLWordPrintable

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

          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.