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

Follow

Comments

6 comments

  • Avatar
    Trevor Lorkings

    Plesk 17.0.17 #54
    CentOS Linux 7.5.1804 (Core)

    I get the warning "Some database entries related to Panel IP addresses are corrupted." and have run the DB code which shows no entries for ipAddressId=0, so there are no orphaned records.

    When I run
    select * from IpAddressesCollections
    there are 16 rows of data where ipAddressId is either 1 or 2.

  • Avatar
    Ivan Postnikov

    Hello @Trevor,

    in this case, ipAddressId is not meant to be 0, have used the query (select * from IpAddressesCollections where ipAddressId not in (select id from IP_Addresses);) or modified it somehow?

  • Avatar
    Trevor Lorkings

    Thank you @Ivan

    This is what I get when running the query command. This is the first time I've ever been into SSH to run any plesk db commands so I don't know how to modify anything. I spend most of my time on Windows servers so the SSH command line is alien to me.

  • Avatar
    Ivan Postnikov

    Hi @Trevor, I am glad to know that my advice helped.

  • Avatar
    Trevor Lorkings

    Hi @Ivan , I'm still not sure how your advice of "ipAddressId is not meant to be 0" helps.

    Plesk update warns of "Some database entries related to Panel IP addresses are corrupted" and yet upon investigation it appears I have no records where ipAddressId=0. Does this mean I have no corrupted IP addresses? If so, why is Plesk telling me I have?

  • Avatar
    Ivan Postnikov

    Hello @Trevor,

    Let me explain: the corrupted IP does not necessary has ID 0, it may have other value.

    In your case, this values is 1.

    So, to resolve the issue, you should backup Plesk database (there is a link in this article) and delete rows with such ID, for example:

    delete from IpAddressesCollections where ipCollectionId=1 and ipAddressId=1;

    delete from IpAddressesCollections where ipCollectionId=3 and ipAddressId=1;

    ...

     

    In case further assistance with issue resolution is required, consider submitting a support request.

Please sign in to leave a comment.

Have more questions? Submit a request