SOLVED An error is present in track delivery section

[gildas]

Hello,

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

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!

 

[cPanelMichael]

Hello,

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

mv /var/cpanel/eximstats_db.sqlite3 /var/cpanel/eximstats_db.sqlite3.old
/scripts/restartsrv_tailwatchd
/scripts/slurp_exim_mainlog --force

Thank you.

 

[gildas]

Hello,
Thank you for your return, this action solved my problem

 

[cPanelMichael]

Hello,

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