Unable to update domains settings: Unable to find service node for ip address with id=0

Created:

2016-11-16 13:22:45 UTC

Modified:

2017-08-16 17:12:04 UTC

1

Was this article helpful?


Have more questions?

Submit a request

Unable to update domains settings: Unable to find service node for ip address with id=0

Applicable to:

  • Plesk 12.5 for Linux
  • Plesk 12.0 for Linux

Symptoms

While trying to change domain settings, restore domain backup or changing a customer to another provider (reseller), the following error is shown:

Unable to find service node for ip address with id=0

The following warning may be shown running Plesk autoinstaller:

WARNING: Some database entries related to Panel IP addresses are corrupted.

Cause

Database inconsistency. Duplicate entries in psa.IpAddressesCollections table.

Resolution

  1. Create backup of psa database:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysqldump -uadmin psa > backup_psa.sql
  2. Log in to Plesk database:

    # MYSQL_PWD=`cat /etc/psa/.psa.shadow` mysql -u admin psa
  3. Find duplicate entries:

    mysql> select * from IpAddressesCollections where ipCollectionId in (select ipCollectionId from IpAddressesCollections where ipAddressId=0);
    +----------------+-------------+
    | ipCollectionId | ipAddressId |
    +----------------+-------------+
    | 10 | 0 |
    | 10 | 1 |
    | 12 | 0 |
    | 12 | 1 |
    | 13 | 0 |
    | 13 | 1 |
    +----------------+-------------+
    6 rows in set (0.00 sec)
  4. Make sure that there is no IP address with id=0:

    mysql> select * from IP_Addresses where id=0;
    Empty set (0.00 sec)
  5. Remove all duplicate entries with ipAddressId=0:

    mysql> delete from IpAddressesCollections where ipAddressId = 0;
Have more questions? Submit a request
Please sign in to leave a comment.