Search Engine: Elastic

Article ID: 124244, created on Jan 22, 2015, last review on Dec 16, 2015

  • Applies to:
  • Plesk Automation 11.5

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.

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF