Applicable to:
Plesk 11.x for Linux Plesk 12.0 for Linux Symptoms
Unable to create new subscription, the following error occurs:
Error: Domain already exists
Cause
Database inconsistency. The number of domains does not match the number of subscriptions.
Resolution1.Connect to the server via SSH;
2.Access Plesk database;
3.Check for entries in domains table of psa database that have no related entries in Subscriptions table:
select id,name from domains where webspace_id=0 and id not in (select object_id from Subscriptions where object_type='domain');
+------+-------------------------+
| id | name |
+------+-------------------------+
| 1499 | example.com |
+------+-------------------------+
1 row in set (0.01 sec)
4. If such entries are revealed, check that there are no entries with the same domain ID in hosting table:
select * from hosting where dom_id=1499;
Empty set (0.00 sec)
5.If no related entries in hosting table are found, then create dump of psa database and remove founded orphaned entries from domains table:
delete from domains where id=1499;