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!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

SOLVED An error is present in track delivery section

Discussion in 'General Discussion' started by gildas, May 3, 2017.

Tags:
  1. gildas

    gildas Member

    Joined:
    Mar 30, 2017
    Messages:
    11
    Likes Received:
    2
    Trophy Points:
    3
    Location:
    Paris
    cPanel Access Level:
    Root Administrator
    Hello,

    An error is present in [track delivery], which seems to be tied to the database eximstats_db.sqlite3:

    Code:
    DeliveryReporter API internal failure:
    Cpanel::Exception::Database::Error/(XID unf95e) The system received an
    error from the “SQLite” database “/var/cpanel/eximstats_db.sqlite3”:
    SQLITE_CORRUPT (database disk image is malformed) at
    /usr/local/cpanel/Cpanel/Exception/CORE.pm line 330, <STDIN> line 2.
    Cpanel::Exception::create("Database::Error", ARRAY(0x288ed10)) called
    at /usr/local/cpanel/Cpanel/Exception.pm line 46
    Cpanel::Exception::__ANON__(__CPANEL_HIDDEN__, ARRAY(0x288ed10))
    called at /usr/local/cpanel/Cpanel/DBI.pm line 189
    Cpanel::DBI::_create_exception(Cpanel::DBI::SQLite::db=HASH(0x2898188),
    "DBD::SQLite::db selectall_arrayref failed: database disk imag"...,
    undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 177
    Cpanel::DBI::_error_handler("DBD::SQLite::db selectall_arrayref
    failed: database disk imag"...,
    Cpanel::DBI::SQLite::db=HASH(0x2898188), undef) called at
    /usr/local/cpanel/Cpanel/DeliveryReporter.pm line 418
    Cpanel::DeliveryReporter::query(Cpanel::DeliveryReporter=HASH(0x288e890),
    "maxsendunixtime", 1493890020, "startIndex", 0, "deliverytype", "all",
    "api2_sort_reverse_0", ...) called at bin/admin/Cpanel/eximstats.pl
    line 100 eval {...} called at bin/admin/Cpanel/eximstats.pl line 100
    
    The file has been checked with :
    pragma integrity_check;
    
    
    The file seems OK, disk space is OK. Where does this come from and how can I fix it?

    Thanks!
     
    #1 gildas, May 3, 2017
    Last edited by a moderator: May 5, 2017
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    Please try running the following commands to move the corrupted SQLite database out of the way and import the Exim data:

    Code:
    mv /var/cpanel/eximstats_db.sqlite3 /var/cpanel/eximstats_db.sqlite3.old
    /scripts/restartsrv_tailwatchd
    /scripts/slurp_exim_mainlog --force
    Thank you.
     
  3. gildas

    gildas Member

    Joined:
    Mar 30, 2017
    Messages:
    11
    Likes Received:
    2
    Trophy Points:
    3
    Location:
    Paris
    cPanel Access Level:
    Root Administrator
    Hello,
    Thank you for your return, this action solved my problem
     
    cPanelMichael likes this.
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    38,658
    Likes Received:
    1,425
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Hello,

    I'm happy to see that helped. Thank you for updating us with the outcome.
     
Loading...

Share This Page