We are trying to make backups of our website. We
have used Backup Buddy (and other backup plugins) many times in the
past without issues. However, whenever we try now we receive the
following error messages:
"16:0:54 0.39sec 34.36MB Scheduling Cron for guz17z3g4r.
16:0:54 0.39sec 34.36MB Loading DB kicker in case database has gone away.
16:0:54 0.39sec 34.36MB Database Server has gone away, attempting to reconnect.
16:0:54 0.40sec 34.36MB Database Server reconnection failed.
16:0:54 0.40sec 34.36MB ERROR: Database
Server has gone away, unable to schedule next backup step. The backup
cannot continue. This is most often caused by mysql running out of
memory or timing out far too early. Please contact your host."
Our web host can’t assist with this issue.
Does anyone kindly know how I may resolve the issue they are
referring to (“Database Server has gone away, unable to schedule next
backup step. The backup cannot continue. This is most often caused by
mysql running out of memory or timing out far too early.”)
Hit the logs for the first time this error was seen and compare the commit log log to see what was changed around that time. The error indicates a query is taking to long or database is being overloaded which could also be due to poor scalability within the application code. Wordpress doesn’t scale well and it is likely that a process which worked fine no longer does to an over abundance of data.
THis is apparently WordPress and WordPress automatically updated the SQL calls from mysql_ to mysqli_ for PHP 5.5 and after and so cannot have the db calls affected by the PHP version.
No to mention I highly doubt any reputable provider would just update their servers from 5.x to 7. That doesn’t make any sense. Sounds like you have either hit a scale issue or broken something with a recent update/install of a plugin. That is the more realistic cause. Especially if the client/end-user is able to update the site and plugins via the GUI which is notorious for not working 100%. Which is why you ALWAYS test locally before pushing to production and should disallow people to change code via GUI.