Symptoms
IP address of subscriptions was changed and after that plesk repair db utility shows the error message below for domains with “Forwarding” hosting type:
# plesk repair db -n
The following domains are assigned to already removed IP addresses.
Reassign the domains to existing IP addresses:
example.com ...................................................... [ERROR]
Cause
Product issue:
-
#PPPM-13256 "Changing the IP address for a subscription now correctly updates the IP address of all domains owned by the subscription with the “Forwarding” hosting type."
Fixed in:- Plesk Obsidian 23 November 2021
Resolution
Please consider updating your server:
Workaround
If update is not possible for some reason you may try the following
workaround
-
Login to the server via SSH.
-
Create backup of
psadatabase:# plesk db dump > psa.sql
-
Check what
valis used for all other domains:# plesk db "select domains.name,dom_param.param,dom_param.val from domains, dom_param where domains.id=dom_param.dom_id and dom_param.param='ip_addr_id'"
-
Update
dom_param.valwith correct value:# plesk db "update dom_param set val=1 where param='ip_addr_id' and val=9;"
where 1 - is a correct value, 9 - is old wrong value.