Need to reboot Azure Database for MySQL flexible server with innodb_force_recovery = 3

Question

MySQL server locked up with a large rollback which would have taken >300hours. I tried to restart the server, but I suspect the rollback is happening in the background. I need to force restart with innodb_force_recovery = 3

Answer 1

Hello jmahmood

Thank you for your response.

Following our discussion, your server became stuck in the starting state after initiating the start operation, preventing you from performing any actions on it.

Upon further investigation, we engaged the internal team, who successfully mitigated the issue, bringing the server back online. You should now be able to see the server available in the portal.

I hope this helps! Please let us know if you have any further questions.

If this resolves your query, kindly click Accept Answer and select Yes for "Was this answer helpful?" If you have any additional queries, feel free to reach out.