Unable to install Plesk updates: Some database entries related to Panel IP addresses are corrupted

Created:

2016-11-16 13:23:44 UTC

Modified:

2017-08-16 16:28:02 UTC

7

Was this article helpful?


Have more questions?

Submit a request

Unable to install Plesk updates: Some database entries related to Panel IP addresses are corrupted

Applicable to:

  • Plesk for Linux

Symptoms

Plesk updates cannot be installed with the warning:

PLESK_INFO: 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 is assigned to a non-existent IP address.

Resolution

  1. Login to the server over SSH

  2. Backup a Plesk database
  3. Find IP address collections with non-existent IP addresses assigned:

    MYSQL_LIN: select * from IpAddressesCollections where ipAddressId not in (select id from IP_Addresses);

  4. Delete orphaned records (copy the corresponding IDs found on the step 2):

    MYSQL_LIN: delete from IpAddressesCollections where ipCollectionId=6 and ipAddressId=0;

Have more questions? Submit a request
Please sign in to leave a comment.