Plesk update fails:
PLESK_ERROR: Some database entries related to Panel IP addresses are corrupted. Please see kb.plesk.com/en/113826 for the solution.
Plesk database inconsistency. One or more IP address collections are assigned to a non-existent IP address.
- Connect to Plesk server using SSH.
- Back up Plesk database.
- Access Plesk database:
# plesk db
- Find IP address collections with non-existent IP addresses assigned:
MYSQL_LIN: select * from IpAddressesCollections where ipAddressId not in (select id from IP_Addresses);
| ipCollectionId | ipAddressId |
| 245 | 0 |
- Delete orphaned records (copy the corresponding IDs found in the previous step):
MYSQL_LIN: delete from IpAddressesCollections where ipCollectionId=245 and ipAddressId=0;
Note: If there are more than 1 ID in step 4, repeat step 5 for each of them.