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

preguntada hace 2 años76 visualizaciones
No hay respuestas

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas