Various actions fail in Plesk: Unable to find service node for ip address with id=XX

Symptoms

• Cannot create subscription or domain in Plesk::

  Error: Unable to find service node for ip address with id=2

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

  ERR [panel] Unable to load object of type BsDomain with id=XX: Domain does not exist.

• Cannot manage Domains > example.com > Web Hosting Access settings:

  Error: Unable to find service node for ip address with id=2

• Cannot select "Send from domain IP addresses and use domain names in SMTP greeting" in Mail Server Settings:

  Error: PleskException IP address with ID '2' does not exist

Cause

Database inconsistency: the
IP_Addresses table has a record(s) with an IP address that does not exist in the
ip_pool
and
dom_param
tables.

Resolution

Note: below steps require advanced technical expertise. Consider contacting Plesk Technical support if you find them too complex.

1. Log in to Plesk via SSH or RDP

2. Create Plesk database backup

3. Identify the problematic IP address:

   # plesk db "select * from ip_pool where ip_address_id not in (select id from IP_Addresses);"
   +----+---------------+--------+
   | id | ip_address_id | type |
   +----+---------------+--------+
   | 1 | 2 | shared |
   +----+---------------+--------+
   1 row in set (0.00 sec)

   # plesk db "select * from dom_param where param='ip_addr_id' and val not in (select id from IP_Addresses);"
   +--------+------------+------+
   | dom_id | param | val |
   +--------+------------+------+
   | 6 | ip_addr_id | 2 |
   +--------+------------+------+
   1 row in set (0.00 sec)

   # plesk db "select * from IP_Addresses where id =2;"
   Empty set (0.00 sec)

   # plesk db "select id, serviceNodeId, ip_address from IP_Addresses;"
   +----+---------------+--------------+
   | id | serviceNodeId | ip_address |
   +----+---------------+--------------+
   | 1 | 1 | x.x.x.x |
   +----+---------------+--------------+
   1 rows in set (0.00 sec)

   In this example, the
ip_pool
and
dom_param
tables include an entry regarding a non-existent IP address (
ip_address_id = 2
);

4. Delete this record from the ip_pool table:

   # plesk db "delete from ip_pool where ip_address_id not in (select id from IP_Addresses);"
   Query OK, 1 row affected (0.00 sec)

5. If non-empty output was received during dom_param
table check on the step 3, contact Plesk Technical support.