View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 1607 | RackTables | default | public | 2016-04-05 17:20 | 2016-04-05 17:20 |
| Reporter | kjhall55 | Assigned To | |||
| Priority | normal | Severity | major | Reproducibility | always |
| Status | new | Resolution | open | ||
| Platform | x86_64 | OS | Fedora | OS Version | Fedora 22 |
| Product Version | 0.20.11 | ||||
| Summary | 1607: Upgrade from 0.19 to latest produces error, object database unusable | ||||
| Description | Same 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`)) | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2016-04-05 17:20 | kjhall55 | New Issue |
