Source: icinga Followup-For: Bug #861077 Control: tags -1 patch Dear Maintainer,
It's probably sufficient to fix the case of the constraints as per the attached patch. I've haven't tested this (yet), as I don't know who to reproduce the issue with piuparts. Andreas, how can the upgrade test you performed be reproduced by others using piuparts? Kind Regards, Bas
diff --git a/module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.13.0.sql b/module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.13.0.sql index d0c9a92..ab5608a 100644 --- a/module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.13.0.sql +++ b/module/idoutils/db/pgsql/upgrade/pgsql-upgrade-1.13.0.sql @@ -11,8 +11,8 @@ -- #7765 drop unique constraint -- ----------------------------------------- -ALTER TABLE icinga_servicedependencies DROP CONSTRAINT uq_servicedependencies; -ALTER TABLE icinga_hostdependencies DROP CONSTRAINT uq_hostdependencies; +ALTER TABLE icinga_servicedependencies DROP CONSTRAINT UQ_servicedependencies; +ALTER TABLE icinga_hostdependencies DROP CONSTRAINT UQ_hostdependencies; CREATE INDEX idx_servicedependencies ON icinga_servicedependencies(instance_id,config_type,service_object_id,dependent_service_object_id,dependency_type,inherits_parent,fail_on_ok,fail_on_warning,fail_on_unknown,fail_on_critical); CREATE INDEX idx_hostdependencies ON icinga_hostdependencies(instance_id,config_type,host_object_id,dependent_host_object_id,dependency_type,inherits_parent,fail_on_up,fail_on_down,fail_on_unreachable);