SOLVED An error is present in track delivery section

gildas

Well-Known Member
Mar 30, 2017
58
5
8
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!
 
Last edited by a moderator:

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,213
363
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.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,910
2,213
363
Hello,

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