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 Wessel

    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