The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SOLVED Database Error: Table './eximstats/sends

Discussion in 'E-mail Discussions' started by speedcom, Dec 20, 2016.

Tags:
  1. speedcom

    speedcom Registered

    Joined:
    Jan 17, 2013
    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    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
     
  2. cPanelChrisI

    cPanelChrisI Technical Analyst II
    Staff Member

    Joined:
    Mar 24, 2014
    Messages:
    67
    Likes Received:
    11
    Trophy Points:
    83
    cPanel Access Level:
    Root Administrator
    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!
     
  3. MinhAngela

    MinhAngela Registered

    Joined:
    Dec 23, 2016
    Messages:
    3
    Likes Received:
    3
    Trophy Points:
    3
    Location:
    Ho Chi Minh
    cPanel Access Level:
    Website Owner
    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

    mysqlcheckrepair 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
     
    urgido and cPanelMichael like this.
  4. speedcom

    speedcom Registered

    Joined:
    Jan 17, 2013
    Messages:
    2
    Likes Received:
    1
    Trophy Points:
    3
    cPanel Access Level:
    Root Administrator
    Thanks for suggestion. We repaired eximstats.
     
    cPanelMichael likes this.
Loading...

Share This Page