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
- Log into Plesk
- Go to Tools & Settings > Diagnose & Repair
- Press the button Repair in the line Plesk Database
Note: In case the warning "Repair Kit fixed all issues it could. If any issues were not fixed, please try fixing them manually or contact Plesk Support." appears, fix issues manually via plesk repair db command-line utility or submit a request to Plesk Technical Support.