Warnings "MySQL server has gone away"

Hi, probably you need to increase max_allowed_packet variable.

https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_max_allowed_packet

I think i fix that with the next release.

@santec : I don’t think I can do it, it’s on a low cost shared server.

@daniel: thank you ?? I’m worried if that error can create incomplete backups, or not?

OK solved in version 3.3.4 ??

hi, i still have the same issue on several pages with version 3.3.4 and 3.3.7
Is it possible that there is still something wrong?

[14-May-2017 07:20:56] Database backup done!
[14-May-2017 07:20:56] 1. Trying to make a list of folders to back up …
[14-May-2017 07:20:57] Added "wp-config.php" to backup file list
[14-May-2017 07:20:57] 231 folders to backup.
[14-May-2017 07:20:57] 1. Trying to generate a file with installed plugin names …
[14-May-2017 07:20:57] Added plugin list file "Bye-Maxene.pluginlist.2017-05-14.txt" with 1.96 KB to backup file list.
[14-May-2017 07:20:57] 1. Trying to generate a manifest file …
[14-May-2017 07:20:57] Added manifest.json file with 5.33 KB to backup file list.
[14-May-2017 07:20:57] 1. Trying to create backup archive …
[14-May-2017 07:20:57] Compressing files as ZipArchive. Please be patient, this may take a moment.
[14-May-2017 07:27:19] WARNING: mysqli_ping(): MySQL server has gone away
[14-May-2017 07:29:18] WARNING: mysqli_query(): MySQL server has gone away
[14-May-2017 07:29:18] WARNING: mysqli_query(): Error reading result set's header
[14-May-2017 07:31:49] WARNING: mysqli_ping(): MySQL server has gone away

thanks for the cool plugin btw. ??

Hi @drzivil,

I’m sorry you’re experiencing this issue.

Could you ask your host whether an especially low wait_timeout value is being used? Or else ask them why a long-running script might be having trouble accessing the database. That’d be the first thing I suggest.

See this page for more information on the error you’re getting: https://dev.mysql.com/doc/refman/5.7/en/gone-away.html

If that doesn’t work, please email us a full debug backup log to support [at] backwpup.com so we can take a better look.

Why not just set wait_timeout in the SQL connecting created by the plugin?

It’s a session variable: https://dev.mysql.com/doc/refman/5.7/en/server-system-variables.html#sysvar_wait_timeout

Hi @tomsommer, that’s not currently something configurable in BackWPup, but certainly if many people are experiencing this issue, we’d look into including that option in a future version. So far this is the first I’ve heard of the issue so it’s hard to tell how common it is.