Where do I set innodb_force_recovery in RDS Mariadb

0

Our RDS Mariadb instance hit a crash recently. The instance is now stuck at 'Rebooting' state. While the instance is in 'rebooting' state, the only operation available is 'delete'. But I don't want to delete the instance.

I've posted the crash log to https://jira.mariadb.org/browse/MDEV-28975 and they have suggested to set innodb_force_recovery = 3. But I can't find this parameter in RDS parameter groups and it's not listed as an unsupported parameters either.

My other question is how do I force stop my RDS instance. I've contacted AWS Support but their response is that they don't have permission to stop customers' instances.

I've just same crash again after restoring from backup. I just can't accept the fact that you can only restore from backup when you hit a crash.

Anyone else had similar experience?

Thanks

asked 2 years ago76 views
No Answers

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