RDS MySQL not upgrading minor version (even though it shows "upgrading")

1

Hello,
Both our main instance and our read replica do not upgrade when prompted, even though they show "upgrading" in the status. We wanted to go from 8.0.17 to 8.0.27 to take advantage of the new t4g instances, but the database is stuck on 8.0.17 regardless of what version we chose. Is this a bug or am I overlooking something?

Thanks,
Finn

asked 2 years ago869 views
1 Answer
2

Hi Finn,

The most probable cause for an upgrade not moving forward, is that something in your database instance is failing MySQL's pre-upgrade checks. As mandated by the MySQL documentation, RDS executes the MySQL Upgrade Checker Utility and if their script results in any error message, the upgrade can't proceed until you fix the errors listed in the PrePatchCompatibility log file which you can find under Logs & events in the Amazon RDS console.

These checks used to be done only in major version upgrades, but in 8.0+, MySQL defined these should be run for minor version upgrades as well.

We've put together a Knowledge Center Article that should help: How do I resolve a preupgrade check failure in Amazon RDS for MySQL?

Additionally, if the errors in the log are not related to tables or data, the response on this other re:Post question might be helpful.

And, should these tips and links in the log file not be helpful in solving the incompatibilities found, I'd advise opening a support case for help with the specific error in your instance.

AWS
answered 2 years ago
  • Thank you for the answer, Valter_R.

    FinnIckler, Thank you for using re:Post. Let us know if this answers your question. If this solved your issue, please remember to click on the "Accept" button to let the community know that your question is resolved. This helps everyone. Thank you in advance

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions