Symptoms
-
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';
Cause
Database inconsistency - incorrect IP address is assigned to a DNS record.
Resolution
-
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.
For all the incorrect records via CLI
-
Connect to the server via SSH.
-
Update incorrect records with the correct IP address:
# UPDATE dns_recs SET displayVal = '10.39.91.111' WHERE displayVal = '203.0.113.2';
UPDATE dns_recs SET val = '10.39.91.111' WHERE val = '203.0.113.2';
with