Unable to delete IP address in Plesk: The IP address 203.0.113.2 is already used for hosting.

Symptoms

• Removing the additional IP address 203.0.113.2 with no sites and resellers from Tools & Settings > IP Addresses shows an error:

  Error: The IP address 203.0.113.2 is already used for hosting.

• BIND DNS was removed from the server

• After BIND DNS service removal IP addresses were changed for all subscriptions

Cause

Plesk bug with the ID #PPPM-11601 "The dns_recs table in Plesk database contains old DNS records". It is planned to be fixed in future product updates.

Resolution

Until the bug is fixed, refer to the following workaround:

1. Connect to the server via SSH

2. Create Plesk database backup

   # plesk db dump psa > /root/psa_dump.sql

3. Run the following commands to update the old IP address for all subscriptions in the dns_recs of the Plesk database (make sure to replace new_ip_address and old_ip_address with the actual IP addresses):

   # plesk db "update dns_recs set val='new_ip_address' where val='old_ip_address';"

   and

   # plesk db "update dns_recs set displayVal='new_ip_address' where displayVal='old_ip_address';"

4. Delete old IP address in Tools & Settings > Tools & Resources > IP Addresses