Symptoms

Update List of templates installed to HW Node task fails with the following error:

Foreign key 'vz_ve_configs_fk0' violation while executing ' DELETE FROM vz_templates WHERE origin = ? AND NOT EXISTS (SELECT 1 FROM hn_templates WHERE vz_templates.template_id = hn_templates.template_id)'.

The same error may appear in case of a hardware node removal.

Checking the faulty OS template in the CP, there are still VEs associated with it, but no such VEs in the VE list are displayed.

Cause

A database inconsistency related to DB entries about VZ containers and their configuration.

Resolution

Contact Odin Technical Support to apply resolution.

Internal content

Link on internal Article