The system cannot open the database eximstats_db.sqlite3

Example error

—————

Cpanel::Exception::Database::DatabaseCreationInProgress/(XID 2dkj7a) The system cannot open the database “/var/cpanel/eximstats_db.sqlite3” because another process has created it but has not yet completed its initialization.
at /usr/local/cpanel/Cpanel/Exception/CORE.pm line 336.
Cpanel::Exception::create(“Database::DatabaseCreationInProgress”, ARRAY(0xf3ce90)) called at /usr/local/cpanel/Cpanel/SQLite/AutoRebuildSchemaBase.pm line 222
Cpanel::SQLite::AutoRebuildSchemaBase::__ANON__(Cpanel::Exception::Database::Error=HASH(0x1de9e58)) called at /usr/local/cpanel/3rdparty/perl/524/lib64/perl5/cpanel_lib/Try/Tiny.pm line 120
Try::Tiny::try(CODE(0x1debac0), Try::Tiny::Catch=REF(0x1de7a50)) called at /usr/local/cpanel/Cpanel/SQLite/AutoRebuildSchemaBase.pm line 223
Cpanel::SQLite::AutoRebuildSchemaBase::_get_schema_version(Cpanel::EximStats::DB::Sqlite=HASH(0x1debb20)) called at /usr/local/cpanel/Cpanel/EximStats/DB/Sqlite.pm line 142
Cpanel::EximStats::DB::Sqlite::_schema_check(Cpanel::EximStats::DB::Sqlite=HASH(0x1debb20)) called at /usr/local/cpanel/Cpanel/SQLite/AutoRebuildBase.pm line 179
Cpanel::SQLite::AutoRebuildBase::new_without_rebuild(“Cpanel::EximStats::DB::Sqlite”) called at /usr/local/cpanel/Cpanel/EximStats/DB/Sqlite.pm line 86
Cpanel::EximStats::DB::Sqlite::__ANON__() called at /usr/local/cpanel/3rdparty/perl/524/lib64/perl5/cpanel_lib/Try/Tiny.pm line 99
eval {…} called at /usr/local/cpanel/3rdparty/perl/524/lib64/perl5/cpanel_lib/Try/Tiny.pm line 90
Try::Tiny::try(CODE(0x1dec210), Try::Tiny::Catch=REF(0x1dec240)) called at /usr/local/cpanel/Cpanel/EximStats/DB/Sqlite.pm line 114
Cpanel::EximStats::DB::Sqlite::get_status() called at whostmgr/bin/whostmgr11.pl line 621
main::__ANON__() called at /usr/local/cpanel/3rdparty/perl/524/lib64/perl5/cpanel_lib/Try/Tiny.pm line 99
eval {…} called at /usr/local/cpanel/3rdparty/perl/524/lib64/perl5/cpanel_lib/Try/Tiny.pm line 90
Try::Tiny::try(CODE(0x1ddc5f8), Try::Tiny::Catch=REF(0xf5aba8)) called at whostmgr/bin/whostmgr11.pl line 630
main::_db_status_vars() called at whostmgr/bin/whostmgr11.pl line 568
main::_emailstats_summary(ARRAY(0x10081e8)) called at whostmgr/bin/whostmgr11.pl line 597
main::emailstats_faildefer_summary() called at whostmgr/bin/whostmgr11.pl line 155

===================

 

To resolve this issue follow below steps

 

mv /var/cpanel/eximstats_db.sqlite3 /var/cpanel/eximstats_db.sqlite3-12-26
/scripts/restartsrv_tailwatchd
/scripts/import_exim_data /var/log/exim_mainlog

 

If the error still persists make sure that your server’s IOWait is not high and perform the import step once again after the IOWait is reduced.