Knowledge Base

Unable to repair domains in Plesk using “plesk repair db” utility: The following domains are assigned to already removed IP addresses

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:

How to install Plesk updates

Workaround

If update is not possible for some reason you may try the following

workaround

Login to the server via SSH.
Create backup of psa database:

# plesk db dump > psa.sql
Check what val is 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.val with 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.