Aurora MySQL database got stuck in Upgrading status

0

Hello,

I tried to upgrade MySQL to the latest minor version available but it got stuck in Upgrading status. It's been more than 3 hours and still not finished. I already restored a snapshot to a new cluster/instance for my team to proceed but I still need to get the original cluster/instance working. What else can I do?

Event logs:
November 17th 2020, 2:03:48 pm UTC The crash loop due to OOM
November 17th 2020, 1:46:18 pm UTC Error restarting mysql: Engine bootstrap failed with no mysqld process running...
November 17th 2020, 1:45:56 pm UTC Error restarting mysql: Engine bootstrap failed with no mysqld process running...
November 17th 2020, 1:23:41 pm UTC DB instance restarted
November 17th 2020, 1:16:25 pm UTC DB instance restarted
November 17th 2020, 1:16:12 pm UTC Error restarting mysql: Engine bootstrap failed with no mysqld process running...
November 17th 2020, 1:00:26 pm UTC DB instance restarted
November 17th 2020, 12:51:17 pm UTC The database process was killed by the OS due to excessive memory consumption. It is recommended to tune your database workload and/or parameter usage to reduce memory consumption.
November 17th 2020, 12:49:12 pm UTC Error restarting mysql: Engine bootstrap failed with no mysqld process running...
November 17th 2020, 12:48:10 pm UTC Error restarting mysql: Engine bootstrap failed with no mysqld process running...
November 17th 2020, 12:47:01 pm UTC Error restarting mysql: Could not verify and start mysqld.
November 17th 2020, 12:38:40 pm UTC Error restarting mysql: Engine bootstrap failed with no mysqld process running...

Thanks
Lino

Lino
已提問 3 年前檢視次數 1379 次
1 個回答
0

Apparently the configured max_connections parameter is too high for the instance type we're using. After adjusting it to its ideal value, the problem has been solved.

Lino
已回答 3 年前

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

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

回答問題指南