View Issue Details

IDProjectCategoryView StatusLast Update
1607RackTablesdefaultpublic2016-04-05 17:20
Reporterkjhall55 Assigned To 
PrioritynormalSeveritymajorReproducibilityalways
Status newResolutionopen 
Platformx86_64OSFedoraOS VersionFedora 22
Product Version0.20.11 
Summary1607: Upgrade from 0.19 to latest produces error, object database unusable
DescriptionSame as issue 0001321, seeing error:

ALTER TABLE PortInterfaceCompat ADD CONSTRAINT `PortInterfaceCompat-FK-oif_id` FOREIGN KEY (oif_id) REFERENCES PortOuterInterface (id) -- Cannot add or update a child row: a foreign key constraint fails (`racktables_db`.`#sql-51b_15c219`, CONSTRAINT `PortInterfaceCompat-FK-oif_id` FOREIGN KEY (`oif_id`) REFERENCES `PortOuterInterface` (`id`))
ALTER TABLE PortCompat ADD CONSTRAINT `PortCompat-FK-oif_id1` FOREIGN KEY (type1) REFERENCES PortOuterInterface (id) -- Cannot add or update a child row: a foreign key constraint fails (`racktables_db`.`#sql-51b_15c219`, CONSTRAINT `PortCompat-FK-oif_id1` FOREIGN KEY (`type1`) REFERENCES `PortOuterInterface` (`id`))
ALTER TABLE PortCompat ADD CONSTRAINT `PortCompat-FK-oif_id2` FOREIGN KEY (type2) REFERENCES PortOuterInterface (id) -- Cannot add or update a child row: a foreign key constraint fails (`racktables_db`.`#sql-51b_15c219`, CONSTRAINT `PortCompat-FK-oif_id2` FOREIGN KEY (`type2`) REFERENCES `PortOuterInterface` (`id`))
INSERT INTO PatchCableOIFCompat (pctype_id, oif_id) VALUES

Tried recommended fix, still fails with error:

MariaDB [racktables_db]> ALTER TABLE PortInterfaceCompat ADD CONSTRAINT `PortInterfaceCompat-FK-oif_id` FOREIGN KEY (oif_id) REFERENCES PortOuterInterface (id);
ERROR 1452 (23000): Cannot add or update a child row: a foreign key constraint fails (`racktables_db`.`#sql-51b_15a807`, CONSTRAINT `PortInterfaceCompat-FK-oif_id` FOREIGN KEY (`oif_id`) REFERENCES `PortOuterInterface` (`id`))


TagsNo tags attached.

Activities

There are no notes attached to this issue.

Issue History

Date Modified Username Field Change
2016-04-05 17:20 kjhall55 New Issue