View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
1411 | RackTables | default | public | 2015-02-05 16:23 | 2015-03-11 16:04 |
Reporter | tuskes | Assigned To | |||
Priority | normal | Severity | minor | Reproducibility | have not tried |
Status | closed | Resolution | unable to reproduce | ||
Platform | Linux | OS | CentOS | OS Version | 6.4 |
Product Version | 0.20.10 | ||||
Summary | 1411: upgade from 0.20.5 to 0.20.10 | ||||
Description | I got failure during upgrade from 0.20.5 to 0.20.10 Still I do not know what does it affect. Executing batch '0.20.8' done Executing batch '0.20.9' The following queries failed: INSERT INTO PortInnerInterface (id, iif_name) VALUES (12, 'CFP2'),(13,'CPAK') -- Duplicate entry '12' for key 'PRIMARY' INSERT INTO PortInterfaceCompat (iif_id, oif_id) VALUES (12,1589),(12,1669),(12,1670),(12,1671),(12,1672),(12,1673),(12,1674), (13,1590),(13,1669),(13,1670),(13,1671),(13,1672),(13,1673),(13,1674) -- Cannot add or update a child row: a foreign key constraint fails (`racktables_db`.`PortInterfaceCompat`, CONSTRAINT `PortInterfaceCompat?FK?iif_id` FOREIGN KEY (`iif_id`) REFERENCES `PortInnerInterface` (`id`)) Executing batch '0.20.10' done | ||||
Additional Information | I go back to the snapshot before the installation, and install 0.20.8 first. | ||||
Tags | No tags attached. | ||||
Same issue when upgraded from 0.20.8 to 0.20.9 Upgrade path 0.20.8 ? 0.20.9 Executing batch '0.20.9' The following queries failed: INSERT INTO PortInnerInterface (id, iif_name) VALUES (12, 'CFP2'),(13,'CPAK') -- Duplicate entry '12' for key 'PRIMARY' INSERT INTO PortInterfaceCompat (iif_id, oif_id) VALUES (12,1589),(12,1669),(12,1670),(12,1671),(12,1672),(12,1673),(12,1674), (13,1590),(13,1669),(13,1670),(13,1671),(13,1672),(13,1673),(13,1674) -- Cannot add or update a child row: a foreign key constraint fails (`racktables_db`.`PortInterfaceCompat`, CONSTRAINT `PortInterfaceCompat?FK?iif_id` FOREIGN KEY (`iif_id`) REFERENCES `PortInnerInterface` (`id`)) Executing batch 'dictionary' done |
|
What does the query below return? SELECT * FROM PortInnerInterface; |
|
Closing due to lack of response. Re-open if you can provide the requested info. | |
Date Modified | Username | Field | Change |
---|---|---|---|
2015-02-05 16:23 | tuskes | New Issue | |
2015-02-05 16:44 | tuskes | Note Added: 0002687 | |
2015-02-12 13:56 | infrastation | Note Added: 0002693 | |
2015-02-16 06:49 | infrastation | Status | new => feedback |
2015-03-11 16:04 | adoom42 | Note Added: 0002769 | |
2015-03-11 16:04 | adoom42 | Status | feedback => closed |
2015-03-11 16:04 | adoom42 | Resolution | open => unable to reproduce |