Symptoms
Update named task fails with the following output:
Update named ns1.provider.ru(1)
Last execution output
org.hibernate.exception.ConstraintViolationException: could not execute statement
In the logs of failed tasks one may find the following entries:
Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "domains" violates foreign key constraint "domain_hosting_bindings_fk3" on table "domain_hosting_bindings"
Detail: Key (domain_id)=(741) is still referenced from table "domain_hosting_bindings".
domain_id=741 - is the cause of this task failure. It could be checked in OA PCP by searching the domain with this ID.
Cause
This is caused by POA-92638 and APS-21892
Resolution
The aforementioned issues were fixed in OA 6.0.4