View Issue Details

IDProjectCategoryView StatusLast Update
1853RackTablesdefaultpublic2018-10-23 11:34
ReporternetnivAssigned To 
PriorityurgentSeveritymajorReproducibilityalways
Status closedResolutionduplicate 
Product Version0.21.0 
Target VersionFixed in Version 
Summary1853: Upgrade to 0.21.2 fails due to reload of dictionary before chapter insertition
DescriptionWhen upgrading from a version more than one away from 0.21.2, the upgrade fails because the dictionary appears to be being reloaded before Chapter ID 39 has been insert. This is because during the upgrade path from 0.21.0, it attempts to upgrade to 0.21.1. However, the $dictionary variable does not hold any version metadata and so when reloadDictionary is called, it simply tries to insert the two APC dictionary entries (truncated lines below):


        3689 => array ('chapter_id' => 39, 'dict_value' => '[[APC%GPASS%SMT1500RMI2U
        3690 => array ('chapter_id' => 39, 'dict_value' => '[[APC%GPASS%SMT1500RMI2UNC

As a result of this, I'm not sure that the schema is properly upgraded.
Steps To Reproduce1. Install 0.21.0
2. Upgrade directly to 0.21.2
Additional InformationINSERT INTO Dictionary (dict_key, chapter_id, dict_value, dict_sticky) VALUES (3689, 39, '[[APC%GPASS%SMT1500RMI2U | http://www.apc.com/products/resource/include/techspec_index.cfm?base_sku=SMT1500RMI2U]]', 'yes'),
(3690, 39, '[[APC%GPASS%SMT1500RMI2UNC | http://www.apc.com/products/resource/include/techspec_index.cfm?base_sku=SMT1500RMI2UNC]]', 'yes'),
(3691, 12, '[[NETGEAR%GPASS%GS108 | https://www.netgear.com/business/products/switches/unmanaged/GS108.aspx]]', 'yes'),
(3692, 12, '[[NETGEAR%GPASS%GS105 | https://www.netgear.com/business/products/switches/unmanaged/GS105.aspx]]', 'yes'),
(3693, 13, '[[PROXMOX%GSKIP%Proxmox VE 3.4 | http://pve.proxmox.com/wiki/Roadmap#Proxmox_VE_3.4]]', 'yes'),
(3694, 13, '[[PROXMOX%GSKIP%Proxmox VE 4.0 | http://pve.proxmox.com/wiki/Roadmap#Proxmox_VE_4.0]]', 'yes'),
(3695, 13, '[[PROXMOX%GSKIP%Proxmox VE 4.1 | http://pve.proxmox.com/wiki/Roadmap#Proxmox_VE_4.1]]', 'yes'),
(3696, 13, '[[PROXMOX%GSKIP%Proxmox VE 4.2 | http://pve.proxmox.com/wiki/Roadmap#Proxmox_VE_4.2]]', 'yes'),
(3697, 13, '[[PROXMOX%GSKIP%Proxmox VE 4.3 | http://pve.proxmox.com/wiki/Roadmap#Proxmox_VE_4.3]]', 'yes'),
(3698, 13, '[[PROXMOX%GSKIP%Proxmox VE 4.4 | http://pve.proxmox.com/wiki/Roadmap#Proxmox_VE_4.4]]', 'yes'),
(3699, 13, '[[PROXMOX%GSKIP%Proxmox VE 5.0 | http://pve.proxmox.com/wiki/Roadmap#Proxmox_VE_5.0]]', 'yes'),
(3700, 13, '[[PROXMOX%GSKIP%Proxmox VE 5.1 | http://pve.proxmox.com/wiki/Roadmap#Proxmox_VE_5.1]]', 'yes'),
(3701, 12, '[[TP-Link%GPASS%T1600G-18TS | https://www.tp-link.com/en/products/details/cat-40_T1600G-18TS.html]]', 'yes'),
(3702, 27, '[[Raritan%GPASS%PX3-5514U | http://cdn.raritan.com/product-selector/pdus/PX3-5514U/MPX3-5514U.pdf]]', 'yes'),
(3703, 12, '[[HP Aruba%GPASS%3810M 16SFP+ 2-slot (JL075A) | http://duckduckgo.com/?q=JL075A+manual ]]', 'yes'),
(3704, 13, 'VMWare Hypervisor%GSKIP%VMware ESXi 6.5', 'yes'),
(3705, 17, '[[ Fortinet%GPASS%Fortigate 600D | http://www.fortinet.com/content/dam/fortinet/assets/data-sheets/FortiGate_600D.pdf ]]', 'yes'),
(3706, 13, 'Ubuntu%GSKIP%Ubuntu 18.04 LTS', 'yes'),
(3707, 12, 'MikroTik%GPASS%CRS328-4C-20S-4S+RM', 'yes'),
(3708, 12, 'MikroTik%GPASS%CRS328-24P-4S+RM', 'yes'),
(3709, 13, '[[Debian%GSKIP%Debian 9 (Stretch) | http://debian.org/releases/stretch/]]', 'yes'),
(3710, 12, 'Arista%GPASS%7170-32C', 'yes'),
(3711, 12, 'Arista%GPASS%7170-64C', 'yes'),
(3712, 12, 'Arista%GPASS%7060SX2-48YC6', 'yes'),
(3713, 12, 'Arista%GPASS%7260CX3-64', 'yes')
-- Cannot add or update a child row: a foreign key constraint fails (`racktables_chris`.`Dictionary`, CONSTRAINT `Dictionary-FK-chapter_id` FOREIGN KEY (`chapter_id`) REFERENCES `Chapter` (`id`))
TagsNo tags attached.

Activities

netniv

netniv

2018-10-23 11:34

reporter   ~0003831

System said it failed to post, but didn't actually fail! More notes on the other issue tracker, so closing this one.

Issue History

Date Modified Username Field Change
2018-10-23 11:25 netniv New Issue
2018-10-23 11:34 netniv Status new => closed
2018-10-23 11:34 netniv Resolution open => duplicate
2018-10-23 11:34 netniv Note Added: 0003831