Unable to create new subscription: Domain already exists

[sibij]

 
 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.

Resolution

1.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:

Code: [Select]

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:

Code: [Select]

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:

Code: [Select]

delete from domains where id=1499;