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

Symptoms

When pressing the Check All button in line Tools & Settings > Diagnose & Repair in Plesk Database, a warning that is similar to the following appears:

The operation failed with the following error: {"id":1,"cmd":"plesk repair db -n","type":"progress","message":"Checking the Plesk database using the native database server tools","level":0} {"id":1,"cmd":"plesk repair db -n","type":"success","message":"Checking the Plesk database using the native database server tools","level":0} {"id":2,"cmd":"plesk repair db -n","type":"progress","message":"Checking the structure of the Plesk database","level":0} {"id":2,"cmd":"plesk repair db -n","type":"success","message":"Checking the structure of the Plesk database","level":0} {"id":3,"cmd":"plesk repair db -n","type":"progress","message":"Checking the consistency of the Plesk database","level":0} {"id":3,"cmd":"plesk repair db -n","type":"warning","message":"Checking the consistency of the Plesk database","level":0,"details":"Inconsistency in the table 'UserSettings' for the column userId: No rows in the table 'smb_users' with id = 5"} {"id":4,"cmd":"plesk repair db -n","type":"warning","message":"Inconsistency in the table 'smb_serviceInstances' for the column externalId: No rows in the table 'smb_apsInstances' with registryResourceId = 7edbb73e-aecb-4d07-bf53-cf5513b2a7b4","level":1} {"id":5,"cmd":"plesk repair db -n","type":"error","message":"Inconsistency in the table 'smb_serviceInstances' for the column externalId: There is no object in the 'apsc' database in the table 'aps_registry_object' with UID = 7edbb73e-aecb-4d07-bf53-cf5513b2a7b4","level":1}

1 issue(s) detected. Show issues

Cause

Inconsistency in the Plesk database (psa).

Resolution