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

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 10.2.37, 10.4.18
    • 10.4
    • Galera, Tests
    • None
    • 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

              sysprg Julius Goryavsky
              stepan.patryshev Stepan Patryshev (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:

                Git Integration

                  Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.