RDS Aurora - stop upgrading process

0

Hello. I decided to upgrade my Aurora from 5.6 to the 5.7 version. I click Modify and apply changes. The process of upgrading starts. I use a single region. After 30 minutes I decided to see the result, but I saw the next errors: in the cluster event - I see Upgrade in progress: Performing online pre-upgrade checks. and in the instance, I see the next error: /bin/cat: /etc/rds/huge_page_size.dat: No such file or directory. Database reboot each 2-5 minutes. I decided to delete this instance and cluster but now I see the next statuses for a long time: Cluster: Upgrading and instance: Deleting.

How to fix it and completely remove it?

已提問 2 年前檢視次數 1088 次
2 個答案
1
已接受的答案

I received answer from AWS Support Center:

A previous update of an internal monitoring component on these database clusters caused a configuration change which caused the recent upgrade from proceeding. An AWS engineer helped to unblock the upgrade.

We started working on a fix for this issue with a release date in Q2/2022.

已回答 2 年前
profile picture
專家
已審閱 13 天前
profile picture
專家
已審閱 9 個月前
0

Hi, MySQL 5.6-compatible cluster and want to upgrade it to a MySQL-5.7, you can do so by running an upgrade process on the cluster itself. This kind of upgrade is an in-place upgrade, in contrast to upgrades that you do by creating a new cluster. This technique keeps the same endpoint and other characteristics of the cluster, so once upgrade initiated we can't stop. Reason for in-place upgrade being canceled or slow, sometimes could be due to below factors. -Cluster is processing any data definition language (DDL) statements -Cluster has uncommitted changes for many rows -Cluster is in the process of committing a large binary log transaction

If you are looking to delete then, we may also use a snapshot as part of the upgrade to restore and destroy your old instance once the instance state is available.

Alternative approach, this post shows how you can perform a major upgrade for Aurora MySQL with minimal downtime using a blue-green deployment. This is useful for database administrators or DevOps team members responsible for the Aurora MySQL upgrades.

https://aws.amazon.com/blogs/database/performing-major-version-upgrades-for-amazon-aurora-mysql-with-minimum-downtime/

AWS
awsrams
已回答 2 年前
  • I've restored the new DB from the snapshot. Now I need to destroy the old cluster and instance, but it doesn't delete for a long time.

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南