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.

exim stats failing, can't run mail reports

Discussion in 'E-mail Discussions' started by Bashed, Feb 5, 2015.

  1. Bashed

    Bashed Well-Known Member

    Joined:
    Dec 18, 2013
    Messages:
    78
    Likes Received:
    1
    Trophy Points:
    8
    cPanel Access Level:
    Root Administrator
    Code:
    root@server7 [/scripts]# mysqlcheck --repair eximstats
    eximstats.defers                                   OK
    eximstats.failures
    error    : Can't create new tempfile: './eximstats/failures.TMD'
    status   : Operation failed
    Running mail report, getting this error

    Already ran forced cPanel upgrade, restarted EXIM, MySQL. Still no fix.
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,666
    Likes Received:
    646
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    Is there any data in the failures table that you wish to preserve? If not, you can drop the table via phpMyAdmin or the MySQL command line environment and regenerate it via:

    Code:
    /usr/local/cpanel/bin/updateeximstats
    If you want to import the data back into the table, you can use a command such as:

    Code:
    /scripts/import_exim_data /var/log/exim_mainlog*
    Note that this command take a while to complete, depending on the amount of data logged to the Exim log.

    Thank you.
     
  3. Motamedi

    Motamedi Well-Known Member

    Joined:
    Mar 14, 2015
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Iran , Tehran
    cPanel Access Level:
    Root Administrator
    hello ,
    My problem is not resolved with the command !!!


    root@server [/]# mysqlcheck -r eximstats
    eximstats.defers OK
    eximstats.failures OK
    eximstats.sends
    error : Can't create new tempfile: './eximstats/sends.TMD'
    status : Operation failed
    eximstats.smtp OK
    root@server [/]#

    please help me for solved this problem

    thanks
     
  4. Jcats

    Jcats Well-Known Member

    Joined:
    May 25, 2011
    Messages:
    275
    Likes Received:
    31
    Trophy Points:
    28
    Location:
    New Jersey
    cPanel Access Level:
    DataCenter Provider
    You will loose all data in this table by doing this, but it should resolve your issue.

    Code:
    # mysql -e "drop table eximstats.sends"
    # mysql eximstats < /usr/local/cpanel/etc/eximstats_db.sql
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,666
    Likes Received:
    646
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    You may also want to verify if you have available disk space and inodes on your system:

    Code:
    df -h
    df -i
    Thank you.
     
  6. Motamedi

    Motamedi Well-Known Member

    Joined:
    Mar 14, 2015
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Iran , Tehran
    cPanel Access Level:
    Root Administrator

    My problem is not resolved with the command


    root@server [/]# df -h
    Filesystem Size Used Avail Use% Mounted on
    /dev/sda3 537G 361G 149G 71% /
    tmpfs 12G 0 12G 0% /dev/shm
    /dev/sda2 504M 104M 375M 22% /boot
    /usr/tmpDSK 4.0G 170M 3.6G 5% /tmp

    root@server [/]# df -i
    Filesystem Inodes IUsed IFree IUse% Mounted on
    /dev/sda3 35749888 12159360 23590528 35% /
    tmpfs 3068109 1 3068108 1% /dev/shm
    /dev/sda2 32768 52 32716 1% /boot
    /usr/tmpDSK 262144 2305 259839 1% /tmp
     
  7. Jcats

    Jcats Well-Known Member

    Joined:
    May 25, 2011
    Messages:
    275
    Likes Received:
    31
    Trophy Points:
    28
    Location:
    New Jersey
    cPanel Access Level:
    DataCenter Provider
    Is it the same error?

    Does that file already exist.
    Code:
    # stat /var/lib/mysql/eximstats/sends.TMD
     
  8. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,666
    Likes Received:
    646
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Could you elaborate if there's a new error message, or if the same error continues? Were there any errors when running those commands?

    Thank you.
     
  9. Motamedi

    Motamedi Well-Known Member

    Joined:
    Mar 14, 2015
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Iran , Tehran
    cPanel Access Level:
    Root Administrator
    just this error after repair is my problem

    eximstats.defers OK
    eximstats.failures OK
    eximstats.sends
    error : Can't create new tempfile: './eximstats/sends.TMD'
    status : Operation failed
    eximstats.smtp OK
     
  10. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,666
    Likes Received:
    646
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Is there any data in the failures table that you wish to preserve? If not, you can drop the entire eximstats database via phpMyAdmin or the MySQL command line environment and regenerate it via:

    Code:
    /usr/local/cpanel/bin/updateeximstats
    If you want to import the data back into the table, you can use a command such as:

    Code:
    /scripts/import_exim_data /var/log/exim_mainlog*
    Note that this command take a while to complete, depending on the amount of data logged to the Exim log.

    Thank you.
     
  11. oviliz

    oviliz Member

    Joined:
    Feb 23, 2013
    Messages:
    12
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Root Administrator
    Without loosing the mail queue, the right solution is (at least in my case):
    # myisamchk -r -f sends.MYI

    And then:
    # mysqlcheck --repair eximstats
     
  12. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,666
    Likes Received:
    646
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Keep in mind that no actual email data is stored in the "eximstats" database. Only information about email activity is stored in the database.

    Thank you.
     
  13. Motamedi

    Motamedi Well-Known Member

    Joined:
    Mar 14, 2015
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Iran , Tehran
    cPanel Access Level:
    Root Administrator
    I've run all the commands
    But the problem is not resolved
    Again was error

    Error from delivery reporter: DBD::mysql::db selectall_arrayref failed: Table './eximstats/sends' is marked as crashed and last (automatic?) repair failed

    How can this problem be solved forever?

    thanks
     
  14. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,666
    Likes Received:
    646
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Could you verify which commands you ran? Did you try dropping the "eximstats" database completely and regenerating it, as mentioned earlier in this thread?

    Thank you.
     
  15. Motamedi

    Motamedi Well-Known Member

    Joined:
    Mar 14, 2015
    Messages:
    53
    Likes Received:
    0
    Trophy Points:
    6
    Location:
    Iran , Tehran
    cPanel Access Level:
    Root Administrator
    How do I remove and make ?

    Please complete guide

    thanks ...
     
  16. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,666
    Likes Received:
    646
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    You can find the instructions in my initial response to this thread. Let me know if you need help with any of those instructions.

    Thank you.
     
Loading...

Share This Page