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

galera.galera_fk_cascade_delete_debug MTR failed: query 'reap' failed: 1205: Lock wait timeout exceeded

    XMLWordPrintable

    Details

      Description

      galera.galera_fk_cascade_delete_debug failed on BB 10.2 CS, BB 10.5 CS and BB 10.6 CS: "query 'reap' failed: 1205: Lock wait timeout exceeded".
      It seems to be a sporadic issue.

      stdio.log:

      10.2.37, ac9c6f53a5e1d0637fb390f1cd7b44bd8c38d72e, kvm-rpm-centos74-amd64-debug

      galera.galera_fk_cascade_delete_debug 'innodb' w2 [ fail ]
              Test ended at 2020-12-15 14:11:18
       
      CURRENT_TEST: galera.galera_fk_cascade_delete_debug
      mysqltest: At line 90: query 'reap' failed: 1205: Lock wait timeout exceeded; try restarting transaction
       
      The result from queries just before the failure was:
      < snip >
      parent_id INT,
      FOREIGN KEY (parent_id)
      REFERENCES parent(id)
      ON DELETE CASCADE
      ) ENGINE=InnoDB;
      INSERT INTO parent VALUES (1);
      INSERT INTO child VALUES (1,0,1);
      connect node_1a, 127.0.0.1, root, , test, $NODE_MYPORT_1;
      SET GLOBAL debug_dbug = "d,sync.wsrep_apply_cb";
      connection node_2;
      DELETE FROM parent;
      connection node_1a;
      SET SESSION DEBUG_SYNC = "now WAIT_FOR sync.wsrep_apply_cb_reached";
      connection node_1;
      update child set j=2;;
      connection node_1a;
      SET DEBUG_SYNC = "now SIGNAL signal.wsrep_apply_cb";
      SET GLOBAL debug_dbug = "";
      SET DEBUG_SYNC = "RESET";
      connection node_1;
       
      More results from queries before failure can be found in /dev/shm/var/2/log/galera_fk_cascade_delete_debug.log
       
       - saving '/dev/shm/var/2/log/galera.galera_fk_cascade_delete_debug-innodb/' to '/dev/shm/var/log/galera.galera_fk_cascade_delete_debug-innodb/'
       
      Retrying test galera.galera_fk_cascade_delete_debug, attempt(2/3)...
       
      worker[2] > Restart  - not started
      worker[2] > Restart  - not started
      

      Server logs.

        Attachments

          Issue Links

            Activity

              People

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

                Dates

                Created:
                Updated:
                Resolved:

                  Git Integration