View Issue Details
ID | Project | Category | View Status | Date Submitted | Last Update |
---|---|---|---|---|---|
2065 | RackTables | default | public | 2022-05-31 10:57 | 2022-06-03 10:12 |
Reporter | smash | Assigned To | infrastation | ||
Priority | normal | Severity | major | Reproducibility | have not tried |
Status | closed | Resolution | no change required | ||
Product Version | 0.21.5 | ||||
Summary | 2065: error update 0.21.5 ? 0.22.0 | ||||
Description | everything goes fine apart this one: Executing batch 'dictionary' The following queries failed: 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`.`Dictionary`, CONSTRAINT `Dictionary-FK-chapter_id` FOREIGN KEY (`chapter_id`) REFERENCES `Chapter` (`id`)) | ||||
Tags | No tags attached. | ||||
mysql> SELECT * FROM Chapter WHERE id < 10000; | |
MariaDB [racktables]> SELECT * FROM Chapter WHERE id < 10000; +------+--------+------------------------------+ | id | sticky | name | +------+--------+------------------------------+ | 1 | yes | ObjectType | | 11 | no | server models | | 12 | no | network switch models | | 13 | no | server OS type | | 14 | no | switch OS type | | 16 | no | router OS type | | 17 | no | router models | | 18 | no | disk array models | | 19 | no | tape library models | | 21 | no | KVM switch models | | 23 | no | console models | | 24 | no | network security models | | 25 | no | wireless models | | 26 | no | fibre channel switch models | | 27 | no | PDU models | | 28 | no | Voice/video hardware | | 29 | no | Yes/No | | 30 | no | network chassis models | | 31 | no | server chassis models | | 32 | no | virtual switch models | | 33 | no | virtual switch OS type | | 34 | no | power supply chassis models | | 35 | no | power supply models | | 36 | no | serial console server models | | 37 | no | wireless OS type | | 38 | no | management interface type | | 9999 | no | multiplexer models | +------+--------+------------------------------+ 27 rows in set (0.002 sec) |
|
INSERT INTO Chapter (`id`, `sticky`, `name`) VALUES (39,'no','UPS models'); After that retrying the failed query should work. |
|
MariaDB [racktables]> INSERT INTO Chapter (`id`, `sticky`, `name`) VALUES (39,'no','UPS models'); ERROR 1062 (23000): Duplicate entry 'UPS models' for key 'name' |
|
ariaDB [racktables]> SELECT * FROM Chapter where name='UPS models'; +-------+--------+------------+ | id | sticky | name | +-------+--------+------------+ | 10002 | no | UPS models | +-------+--------+------------+ 1 row in set (0.001 sec) |
|
That explains it, and you should have experienced a related query error when upgrading to 0.21.2 a long time ago. Anyway, if you rename the custom chapter (id=10002) to "my UPS models" and then retry doing as indicated above, this should address the issue. Afterwards you might want to move the custom UPS chapter contents into the one that now comes with RackTables, or just leave it as is. |
|
thanks | |
You are welcome. | |
Date Modified | Username | Field | Change |
---|---|---|---|
2022-05-31 10:57 | smash | New Issue | |
2022-06-01 10:22 | infrastation | Note Added: 0004397 | |
2022-06-02 07:05 | smash | Note Added: 0004401 | |
2022-06-02 10:16 | infrastation | Note Added: 0004403 | |
2022-06-02 11:28 | smash | Note Added: 0004405 | |
2022-06-02 11:30 | smash | Note Added: 0004407 | |
2022-06-02 12:12 | infrastation | Note Added: 0004409 | |
2022-06-03 07:16 | smash | Note Added: 0004411 | |
2022-06-03 07:16 | smash | File Added: image.png | |
2022-06-03 10:12 | infrastation | Assigned To | => infrastation |
2022-06-03 10:12 | infrastation | Status | new => closed |
2022-06-03 10:12 | infrastation | Resolution | open => no change required |
2022-06-03 10:12 | infrastation | Note Added: 0004413 |