The Diagnose & Repair tool fails to resolve the issues with “Plesk Database”: file does not exist or is not executable

Symptoms

The Diagnose & Repair tool fails to resolve issues with “Plesk Database”:

PLESK_ERROR: 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}
…
Execution failed.nCommand: /usr/local/psa/bin/mysqldump.shnArguments: Arrayn(n [0] => –titlen [1] => preresolven)nnDetails: file does not exist or is not executable: /usr/local/psa/bin/mysqldump.sh”,”level”:1}

Cause

This is a Diagnose & Repair tool bug with ID EXTPLESK-2261, which will be fixed future extension updates.

Resolution

1. Connect to the Plesk server via SSH.

2. Repair manually:

   # plesk repair db