Symptoms
Cleanup packages on host task fails:
ERROR [task:7061742:323 Thread-2-(ActiveMQ-client-global-threads-980324746):792 pau]: c.p.p.s.j.a.JobBase task 7061742 completed with exception:
javax.ejb.EJBException: javax.ejb.EJBTransactionRolledbackException: Transaction rolled back
Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on table "hosts" violates foreign key constraint "components_fk_0" on table "components"
Detail: Key (host_id)=(90) is still referenced from table "components".
First task attempt failed with:
DBG [task:7061741:222 Thread-19-(ActiveMQ-client-global-threads-980324746):1705 pau]: c.p.p.s.m.e.MessengerBean loading user #259 mail subscriptions
.....
DBG [task:7061741:222 Thread-19-(ActiveMQ-client-global-threads-980324746):1705 pau]: c.p.p.c.ServiceInvoker OperationProcessor invocation failedjavax.ejb.EJBTransactionRolledbackException: javax.ejb.EJBTransactionRolledbackException: Failed to process executeDeinstallSequence for pkgId: 4576, ex message is: Removing a detached instance com.parallels.pa.service.messenger.domain.MailSubscription#com.parallels.pa.service.messenger.domain.MailSubscription$MailSubscriptionPK@5790adea
Also it could be seen in core.log that some of the components have been uninstalled from the corresponding node during the first attempt, but in OA DB all of the components for this node are marked as Not Uninstalled:
Cause
Software-related issue #POA-111936: "task 'Cleanup packages on host' is not retryable".
Resolution
Contact pta@odin.com or TAM to trace the status of the issue.