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

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