Applicable to:
- Plesk for Linux
Symptoms
-
Unable to synchronize subscription with it's service plan:
PLESK_WARN: Warning: Unable to perform the sync
-
The following errors appear in
/var/log/plesk/panel.log
:CONFIG_TEXT: 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:
PLESK_WARN: 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
- Connect to the server via SSH
-
Create a dump of psa database:
# plesk db dump psa > psa`date +%F-%s`.sql
-
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"
- Repair Plesk database to fix any broken references left by the previous delete:
# plesk repair db
Comments
0 comments
Please sign in to leave a comment.