Article ID: 126462, created on Aug 6, 2015, last review on Aug 6, 2015

  • Applies to:
  • Plesk 12.0 for Linux


Unable to create new subscription, the following error occurs:

Domain already exists


Database inconsistency. The amount of domains does not match the amount of subscriptions.


  1. Check for entries in domains table of psa database that have no related entries in Subscriptions table:

    # plesk database
    mysql> 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 | DOMAIN.TLD              |
    1 row in set (0.01 sec)
  2. If such entries are revealed, check that there are no entries with the same domain ID in hosting table:

    mysql> select * from hosting where dom_id=1499;
    Empty set (0.00 sec)
  3. If no related entries in hosting table are found, then create dump of psa database and remove founded orphaned entries from domains table:

    # mysqldump -uadmin -p`cat /etc/psa/.psa.shadow` psa > psa.dump.sql
    # plesk database
    mysql> delete from domains where id=1499;
  4. If related records persist in hosting table, please contact Odin Technical Support in order to resolve the issue.

Search Words

Unable to create new subscription

Domain already exists

29d1e90fd304f01e6420fbe60f66f838 56797cefb1efc9130f7c48a7d1db0f0c a914db3fdc7a53ddcfd1b2db8f5a1b9c 2a5151f57629129e26ff206d171fbb5f e335d9adf7edffca6a8af8039031a4c7

Email subscription for changes to this article
Save as PDF