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
Cause
Inconsistency in Plesk database after manual IP removal.
Resolution
-
Connect to the server via SSH
-
Find the affecting domain using ID from error message:
# plesk db "SELECT ipCollectionId, name FROM DomainServices JOIN domains ON dom_id = domains.id WHERE ipCollectionId = 101"
+-----------------+----------------+
| ipCollectionId | name |
+-----------------+----------------+
| 101 | example.com |
+-----------------+----------------+ -
Find the IP address that should be used for the domain:
# grep listen /var/www/vhosts/system/example.com/conf/nginx.conf
listen 203.0.113.2:443 ssl http2;
listen 203.0.113.2:80; -
Find the ID of the IP address to be used:
# plesk db "SELECT id, ip_address FROM IP_Addresses WHERE ip_address = '203.0.113.2'"
+-----+--------------+
| id | ip_address |
+-------+------------+
| 1 | 203.0.113.2 |
+-----+--------------+ -
Insert a record for the IP address from step 3 using ID from the error message and step 5.:
# plesk db "insert into IpAddressesCollections values(101, 1)"
-
Repair broken configuration files:
# plesk repair web -y
with