Symptoms
Subscription removal fails wtih error:
Error message or request description : Cannot delete 1 customer account(s). Reason: Foreign key
'domain_hosting_bindings_fk2' violation while executing ' DELETE FROM
subscriptions WHERE sub_id = ? AND sub_id != 1 AND NOT EXISTS (SELECT 1 FROM
st_resources st JOIN subs_resources sr ON (st.src_rt_instance_id =
sr.rt_instance_id) WHERE sr.sub_id = ? )'
Cause
This is software issue PPA-2313: a database transaction was not finished because of a deadlock that leads to a database inconsistency.
Resolution
The issue was fixed in Plesk Automation update 10. Install latest updates in order to fix the issue PPA-2313 permanently. In order to remove failed subscription please submit a request to the Odin Technical Support as this action requires manual database intervention.