View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 1501 | RackTables | default | public | 2015-08-19 05:09 | 2015-08-22 19:25 |
| Reporter | gurujimani | Assigned To | adoom42 | ||
| Priority | high | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Platform | Linux | OS | CentOS | OS Version | 6.6 |
| Product Version | 0.20.10 | ||||
| Target Version | 0.20.11 | Fixed in Version | 0.20.11 | ||
| Summary | 1501: The following queries failed while executing batch '0.20.8' | ||||
| Description | I was upgrading from .18.6 to .20.10. Everything worked perfectly but only the following queries failed for 0.20.8: 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`., 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`., 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`., CONSTRAINT `PortCompat-FK-oif_id2` FOREIGN KEY (`type2`) REFERENCES `PortOuterInterface` (`id`)) INSERT INTO PatchCableOIFCompat (pctype_id, oif_id) VALUES (13,18),(14,18),(15,18),(16,18),(17,18),(999,18), -- 10Base-T: Cat.3+ TP (11,1198),(12,1198),(11,1199),(12,1199), -- 100Base-BX10: 1xSMF (5,1197),(6,1197), -- 100Base-LX10: 2xSMF (5,1200),(6,1200), -- 100Base-EX: 2xSMF (5,1201),(6,1201), -- 100Base-ZX: 2xSMF (1,1195),(2,1195),(3,1195),(4,1195), -- 100Base-FX: 2xMMF (1,1196),(2,1196),(3,1196),(4,1196), -- 100Base-SX: 2xMMF (13,19),(14,19),(15,19),(16,19),(17,19), -- 100Base-TX: Cat.5+ TP (11,1206),(12,1206),(11,1207),(12,1207), -- 1000Base-BX10: 1xSMF (5,1204),(6,1204), -- 1000Base-LX: 2xSMF (5,1205),(6,1205), -- 1000Base-LX10: 2xSMF (1,1202),(2,1202),(3,1202),(4,1202), -- 1000Base-SX: 2xMMF (1,1203),(2,1203),(3,1203),(4,1203), -- 1000Base-SX+: 2xMMF (13,24),(14,24),(15,24),(16,24),(17,24), -- 1000Base-T: Cat.5+ TP (5,34),(6,34), -- 1000Base-ZX: 2xSMF (23,1077), -- 1000Base direct attach: shielded (1,30),(2,30),(3,30),(4,30), -- 10GBase-SR: 2xMMF (5,36),(6,36), -- 10GBase-LR: 2xSMF (5,35),(6,35), -- 10GBase-ER: 2xSMF (5,38),(6,38), -- 10GBase-ZR: 2xSMF (1,39),(2,39),(3,39),(4,39),(5,39),(6,39), -- 10GBase-LX4: 2xMMF/2xSMF (1,37),(2,37),(3,37),(4,37), -- 10GBase-LRM: 2xMMF (14,1642),(15,1642),(16,1642),(17,1642), -- 10GBase-T: Cat.6+ TP (20,40), -- 10GBase-CX4: coax (24,1084),(25,1084),(26,1084),(27,1084), -- 10GBase direct attach: twinax (18,1663),(19,1663), -- 40GBase-SR4: 8xMMF (5,1664),(6,1664), -- 40GBase-LR4: 2xSMF (5,1662),(6,1662), -- 40GBase-ER4: 2xSMF (5,1660),(6,1660), -- 40GBase-FR: 2xSMF (21,1669),(22,1669), -- 100GBase-SR10: 20xMMF (18,1672),(19,1672), -- 100GBase-SR4: 8xMMF (5,1670),(6,1670), -- 100GBase-LR4: 2xSMF (5,1671),(6,1671) -- 100GBase-ER4: 2xSMF -- Cannot add or update a child row: a foreign key constraint fails (`racktables`.`PatchCableOIFCompat`, CONSTRAINT `PatchCableOIFCompat-FK-oif_id` FOREIGN KEY (`oif_id`) REFERENCES `PortOuterInterface` (`id`)) | ||||
| Additional Information | Let me know if you need any more details. | ||||
| Tags | No tags attached. | ||||
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2015-08-19 05:09 | gurujimani | New Issue | |
| 2015-08-19 17:05 | adoom42 | Relationship added | related to 1463 |
| 2015-08-22 19:25 | adoom42 | Note Added: 0002933 | |
| 2015-08-22 19:25 | adoom42 | Assigned To | => adoom42 |
| 2015-08-22 19:25 | adoom42 | Status | new => closed |
| 2015-08-22 19:25 | adoom42 | Resolution | open => fixed |
| 2015-08-22 19:25 | adoom42 | Fixed in Version | => 0.20.11 |
| 2015-08-22 19:25 | adoom42 | Target Version | => 0.20.11 |
