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

• 

  Stefano Sudati January 06, 2021 10:23 (Edited January 07, 2021 09:51)

  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
• 

  Julian Bonpland Mignaquy January 11, 2021 12:46 (Edited January 11, 2021 12:47)

  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
• 

  Stefano Sudati January 11, 2021 13:40 (Edited January 11, 2021 13:41)

  Hi Julian

  Many Tnx

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

  1

  Comment actions Permalink
• 

  Stefano Sabino May 07, 2021 05:39 (Edited May 07, 2021 11:13)

  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
• 

  Stefano Sabino May 07, 2021 13:13 (Edited May 07, 2021 18:08)

  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
• 

  Benjamin Weßel May 12, 2021 14:45

  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.