Unable to delete an IP address from Plesk > Tools & Settings > IP Address:
Error: IP address cannot be removed because it is used by DNS zone of one or more domains
The following commands show that the address is occupied by a DNS record of a domain hosted in Plesk:
# plesk db
mysql> select * from dns_recs where val='203.0.113.2' or displayVal='203.0.113.2';
Database inconsistency - incorrect IP address is assigned to a DNS record.
Go to Domains > example.com and check the actual IP assigned to the domain:
Go to Domains > example.com > DNS Settings and assign the actual IP address to all records:
For one record
- Click on the required record.
- Alter the IP address field.
- Submit the changes by pressing OK.
- Confirm the changes again with the Update button on the DNS Settings screen.
For all the records at once
Click on the Apply DNS Template button.