SOLVED Database Error: Table './eximstats/sends

[speedcom]

Hello,

We can't see email report from email section. It displays error.
Error from delivery reporter: (XID u58m7a) Database Error: Table './eximstats/sends' is marked as crashed and last (automatic?) repair failed

We try to repaid db by command mysqlcheck --repair eximstats
But it failed and show error
Operation failed
Can't create new tempfile: './eximstats/sends.TMD'

Please advise us on the issue.

--
Regards,
Shahadat

 

[ChrisI]

Hello!

It looks like there is an issue with the sends table in the eximstats database. Can you also try repairing that with this command instead of mysqlcheck?

myisamchk -r -f /var/lib/mysql/eximstats/sends.MYI

Thanks!

 

[MinhAngela]

If you login to WHM and go to check your email sent summary, or any other function like looking at your email queue, you may have run across the following error:

Error from delivery reporter: DBD::mysql::db selectall_arrayref failed: Table ‘./eximstats/sends’ is marked as crashed and should be repaired

This is an easy fix. If you are unfamiliar with root, please do not try the following tutorial. First, you will need to login to shell as the root user. Run the following command

mysqlcheck —repair eximstats

When running that command, you will receive something along the lines of:

status : Operation failed

If that happens, then it means it cannot be repaired and will need to be recreated. Run:

mysql
use eximstats;
drop table failures;

Then (important) run:

/usr/local/cpanel/bin/updateeximstats

That should do it. What that last line of code will do is fix the database scheme since you just dropped the failures table. You can also ‘clear’ the other databases to get a clean start. Just know that this will clear all of your current eximstats so if you have important stats you don’t want deleted, don’t clear the rest.

To clear the other stats, run:

mysql
use eximstats;
TRUNCATE TABLE sends;
TRUNCATE TABLE defers;
TRUNCATE TABLE smtp;
exit;

That’s it! Now run your WHM reports and you shouldn’t receive any other errors.

MinhAngela

 

[speedcom]

Thanks for suggestion. We repaired eximstats.