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.