My Oracle Support Banner

MySQL Enterprise Backup (MEB): Backup Fails; Lost Connection to MySQL Server During Query; Error 2006: MySQL Server Has Gone Away; This Backup Operation Cannot be Logged (Doc ID 1381365.1)

Last updated on FEBRUARY 10, 2019

Applies to:

MySQL Enterprise Backup - Version 3.5 to 3.8 [Release 3.5 to 3.8]
Information in this document applies to any platform.

Symptoms

When attempting to backing up a large database, the following - or similar - errors occur.

Changes

The issue can be triggered by either of the following changes:

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
 Solution 1: Use MySQL Enterprise Backup 3.7.1, 3.8.1, or later
 Workaround 2: Increase the Value of wait_timeout
 Workaround 3: Adjust wait_timeout in a Backup Script
 Workaround 4: Increase the Value of wait_timeout + Have the Clients Change the Value as Needed
 Workaround 5: Increase the Value of wait_timeout + init_connect
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.