Unable to change the IP address type in Plesk: IP address 203.0.113.2 is already allocated to user

Symptoms

Changing the IP address type from dedicated to shared fails with an error:

PLESK_ERROR: IP Address updating finished with errors
Cannot change the type of IP address already allocated to a user. IP address 203.0.113.2 is already allocated to user(s) as shared IP address.

Cause

Plesk database inconsistency.

Resolution

Update the IP address type in the Plesk database.

1. Connect to the Plesk server via SSH.

2. Backup the Plesk database:

   # plesk db dump > psa_backup.sql

3. Access the Plesk database:

   # plesk db

4. Get the affected IP address' ID:

   MYSQL_LIN: SELECT id FROM IP_Addresses WHERE ip_address = "203.0.113.2";

5. Update the ip_pool table and set the type to shared:

   MYSQL_LIN: UPDATE ip_pool SET type = "shared" WHERE ip_address_id = "1";

   Note: Replace the ip_address_id value with the one obtained in Step 4.