…delete operation. Bug fixed #1089490 (Seppo Jaakola). Parallel applying would fail in case mixed CHAR and VARCHAR columns would be used in foreign key…fixed #1108431 (Alex Yurchenko). Cascading foreign key constraint could lead to unresolved replication conflict and leave a slave hanging. Bug fixed #…
Post: STOP: DELETE IGNORE on Tables with Foreign Keys Can Break Replication
February 2, 2012 By 1 Comment
… KEY (`t1_c1`) ) ENGINE=InnoDB; CREATE TABLE `t2` ( `t2_c1` int(10) unsigned NOT NULL, PRIMARY KEY (`t2_c1`), CONSTRAINT `t2_ibfk_1` FOREIGN KEY… *************************** 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…
Post: Hijacking Innodb Foreign Keys
January 2, 2012 By 2 Comments
… INTO child(parent_id) VALUES(1,”"); set foreign_key_checks=0; delete from parent; After these actions we have…a child row: a foreign key constraint fails (`test`.`child`, CONSTRAINT `child_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`parent_id`)) Renaming parent table (even with foreign…
Post: Logging Foreign Key errors
September 27, 2012 By Leave a Comment
…DELETE CASCADE The index in the foreign key in table is “PRIMARY” See http://dev.mysql.com/doc/refman/5.5/en/innodb-foreign-key-constraints.html for correct foreign key definition. InnoDB: Renaming table `employees10`.`#sql-3da_2b` to `employees10`.`employees` failed…
Comment: How to recover a single InnoDB table from a Full Backup
January 31, 2012 By 10 Comments
Good point 
ALTER TABLE customer DISCARD TABLESPACE; ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key constraint fails () Added to the blog post, thank you.
Post: SHOW INNODB STATUS walk through
July 17, 2006 By 40 Comments
…values(2,2) Foreign key constraint fails for table `test/child`: , CONSTRAINT `child_ibfk_1` FOREIGN KEY (`parent_id`) REFERENCES `parent` (`id`) ON DELETE CASCADE Trying to add… Definition of foreign key which failed as well as the closest match which was located in parent table. There is a lot of …
Post: Announcing Percona XtraDB Cluster 5.5.29-23.7.1
January 30, 2013 By 8 Comments
…Teemu Ollakka). Percona XtraDB Cluster would crash when processing a delete for a table with foreign key constraint. Bug fixed #1078346 (Seppo Jaakola). When variable… (Teemu Ollakka). Using XtraBackup for State Snapshot Transfer would fail due to mktemp error. Bug fixed #1080829 (Alex Yurchenko)….
