Plesk customer can not be deleted: Unable to find service node for ip address with id=

Symptoms

• A customer can not be removed from a Plesk server:

  Unable to find service node for ip address with id=

• There are multiple domains assigned to the already removed IPs in the dom_param table:

  C:> select * from dom_param where param='ip_addr_id' and val not in (select id from IP_Addresses);

• The IpAddressesCollections table is missing some records.

Cause

Database inconsistency after a domain removal.

Resolution

1. Connect to the server via SSH.

2. Create backup of 'psa' database

3. Use the command below to update the dom_param values from the old 2, incorrect IP address to a new 1, correct one:

   # plesk db "update dom_param set val=1 where param='ip_addr_id' and val=2"

4. Check the name of the domain that can not be removed by name:

   # plesk db "select id,name from domains where name='example.com'"
   +------+------------------+
   | id | name |
   +------+------------------+
   | 3398 | example.com |
   +------+------------------+
   1 row in set (0.001 sec)

   4.1. Run the next query using the ID from the above output:

   # plesk db "select ipCollectionId from DomainServices where dom_id=3398"
   +----------------+
   | ipCollectionId |
   +----------------+
   | 5268 |
   | 5269 |
   | 5282 |
   +----------------+
   3 rows in set (0.001 sec)

5. Find which ipCollectionId values from the previous step output are missing:

   # plesk db "select * from IpAddressesCollections where ipCollectionId in ('5282', '5268', '5269')"
   +----------------+-------------+
   | ipCollectionId | ipAddressId |
   +----------------+-------------+
   | 5282 | 1 |
   +----------------+-------------+
   1 row in set (0.000 sec)

6. Add missing values for remaining ipCollectionId:

   # plesk db "insert into IpAddressesCollections values ('5268', '1')"

   # plesk db "insert into IpAddressesCollections values ('5269', '1')"

7. Remove the customer via Plesk GUI.