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

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.4.12
    • Fix Version/s: 10.4
    • Component/s: Galera, Tests
    • Labels:
    • Environment:
      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

          Issue Links

            Activity

              People

              Assignee:
              jplindst Jan Lindström
              Reporter:
              stepan.patryshev Stepan Patryshev
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

                Dates

                Created:
                Updated: