Subdomain creation fails: IP address with ID '7' does not exist

Created:

2016-11-16 13:14:36 UTC

Modified:

2017-04-24 11:42:02 UTC

0

Was this article helpful?


Have more questions?

Submit a request

Subdomain creation fails: IP address with ID '7' does not exist

Applicable to:

  • Plesk 11.0 for Linux

Symptoms

Subdomain creation fails with error:

    Failed domain creation: Unable to update domain data: IP address with ID '7' does not exist

Cause

Orphaned record in Psa database, ip_pool table.

Resolution

  1. Create backup of Psa database:

    mysqldump -uadmin -p`cat /etc/psa/.psa.shadow ` psa >psa1.dump
  2. Check IDs of IP addresses in Plesk database:

    mysql -uadmin -p`cat /etc/psa/.psa.shadow ` psa

    mysql> select id,ip_address from IP_Addresses;
    +----+--------------+
    | id | ip_address |
    +----+--------------+
    | 4 | 123.45.67.89 |
    | 6 | 123.45.67.80 |
    +----+--------------+
    2 rows in set (0.00 sec)
  3. Make sure that the same IDs are set in ip_pool table:

    mysql> select * from ip_pool;
    +----+---------------+-----------+
    | id | ip_address_id | type |
    +----+---------------+-----------+
    | 1 | 4 | shared |
    | 1 | 6 | shared |
    | 1 | 7 | exclusive |
    +----+---------------+-----------+

If you see that there is record in ip_pool table with ip_address_id that is absent in IP_Addresses table, please delete it as below:

    mysql> delete from ip_pool where ip_address_id=7;
Query OK, 1 row affected (0.36 sec)
Have more questions? Submit a request
Please sign in to leave a comment.