View Issue Details

IDProjectCategoryView StatusLast Update
2065RackTablesdefaultpublic2022-06-03 10:12
Reportersmash Assigned Toinfrastation  
PrioritynormalSeveritymajorReproducibilityhave not tried
Status closedResolutionno change required 
Product Version0.21.5 
Summary2065: error update 0.21.5 ? 0.22.0
Descriptioneverything 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`))
TagsNo tags attached.

Activities

infrastation

infrastation

2022-06-01 10:22

administrator   ~0004397

mysql> SELECT * FROM Chapter WHERE id < 10000;
smash

smash

2022-06-02 07:05

reporter   ~0004401

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)
infrastation

infrastation

2022-06-02 10:16

administrator   ~0004403

INSERT INTO Chapter (`id`, `sticky`, `name`) VALUES (39,'no','UPS models');

After that retrying the failed query should work.
smash

smash

2022-06-02 11:28

reporter   ~0004405

MariaDB [racktables]> INSERT INTO Chapter (`id`, `sticky`, `name`) VALUES (39,'no','UPS models');
ERROR 1062 (23000): Duplicate entry 'UPS models' for key 'name'
smash

smash

2022-06-02 11:30

reporter   ~0004407

ariaDB [racktables]> SELECT * FROM Chapter where name='UPS models';
+-------+--------+------------+
| id | sticky | name |
+-------+--------+------------+
| 10002 | no | UPS models |
+-------+--------+------------+
1 row in set (0.001 sec)
infrastation

infrastation

2022-06-02 12:12

administrator   ~0004409

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.
smash

smash

2022-06-03 07:16

reporter   ~0004411

thanks
image.png (107,409 bytes)   
image.png (107,409 bytes)   
infrastation

infrastation

2022-06-03 10:12

administrator   ~0004413

You are welcome.

Issue History

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