View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
1853 | RackTables | default | public | 2018-10-23 11:25 | 2018-10-23 11:34 |
Reporter | netniv | Assigned To | |||
Priority | urgent | Severity | major | Reproducibility | always |
Status | closed | Resolution | duplicate | ||
Product Version | 0.21.0 | ||||
Summary | 1853: Upgrade to 0.21.2 fails due to reload of dictionary before chapter insertition | ||||
Description | When 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 Reproduce | 1. Install 0.21.0 2. Upgrade directly to 0.21.2 | ||||
Additional Information | INSERT 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`)) | ||||
Tags | No tags attached. | ||||