Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

SOLVED Table './eximstats/sends' is marked as crashed

Discussion in 'E-mail Discussion' started by urgido, Jan 16, 2017.

Tags:
  1. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    122
    Likes Received:
    7
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    I have a problem with eximstats DB.

    I RAN: /usr/local/cpanel/bin/updateeximstats
    RESULT:
    At this moment the problem still present so, I go to WHM interface and here is what I got:

    As you see the problem is not solved, any clue?
    Bless
     
  2. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    122
    Likes Received:
    7
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  4. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    122
    Likes Received:
    7
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Could you open a support ticket using the link in my signature so we can take a closer look? You can post the ticket number here so we can update this thread with the outcome.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    122
    Likes Received:
    7
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    Support Request ID is: 8141381
     
  7. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    To update, the issue was addressed by moving the SENDS.MYI file out of the way and then running the following command with MySQL stopped:

    Code:
    myisamchk -r /var/lib/mysql/eximstats/sends.MYI
    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    urgido likes this.
  8. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    122
    Likes Received:
    7
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    New error:

    myisamchk -r /var/lib/mysql/eximstats/sends.MYI
    - recovering (with sort) MyISAM-table '/var/lib/mysql/eximstats/sends.MYI'
    Data records: 3619
    myisamchk: error: Can't create new tempfile: '/var/lib/mysql/eximstats/sends.TMD'
    MyISAM-table '/var/lib/mysql/eximstats/sends.MYI' is not fixed because of errors
    Try fixing it by using the --safe-recover (-o), the --force (-f) option or by not using the --quick (-q) flag
     
  9. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,367
    Likes Received:
    1,857
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Please verify if you have tried dropping and rebuilding the entire eximstats database using the instructions on the following thread:

    exim stats failing, can't run mail reports

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    urgido likes this.
  10. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    122
    Likes Received:
    7
    Trophy Points:
    168
    cPanel Access Level:
    Root Administrator
    SOLVED! thanks
     
    cPanelMichael likes this.
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice