Article ID: 127127, created on Oct 10, 2015, last review on Oct 10, 2015

  • Applies to:
  • Plesk Automation 11.5

Symptoms

Task for removing webspace fails with error like:

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

Database inconsistency.

Resolution

Contact Odin technical support.

Search Words

domain removing

Cannot delete 1 subscription(s). Reason: {2}

Cannot unsubscribe 1 subscriptions. 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' violation while executing

An unexpected error has occurred during subscription termination: 'PleskAutomation module: 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 = ? )'. at removeSubscription call'

Cannot unsubscribe 1 subscriptions

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

domain_hosting_bindings_fk2

33a70544d00d562bbc5b17762c4ed2b3 caea8340e2d186a540518d08602aa065 e0aff7830fa22f92062ee4db78133079

Email subscription for changes to this article
Save as PDF