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

Created:

2017-06-09 21:00:53 UTC

Modified:

2017-08-08 13:21:25 UTC

0

Was this article helpful?


Have more questions?

Submit a request

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:

ERR [panel] Unable to synchronize subscription 22 with plan 1: 

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 yellow exclamation mark: Unable to sync subscriptions with the service plan In psa database, subscription with id=22 exists, but it's related domain with id=33 does not:

MariaDB [psa]> select * from Subscriptions where id=22;

+-----+-----------+-------------+--------+--------------+--------+--------------------------------------+-------------+
| id | object_id | object_type | locked | synchronized | custom | uuid | external_id |
+-----+-----------+-------------+--------+--------------+--------+--------------------------------------+-------------+
| 22 | 33 | domain | false | true | false | 90e4a9c7-9d06-2c00-6927-7c9b1b8a0ff7 | NULL |
+-----+-----------+-------------+--------+--------------+--------+--------------------------------------+-------------+
1 row in set (0.00 sec)
MariaDB [psa]> select * from domains where id=33;
Empty set (0.00 sec)
MariaDB [psa]> select * from hosting where dom_id=33;
Empty set (0.00 sec)
MariaDB [psa]> select * from dom_param where dom_id=33;
Empty set (0.00 sec)
MariaDB [psa]> select * from DomainServices where dom_id=33;
Empty set (0.00 sec)
MariaDB [psa]> select * from domain_aliases where dom_id=33;
Empty set (0.00 sec)
MariaDB [psa]> select * from subdomains where dom_id=33;
Empty set (0.00 sec)

Cause

Database inconsistency

Resolution

1. Create psa dump according to instructions here.

2. Delete orphan records:

MariaDB [psa]> delete from Subscriptions where id=22;
Have more questions? Submit a request
Please sign in to leave a comment.