Domains show Plesk default page: web service cannot operate: the IP address list with ID 31 is empty

Symptoms

• All domains show Plesk default page;

• Checking database for inconsistencies return an error:

  # plesk repair db -n
  Inconsistency in the table 'DomainServices' for the column
  ipCollectionId: Web service cannot operate: the IP address list with
  ID 101 is empty 

  There are no configuration files for the domains in /etc/httpd/conf/plesk.conf.d/vhosts/;

Cause

Inconsistency in Plesk database after manual IP removal.

Resolution

1. Log in to the server via SSH;

2. Backup Plesk database;

3. Find the ipAddressId value that should be used in the IpAddressesCollections table:

   # plesk db "select id,ip_address,status from IP_Addresses"
   +----+-------------+--------+
   | id | ip_address  | status |
   +----+-------------+--------+
   | 1  | 203.0.113.2 | 0      |
   +----+-------------+--------+

4. Replace missing record - assign one of the IP addresses from step 3 to ID from the error message. For example:

   # plesk db "insert into IpAddressesCollections values(101, 1)";

5. Repair broken configuration files:

   # plesk repair web -y