Table './zabbix/history_uint' is marked as crashed and should be repaired

[yglin]

Hi~ all

We have encountered this problem that mysqld keeps giving below error message in mysqld log, as the same in title

Table './zabbix/history_uint' is marked as crashed and should be repaired

This is probably caused by abnormally shutting down mysqld.
It seems mysqld tried to auto-fix it but failed, because I can see this message in log,too

Incorrect key file for table './zabbix/history_uint.MYI'; try to repair it

At first I tried to repair this table history_uint by myisamchk

myisamchk -s -r /var/mysql/zabbix/history_uint.MYI

This command finished with no error output.
But unfortunatly it didn't work, mysqld still complains about crashed history_uint

Is there anything else I can do to safely repair the table history_uint ?
And better without pausing mysql server running.
Thanks everyone~!!

yglin

[kustodian]

You better ask this in the MySQL forums, you will get better help there.

[yglin]

Thank you,

May I ask one more question:

Is it safe to delete table history_uint and re-create it ?

I'm worry if some relationships between history_uint and other tables could be influenced.

Thanks
yglin