Welcome to Dentoo Errors & Solutions archive, where you can post error messages and receive solutions from other members of the community. Completely free to sign up and use!

Categories

0 votes

When trying to see mail queue or mail stats in WHM I get the error message

 

Table ‘./eximstats/sends’ is marked as crashed and should be repaired

 

 

in Linux by (940 points)

1 Answer

0 votes

If you see the error on mysql log ” /usr/sbin/mysqld: Table ‘./eximstats/sends’ is marked as crashed and last (automatic?) repair failed”

To fix issue “Table ‘./eximstats/sends’ is marked as crashed and should be repaired ” please perform the issue

#myisamchk -r /var/lib/mysql/eximstats/TABLENAME.MYI

OR
Disable eximstats from whm >> Service Manager

root@server [~]#mysql -u username -p
mysql> use eximstats ;
Database changed
mysql> show tables ;

Then truncate all the tables,
mysql> truncate table smtp;
Query OK, 0 rows affected (7.43 sec)

mysql> truncate table sends;
Query OK, 0 rows affected (4.60 sec)

mysql> truncate table defers;
Query OK, 0 rows affected (0.02 sec)

mysql> truncate table failures;
Query OK, 0 rows affected (0.11 sec)

root@server [~]# mysqlcheck -c eximstats
eximstats.defers OK
eximstats.failures OK
eximstats.sends OK
eximstats.smtp OK

restart mysql and exim

#service mysql restart
#server exim restart
by (940 points)

Dedicated Servers
...