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;
|