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

demandé il y a 2 ans76 vues
Aucune réponse

Vous n'êtes pas connecté. Se connecter pour publier une réponse.

Une bonne réponse répond clairement à la question, contient des commentaires constructifs et encourage le développement professionnel de la personne qui pose la question.

Instructions pour répondre aux questions