View Issue Details

IDProjectCategoryView StatusLast Update
1411RackTablesdefaultpublic2015-03-11 16:04
Reportertuskes Assigned To 
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionunable to reproduce 
PlatformLinuxOSCentOSOS Version6.4
Product Version0.20.10 
Summary1411: upgade from 0.20.5 to 0.20.10
DescriptionI 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 InformationI go back to the snapshot before the installation, and install 0.20.8 first.
TagsNo tags attached.

Activities

tuskes

tuskes

2015-02-05 16:44

reporter   ~0002687

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
infrastation

infrastation

2015-02-12 13:56

administrator   ~0002693

What does the query below return?

SELECT * FROM PortInnerInterface;
adoom42

adoom42

2015-03-11 16:04

administrator   ~0002769

Closing due to lack of response. Re-open if you can provide the requested info.

Issue History

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