Database Backup Error

bdennie

We just restored a cPanel account on an Enhance server. The site is working with no issues but the backup keeps getting an error for the database. Where do I get more details on the error? The error just says "Failed to complete backup"

Adam

In the "activity log" on the main dashboard when logged in as the master organisation, the error should be logged. Click "..." for the full error info.

bdennie

Thank you for the reply. I had to update in order to see Activity Log. I can see the error now but not sure of the issue. Do you know what this means

"error": {
"content": {
"detail": {
"code": "internal",
"message": "Command /usr/bin/mysqldump failed with non-zero error: 2"
}
},
"type": "error"

xyzulu

I've seen this error before.
Are you running the latest version of enhance? What about the underlying packages ie Docker (have you updated your server software)?

Adam

If you also update appcd to the latest version you should get a more verbose error.

bdennie

Thank you and we are making progress here. Here is updated error

"context": {
"error": {
"content": {
"detail": {
"code": "internal",
"message": "Command /usr/bin/mysqldump failed with non-zero error: 2. Stderr: mysqldump: Couldn't execute 'FLUSH TABLES': Access denied; you need (at least one of) the RELOAD privilege(s) for this operation (1227)\n"
}
},
"type": "error"

I did have to update appcd from 2.1 to 2.2.2. Doing some looking into this error it sounds like this happens when the backup is run as a user instead of root. Does the backup not run as root user?

Adam

Could you su to the website user please and run mysqldump --version? Or alternatively send a support ticket? The backup is not performed as root but you should not be getting that error.

bdennie

I just submitted a support ticket. Thank you for your help on this. Will see what support finds as may be faster this way if they want any access to look at it directly.