Unable to synchronize subscription 22 with plan 1: Unable to load object of type BsDomain with id=33: Domain does not exist

Symptoms

• Unable to synchronize subscription with it's service plan:

  Warning: Unable to perform the sync

• The following errors appear in /var/log/plesk/panel.log:

  ERR [panel] Unable to load object of type BsDomain with id=33: Domain does not exist
  ..
  ERR [panel] Task failed: id=348, pid=8109, type=sync-service-plan-worker, error=Unable to load object of type BsDomain with id=33: Domain does not exist.
  ..
  ERR [panel] Task failed: id=346, pid=8100, type=sync-service-plan, error=[[components.tasks.sync-service-plan-worker.error]]

• Service plan with id=1 is marked with a yellow exclamation mark:

  Warning: Unable to sync subscriptions with the service plan

• In the psa database, an entry in subscription table exists, but in domains and related tables not. Use id from error to check. For table `domains` it will be `id`, for table `subscriptions`, it should be `object_id`:

  # plesk db
  mysql> select id, object_id,object_type from Subscriptions where object_id=33 G;

  +----+-----------+-------------+
  | id | object_id | object_type |
  +----+-----------+-------------+
  | 22 |    33     |    domain   |
  +----+-----------+-------------+

  mysql> select * from domains where id=33;
  Empty set (0.00 sec)

  mysql> select * from hosting where dom_id=33;
  Empty set (0.00 sec)

  mysql> select * from dom_param where dom_id=33;
  Empty set (0.00 sec)

  mysql> select * from DomainServices where dom_id=33;
  Empty set (0.00 sec)

  mysql> select * from domain_aliases where dom_id=33;
  Empty set (0.00 sec)

  mysql> select * from subdomains where dom_id=33;
  Empty set (0.00 sec)

• The plesk bin subscription -l  command fails as follows:

  # plesk bin subscription -l 
  Unable to load object of type BsDomain with id=33: Domain does not exist.

Cause

Plesk database inconsistency.

Resolution

1. Connect to the server via SSH

2. Create a dump of psa database:

   # plesk db dump psa > psa`date +%F-%s`.sql

3. Delete orphan records:

   # plesk db "delete from Subscriptions where id=22"

   # plesk db "delete from PlansSubscriptions where subscription_id=22"

   # plesk db "delete from SubscriptionProperties where subscription_id=22"

4. Repair Plesk database to fix any broken references left by the previous delete:

   # plesk repair db