Unable to create new subscription: Domain already exists

Refers to:

  • Plesk 11.5 for Linux
  • Plesk 12.0 for Linux

Created:

2016-11-16 12:54:18 UTC

Modified:

2016-12-21 19:29:59 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Unable to create new subscription: Domain already exists

Symptoms

Unable to create new subscription, the following error occurs:

Domain already exists

Cause

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

Resolution

  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.

Have more questions? Submit a request
Please sign in to leave a comment.