Symptoms

It is not possible to "Unsubscribe" a subscription in Operations Automation or "Delete" a domain due to the following error:

javax.persistence.PersistenceException: org.hibernate.exception.ConstraintViolationException: could not execute statement

The following error message can be found in poa.log on the Management Node:

Sep 22 12:34:56 osscore : Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "subscriptions" violates foreign key constraint "domain_hosting_bindings_fk2" on table "domain_hosting_bindings"   Detail: Key (sub_id)=(1234567) is still referenced from table "domain_hosting_bindings".

Cause

Subscription and/or domain removal procedure fails in the circumstances when there are invalid records in `domain_hosting_bindings' table. The issue is caused by program code defect #POA-101582.

Resolution

The fix is planned to be included in one of future product updates.

Please contact Odin Technical Support in order to complete the problematic subscription/domain.

Internal content

Link on internal Article