Fix

On checking I could see that innodb_force_recovery was enabled in the mysql configuration file. Disabled it and then restarted the mysql service.

Note: Mysql innodb force recovery may be enabled due to any innodb crashes in the server. You need to have a detailed check before disabling this.

• MySQL