galera.galera_fk_cascade_delete 'innodb' w1 [ fail ]

        Test ended at 2020-11-04 09:55:40

CURRENT_TEST: galera.galera_fk_cascade_delete

mysqltest: At line 43: query 'DELETE FROM grandparent WHERE id = 1' failed: 1213: Deadlock: wsrep aborted transaction

The result from queries just before the failure was:

< snip >

CREATE TABLE parent (

id INT NOT NULL PRIMARY KEY,

grandparent_id INT,

FOREIGN KEY (grandparent_id)

REFERENCES grandparent(id)

ON DELETE CASCADE

) ENGINE=InnoDB;

CREATE TABLE child (

id INT NOT NULL PRIMARY KEY, 

parent_id INT,

FOREIGN KEY (parent_id) 

REFERENCES parent(id)

ON DELETE CASCADE

) ENGINE=InnoDB;

INSERT INTO grandparent VALUES (1),(2);

INSERT INTO parent VALUES (1,1), (2,2);

INSERT INTO child VALUES (1,1), (2,2);

connection node_2;

set wsrep_sync_wait=0;

DELETE FROM grandparent WHERE id = 1;