June 19, 2013

Post: STOP: DELETE IGNORE on Tables with Foreign Keys Can Break Replication

row *************************** Level: Error Code: 1451 Message: Cannot delete or update a parent row: a foreign key constraint fails (`test`.`t2`, CONSTRAINT `t2_ibfk_1` FOREIGN KEY (`t2_c1`) REFERENCES `t1` (`t1_c1`) ON UPDATE CASCADE) 1 row