Unable to restore or manage subscription: Unable to load object of type IPAddress with id=XX

Symptoms

Error while trying to create, migrate or restore the subscription:

Unexpected Plesk API Error: Unable to load object of type IPAddress with id=XX: IPAddress: unable to select: no such row in the table

Cause

The issue is caused by a database inconsistency: IP pool of customer for whom the subscription is created contains a reference to a non-existent IP address.

Resolution

1. Create databases backup according to How to backup/restore a Plesk database dump? article.

2. Access Plesk database.

3. Verify whether IP address with ID reported in the error message is missing:

   MYSQL_LIN: mysql> select * from psa.IP_Addresses where id=XX;
   0 rows in set (0.00 sec)

4. There are two options:

   If the IP address with ID from an error message is missing from IP_Addresses:

   • Find and remove all references to this IP address from ip_pool table:

     MYSQL_LIN: mysql> select * from ip_pool where ip_address_id=XX;
     +----+---------------+-----------+
     | id | ip_address_id | type |
     +----+---------------+-----------+
     | 1 | XX | exclusive |
     +----+---------------+-----------+
     mysql> delete from ip_pool where ip_address_id=XX;

   OR:

   • Locate ID of the main IP on a server in IP_Addresses table and update tables IP_Addresses, ip_pool, and IpAddressesCollections by replacing ID of the main IP address to XX:

     MYSQL_LIN: mysql> select id, ip_address, main from IP_Addresses where main='true';
     +----+-------------+-------+
     | id | ip_address | main |
     +----+-------------+-------+
     | XX | 203.0.112.2 | true |
     +----+-------------+-------+
     mysql> update IP_Addresses set id=XX where id=YY;
     mysql> update ip_pool set ip_address_id=XX where ip_address_id=YY;
     mysql> update IpAddressesCollections set ipAddressId=XX where ipAddressId=YY;

   If IP address with ID from an error message is present in IP_Addresses and this is the only IP address:

   • MYSQL_LIN: mysql> select id, ip_address from psa.IP_Addresses;
     +----+-----------------+
     | id | ip_address |
     +----+-----------------+
     | XX | 203.0.112.2 |
     +----+-----------------+
     1 row in set (0.00 sec)

   • Verify whether ID of IP address from error message is present in IpAddressesCollections

     MYSQL_LIN: mysql> select * from psa.IpAddressesCollections where ipAddressId=XX;
     +----------------+-------------+
     | ipCollectionId | ipAddressId |
     +----------------+-------------+
     | 1 | XX |
     | 2 | XX |
     | 3 | XX |
     | 4 | XX |
     +----------------+-------------+
     4 rows in set (0.00 sec)

   • Set proper ID in IpAddressesCollections.ipAddressId to ID of existing IP address:

     MYSQL_LIN: mysql> UPDATE psa.IpAddressesCollections set ipAddressId='YY' where ipAddressId='XX';

5. Recreate configuration files for mail and web services:

   • For Linux:

     # /usr/local/psa/admin/bin/mchk
     # /usr/local/psa/admin/bin/httpdmng --reconfigure-all

   • For Windows:

     C:\> plesk repair web