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 Table './eximstats/sends' is marked as crashed

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

Tags:
  1. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    85
    Likes Received:
    3
    Trophy Points:
    158
    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:
    85
    Likes Received:
    3
    Trophy Points:
    158
    cPanel Access Level:
    Root Administrator
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,064
    Likes Received:
    1,286
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
  4. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    85
    Likes Received:
    3
    Trophy Points:
    158
    cPanel Access Level:
    Root Administrator
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,064
    Likes Received:
    1,286
    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.
     
  6. urgido

    urgido Well-Known Member

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

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    37,064
    Likes Received:
    1,286
    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.
     
    urgido likes this.
  8. urgido

    urgido Well-Known Member

    Joined:
    Jul 19, 2005
    Messages:
    85
    Likes Received:
    3
    Trophy Points:
    158
    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:
    37,064
    Likes Received:
    1,286
    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.
     
    urgido likes this.
  10. urgido

    urgido Well-Known Member

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

Share This Page