On October 19, 2021, we have enabled single-sign-on for our Plesk Support Center to provide a seamless login/account experience. This implies that you’ll be able to use a single account across any of our web-facing properties.
If you had already registered your account at Plesk 360 (formerly known as My Plesk) please use one for login. Otherwise please re-register it using the same email address as your existing Zendesk login (support account). It’s essential that you use the same email address on our support center to ensure that your tickets stay attached to the same account.

Diagnose & Repair tool detected issues with the database: Checking the Plesk database using the native database server tools

Follow

Comments

6 comments

  • Avatar
    Stefano Sudati (Edited )

    Hello

    What should I do?

    plesk repair db

    RESULTS:

    Checking the Plesk database using the native database server tools .. [OK]

    Checking the structure of the Plesk database ........................ [OK]

    Checking the consistency of the Plesk database

    Inconsistency in the table 'apsResources' for the column registryId:
    There is no object in the 'apsc' database in the table
    'aps_registry_object' with UID =
    fbaf8e97-f8ca-424b-81ad-e1c247afd4ee .............................. [ERROR]
    Remove the corresponding rows from the table 'apsResources'? [Y/n]

    Can I safely cancel it? Or not?

    0
    Comment actions Permalink
  • Avatar
    Julian Bonpland Mignaquy (Edited )

    Hi Stefano Sudati yes you can cancel the task safely. The warning tells you that there are inconsistencies in the apsc database.

    I recommend the following: backup psa and apsc via ssh:

    • plesk db dump psa > psa.sql
    • plesk db dump apsc > apsc.sql

    Repair all inconsistencies with the -y option:

    • plesk repair db -y -v

     

     

    -1
    Comment actions Permalink
  • Avatar
    Stefano Sudati (Edited )

    Hi Julian

    Many Tnx

    Could you please write to me if it didn't work how to go back?

    1
    Comment actions Permalink
  • Avatar
    Stefano Sabino (Edited )

    Checking the consistency of the Plesk database

    The following domains are assigned to already removed IP addresses. 
    Reassign the domains to existing IP addresses:  .................................................................. [ERROR]

     

    Error messages: 1; Warnings: 0; Errors resolved: 0

    Dosnt work 

    • plesk db dump psa > psa.sql
    • plesk db dump apsc > apsc.sql

    Repair all inconsistencies with the -y option:

    • plesk repair db -y -v
    0
    Comment actions Permalink
  • Avatar
    Stefano Sabino (Edited )

    Database problem not solved

    The operation failed with the following error: {"id":1,"cmd":"plesk repair db -y","type":"progress","message":"Checking the Plesk database using the native database server tools","level":0} {"id":1,"cmd":"plesk repair db -y","type":"success","message":"Checking the Plesk database using the native database server tools","level":0} {"id":2,"cmd":"plesk repair db -y","type":"progress","message":"Checking the structure of the Plesk database","level":0} {"id":2,"cmd":"plesk repair db -y","type":"success","message":"Checking the structure of the Plesk database","level":0} {"id":3,"cmd":"plesk repair db -y","type":"progress","message":"Checking the consistency of the Plesk database","level":0} {"id":4,"cmd":"plesk repair db -y","type":"error","message":"The following domains are assigned to already removed IP addresses. Reassign the domains to existing IP addresses:","level":1}
     
    0
    Comment actions Permalink
  • Avatar
    Benjamin Weßel

    Hello Stefano Sabino,

    Please open a support request. We will then investigate this specific problem in a support ticket.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request