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년 전

로그인하지 않았습니다. 로그인해야 답변을 게시할 수 있습니다.

좋은 답변은 질문에 명확하게 답하고 건설적인 피드백을 제공하며 질문자의 전문적인 성장을 장려합니다.

질문 답변하기에 대한 가이드라인