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 Risposte
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
con risposta 2 anni fa
0

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

Mark
con risposta un anno fa
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
con risposta un anno fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande