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:40CURRENT_TEST: galera.galera_fk_cascade_deletemysqltest: At line 43: query 'DELETE FROM grandparent WHERE id = 1' failed: 1213: Deadlock: wsrep aborted transactionThe 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;