Details
Description
- http://buildbot.askmonty.org/buildbot/builders/kvm-deb-jessie-amd64/builds/11067/steps/mtr-galera/logs/stdio
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;