Symptoms
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.
Cause
Plesk database inconsistency. One or more IP address collections are assigned to a non-existent IP address.
Resolution
- 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.