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

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

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 10.2.37, 10.4.18
    • Fix Version/s: 10.2, 10.4
    • Component/s: Galera, Tests
    • Labels:
      None
    • Environment:
      kvm-rpm-centos74-amd64-debug

      Description

      galera.galera_fk_cascade_delete_debug failed on BB 10.2 CS and BB 10.4 CS: "query 'reap' failed: 1205: Lock wait timeout exceeded".
      It seems to be a sporadic issue. Similar issue was fixed in MDEV-24432 two weeks before this failure.

      stdio.log:

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

      galera.galera_fk_cascade_delete_debug 'innodb' w2 [ fail ]
              Test ended at 2021-01-28 11:57:25
       
      CURRENT_TEST: galera.galera_fk_cascade_delete_debug
      mysqltest: At line 106: query 'reap' failed: 1205: Lock wait timeout exceeded; try restarting transaction
       
      The result from queries just before the failure was:
      < snip >
      FOREIGN KEY (parent_id)
      REFERENCES parent(id)
      ON DELETE CASCADE
      ) ENGINE=InnoDB;
      INSERT INTO parent VALUES (1);
      INSERT INTO child VALUES (1,0,1);
      connection node_2;
      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
       
       - skipping '/dev/shm/var/2/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:

                  Git Integration