Error Dumping mysql databse

[ludolugo]

Hi,
we are having an error when dumping database for backup, the error sais:

Code: Select all

Got packet bigger than 'max_allowed_packet' when dumping table `wp_options` at row 368

We have increased the max_allowed_packet to 2147483648 but keep getting this error, is there another configuration in jetbackup that we have to be aware? the table is 48mb so it's not a big table

[JetappsCris]

Hi ludolugo,

Thank you for reaching out to us. This error (Got packet bigger than 'max_allowed_packet' bytes when dumping table) usually occurs when taking the backup of the large database. Can I ask where you changed your max allowed packets? Can you check if it was via our UI: Jetbackup >> settings >> Performance >> MySQL Dump max allowed packet

If this is where you made the change, please feel free to open a ticket with our 24/7 support team so our team can further investigate the issue.
We hope to hear from you soon.

[ludolugo]

great!, i dind't see that option in jetbackup 5, now it seems to be solved using 1gb.
I see another error in mysql:

Code: Select all

[ERROR] Failed fetching MySQL/PGSQL default user. Error: yaml file not found

[JetappsCris]

Hi ludolugo,

We are glad to hear your previous issue was resolved.

As for your current error: If you are facing this when trying to make backups, we have had similar tickets with that error.
In most of them, we have found that grants_<username>.yaml file for the problematic account is missing at /var/cpanel/databases/

Can you check in your logs for the failing account and investigate if that specific account is missing the file mentioned above?
If this is not the cause of the issue, please feel free to open a ticket with our 24/7 support team at [email protected]

[ludolugo]

great, that did it
thanks

[castris]

Hello.

It would be interesting if the solution information was shared (that's what forums are for), as I have the same error.

Code: Select all

[30/Aug/2024 01:10:45 +0000] [PID 2102] Configurations Backup
[30/Aug/2024 01:10:50 +0000] [PID 2102] [ERROR] Failed fetching MySQL/PGSQL default user. Error: yaml file not found
[30/Aug/2024 01:10:50 +0000] [PID 2102] Backup Failed

[JetAppsTrenton]

Hello Castris,

The error "yaml file not found" indicates an issue with the grants_<username>.yaml file. Kindly check in the /var/cpanel/databases/ directory to see if the yaml file exists.

If the file is missing, you may need to seek assistance from your qualified system administrator to resolve the issue. Once the issue has been resolved, kindly reinitiate the backup job and update us if the error persists.

If you have further questions or concerns, feel free to ask!

Best Regards,

Trenton V
JetApps, LLC.
JetApps.com | JetBackup.com