Aurora v2.10.2 - MySQL Server Has Gone Away

0

Since upgrading our Aurora cluster to v2.10.2 a couple of weeks ago we have experienced intermittent "MySQL server has gone away" errors on the Writer instance. So far the readers are not affected. These occur at seemingly random times to queries on various tables. The errors did not occur prior to upgrade.

All RDS logs are empty, except for the external/mysql-external.log file. This file appears to show the server being restarted, but it does not include any timestamps or other information that could be used to tie it back to the "MySQL server has gone away errors" Enter image description here

This file has now grown to over 80mb in size.

We are already on the latest Aurora engine version for v2. Any assistance would be appreciated.

3 Respuestas
0

I'd recommend opening up a support case so the RDS team can look into this issue. Support has access to tooling to review the health of your RDS instances.

There are several causes for the server gone away error described here.

You can view RDS Events, including restarts, by following this guide.

profile pictureAWS
Hopper
respondido hace 2 años
0

Were you able to get this solved ? We are experiencing an identical issue.

Mark
respondido hace un año
0

I am also facing the same issue. I have tried all the possible changes like. wait_timeout, interactive_timeout, max_allowed_packet but no luck. Is there any solution you found

profile picture
respondido hace un año

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas