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.

Search Words

Update named ns1.swhirkshost.com(1)

whmcs

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 = ? )'.

Foreign key 'domain_hosting_bindings_fk2'

update or delete on table "subscriptions" violates foreign key constraint

Reason: Foreign key 'domain_hosting_bindings_fk2'

unexpected error

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF