I have erpsupport ticketing on my server and it was stopped working so when checked the mysqld logs it is showing me there “not enough free space on device” so i make free space on “/” partition.
and When restarted the mysqld service i’m getting the below error in logs:
[ERROR] /usr/libexec/mysqld: Table ‘./erpsupport/ost_syslog’ is marked as crashed and should be repaired
[ERROR] /usr/libexec/mysqld: Table ‘./erpsupport/ost_ticket_message’ is marked as crashed and should be repaired
So due to the out of disk space or a similar unexpected event, some database tables may get corrupt.
This is often occurs after you experience the out of disk space problems on the disk partition where your database is installed.
In the above error the /erpsupport/ost_syslog and /erpsupport/ost_ticket_message table became corrupt so now it needs to be repaired.
So to repair the above tables execute the below command, this command will check all the database tables and fix corrupted tables :
#mysqlcheck -o -r –all-databases
After successfully completing the repair process, It the corrupted table error will gone to verify the same check the mysqld logs.You’ll not get there any updated error message related to table crashed 🙂