warning "MySQL server has gone away"

  • Hello,

    During the run of a BackWPup job i received about 10 warnings concerning the MySQL connection.

    [24-Apr-2016 13:02:59] WARNUNG: mysqli_query(): MySQL server has gone away
    [24-Apr-2016 13:02:59] WARNUNG: mysqli_query(): Error reading result set’s header
    …

    Finally the backup was created, but the job was finished with warnings.

    I started the job a second time and the warnings appeared again.

    What do those warnings mean resp. do they have an impact on the completeness of the backup (or are the “just warnings” and the job mechanism does resume without loss of data in the backup).

    Can I rely on the result resp. how can i proof the completeness of the backup?

    Best regards and thank you in advance.
    Markus

    https://www.ads-software.com/plugins/backwpup/

Viewing 4 replies - 1 through 4 (of 4 total)

  • Hi there,

    I get the same error and it would be awesome to hear if I’ve to do something about it and what’s the reason for this error.

    Thanks,
    Fabian

    https://dev.mysql.com/doc/refman/5.7/en/gone-away.html

    You can try to make the backup on a other time. It can be that the Mysql Server has to many Traffic at that time.

    Else ask your hoster for help.

    Same error for me – see below

    [19-Jun-2016 02:11:03] WARNING: mysqli_query(): MySQL server has gone away
    [19-Jun-2016 02:11:03] WARNING: mysqli_query(): Error reading result set’s header
    [19-Jun-2016 02:11:04] ERROR: System: (2) No such file or directory
    [19-Jun-2016 02:30:56] WARNING: Job restarts due to inactivity for more than 5 minutes.
    [19-Jun-2016 02:31:21] 2. Trying to create backup archive …
    [19-Jun-2016 02:40:03] WARNING: mysqli_query(): MySQL server has gone away
    [19-Jun-2016 02:40:03] WARNING: mysqli_query(): Error reading result set’s header
    [19-Jun-2016 02:40:05] ERROR: System: (2) No such file or directory
    [19-Jun-2016 02:45:43] WARNING: Job restarts due to inactivity for more than 5 minutes.
    [19-Jun-2016 02:45:57] 3. Trying to create backup archive …
    [19-Jun-2016 02:54:32] WARNING: mysqli_query(): MySQL server has gone away
    [19-Jun-2016 02:54:32] WARNING: mysqli_query(): Error reading result set’s header
    [19-Jun-2016 02:54:32] ERROR: System: (2) No such file or directory
    [19-Jun-2016 03:00:39] WARNING: Job restarts due to inactivity for more than 5 minutes.
    [19-Jun-2016 03:00:40] ERROR: Step aborted: too many attempts!

    @mcutting: This is not your topic. If you require assistance then, as per the Forum Welcome, please post your own topic.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘warning "MySQL server has gone away"’ is closed to new replies.