Symptoms
Symptoms vary depending on the domain type and Plesk version:
-
The following error occurs in Plesk:
external error: Unable to find service node for web service on domain with id=10
-
Empty
/usr/local/psa/admin/conf/generated/<file_name>.include
files for domains with 'Forwarding' hosting type -
No new
/usr/local/psa/admin/conf/generated/<file_name>.include
files generated after changing properties of domains with Forwarding hosting type
Cause
The psa.IpAddressesCollections
table in Plesk is corrupted.
Diagnostics
-
Connect to the server via SSH.
-
Perform the appropriate diagnostic actions according to the following conditions:
Run the following command:
# plesk db 'select * from IpAddressesCollections where ipAddressId = 0'
+----------------+-------------+
| ipCollectionId | ipAddressId |
+----------------+-------------+
| 11 | 0 |
| 12 | 0 |
| 13 | 0 |
| 15 | 0 |
| 18 | 0 |
| 19 | 0 |
| 20 | 0 |
+----------------+-------------+If
ipAddressId
value is0
, then references between domains and IP addresses have been broken.
Resolution
Login to the server over SSH
-
-
Back up the Plesk database with the below command before making any modifications:
# plesk db dump psa > psa`date +%F_%H.%M`.sql
-
Determine which
ipAddressId
should correspond to whichipCollectionId
:# plesk db "select domains.displayName as 'Domains', DomainServices.type as 'Service', IpAddressesCollections.ipCollectionId as 'IpAddressesCollections.ipCollectionId', IpAddressesCollections.ipAddressId as 'Current value', dom_param.val as 'Should be' from domains, DomainServices, IpAddressesCollections, dom_param where IpAddressesCollections.ipAddressId = 0 and IpAddressesCollections.ipCollectionId = DomainServices.ipCollectionId AND DomainServices.dom_id = domains.id AND dom_param.dom_id = domains.id and dom_param.param like 'ip%_addr_id'"
+----------+--------+---------------------------------------+--------------+-----------+
| Domains |Service | IpAddressesCollections.ipCollectionId | Current value| Should be
+----------+--------+---------------------------------------+--------------+-----------+
| dom3.tld | mail | 19 | 0 | 3 |
| dom3.tld | web | 20 | 0 | 3 |
| fwd.com | mail | 13 | 0 | 1 |
| fwd.com | web | 15 | 0 | 1 |
| fwd2.com | web |  …
-