Bug ID 438915: Wamd log will occasionally contain "MySQL server has gone away" message.

Last Modified: Jul 12, 2023

Affected Product(s):
BIG-IP AAM(all modules)

Known Affected Versions:
11.3.0

Opened: Nov 25, 2013

Severity: 5-Cosmetic

Symptoms

A wamd connection to MySQL timed out, causing a message containing "MySQL server has gone away" to be logged.

Impact

When wamd notices the closed connection, it will open a new one to MySQL. It is possible that this failure will cause a distortion in the presented statistical data until such time as the next attempt is made to perform the operation.

Conditions

If wamd's MySQL connection sits idle longer than the configured timeout value, MySQL will close that connection.

Workaround

As an administrator, log on to MySQL and change the server parameter that controls the number-of-seconds timeout value using the following MySQL command: set global wait_timeout=28800. (Note: 28800 seconds is 8 hours, and is the MySQL default. Your value may differ.) Alternatively, the MySQL global wait_timeout value can be set on the command line in the init.d startup file. Although you can increase MySQL's timeout value, for the most part, it isn't necessary.

Fix Information

None

Behavior Change

Guides & references

K10134038: F5 Bug Tracker Filter Names and Tips