Search Engine: Elastic

Article ID: 131777, created on Nov 15, 2017, last review on Nov 15, 2017

  • Applies to:
  • Operations Automation 7.0

Symptoms

A QMail host is scheduled to be removed. Task Cleanup packages on host fails:

Plesk.ExSystem: javax.ejb.EJBTransactionRolledbackException: Failed to process executeDeinstallSequence for pkgId: 5641, ex message is: org.hibernate.exception.ConstraintViolationException: could not execute statement

Failure reason in the core.log:

Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "services" violates foreign key constraint "sa_mail_services_fk0" on table "sa_mail_services"
osscore.pa.isp-net.nl :   Detail: Key (service_id)=(93) is still referenced from table "sa_mail_services".

Cause

Some packages were removed from the node manually, so the order of removal is shattered. Spam Assassin service references were not properly removed as a result.

Resolution

Please contact Odin Technical Support to fix the issue.

5356b422f65bdad1c3e9edca5d74a1ae caea8340e2d186a540518d08602aa065 e12cea1d47a3125d335d68e6d4e15e07 0871c0b47b3b86ae3b1af4c2942cd0ce 1941880841f714e458ae4dc3d9f3062d

Email subscription for changes to this article
Save as PDF