Updates fails

[hmaddy]

Updates are failing regularly.

[2022-02-07 00:49:24 +0000] E [/usr/local/cpanel/scripts/expunge_expired_transfer_sessions] Cpanel::Exception::Database::ConnectError/(XID g4fd3g) The system failed to connect to the “SQLite” database “/var/cpanel/transfer_sessions/s81hostmnbacku20220128030535rpTX/db.sqlite” because of an error: SQLITE_CANTOPEN (unable to open database file)
[2022-02-07 00:49:24 +0000] E [/usr/local/cpanel/scripts/expunge_expired_transfer_sessions] at /usr/local/cpanel/Cpanel/DBI.pm line 103.
[2022-02-07 00:49:24 +0000] E [/usr/local/cpanel/scripts/expunge_expired_transfer_sessions] Cpanel::DBI::__ANON__(__CPANEL_HIDDEN__...) called at /usr/local/cpanel/3rdparty/perl/532/lib/perl5/cpanel_lib/Try/Tiny.pm line 121
[2022-02-07 00:49:24 +0000] E [/usr/local/cpanel/scripts/expunge_expired_transfer_sessions] Try::Tiny::try(CODE(0x14d87b0), Try::Tiny::Catch=REF(0x14ca6f8)) called at /usr/local/cpanel/Cpanel/DBI.pm line 115
...
[2022-02-07 00:49:37 +0000] - Finished command `/usr/local/cpanel/bin/cloudlinux_update` in 0.174 seconds
[2022-02-07 00:49:37 +0000] Processing: Updating plugins data cache
[2022-02-07 00:49:37 +0000] - Processing command `/usr/local/cpanel/bin/refresh_plugin_cache`
[2022-02-07 00:49:38 +0000] - Finished command `/usr/local/cpanel/bin/refresh_plugin_cache` in 0.402 seconds
[2022-02-07 00:49:38 +0000] Processing: Ensuring SSL certificate information for CCS is up to date.
[2022-02-07 00:49:38 +0000] - Processing command `/usr/local/cpanel/scripts/ccs-check --run --ssl`
[2022-02-07 00:49:38 +0000] - Finished command `/usr/local/cpanel/scripts/ccs-check --run --ssl` in 0.028 seconds
[2022-02-07 00:49:38 +0000] Processing: Ensure cpanel-plugins yum repo exists
[2022-02-07 00:49:38 +0000] - Finished in 0.588 seconds
[2022-02-07 00:49:38 +0000] Processing: Checking Addon Licenses
[2022-02-07 00:49:38 +0000] - Finished in 0.041 seconds
[2022-02-07 00:49:38 +0000] Processing: Checking End Of Life for current version.
[2022-02-07 00:49:39 +0000] - Finished in 0.194 seconds
[2022-02-07 00:49:39 +0000] Processing:
[2022-02-07 00:49:39 +0000] Maintenance complete.
=> Log closed Mon Feb 7 00:49:39 2022

 

[quietFinn]

Did you try to run:
/scripts/upcp --force

 

[hmaddy]

Executed this command many times. Still same error on updates.

 

[cPRex]

I wouldn't expect the "/usr/local/cpanel/scripts/expunge_expired_transfer_sessions" command to keep the update from failing completely. Are there any other failures mentioned in the log? If not, can you contact our team through a ticket so we can check the server?

 

[diogo_plta]

I'm with the same problem. Any ideia about this solution? Only this command is failing.

[2023-03-27 23:30:51 -0300] - Processing command `/usr/local/cpanel/scripts/expunge_expired_transfer_sessions`
[2023-03-27 23:30:51 -0300] E [/usr/local/cpanel/scripts/expunge_expired_transfer_sessions] Cpanel::Exception::Database::ConnectError/(XID p8ena8) The system failed to connect to the “SQLite” database “/var/cpanel/transfer_sessions/npbk20230321151311iOA/db.sqlite” because of an error: SQLITE_CANTOPEN (unable to open database file)
[2023-03-27 23:30:51 -0300] E [/usr/local/cpanel/scripts/expunge_expired_transfer_sessions] at /usr/local/cpanel/Cpanel/DBI.pm line 103.
[2023-03-27 23:30:51 -0300] E [/usr/local/cpanel/scripts/expunge_expired_transfer_sessions] Cpanel::DBI::__ANON__(__CPANEL_HIDDEN__...) called at /usr/local/cpanel/3rdparty/perl/536/cpanel-lib/Try/Tiny.pm line 121
[2023-03-27 23:30:51 -0300] E [/usr/local/cpanel/scripts/expunge_expired_transfer_sessions] Try::Tiny::try(CODE(0x264aed8), Try::Tiny::Catch=REF(0x264a6f8)) called at /usr/local/cpanel/Cpanel/DBI.pm line 115
[2023-03-27 23:30:51 -0300] E [/usr/local/cpanel/scripts/expunge_expired_transfer_sessions] Cpanel::DBI::connect("Cpanel::DBI::SQLite", "dbi:SQLite:dbname=/var/cpanel/transfer_sessions/naveplanetari"..., undef, undef, HASH(0x264aad0)) called at /usr/local/cpanel/Cpanel/DBI/SQLite.pm line 59
[2023-03-27 23:30:51 -0300] E [/usr/local/cpanel/scripts/expunge_expired_transfer_sessions] Cpanel::DBI::SQLite::_connect("Cpanel::DBI::SQLite", undef, undef, HASH(0x2257e00)) called at /usr/local/cpanel/Cpanel/DBI/ConnectUsesHash.pm line 35
[2023-03-27 23:30:51 -0300] E [/usr/local/cpanel/scripts/expunge_expired_transfer_sessions] Cpanel::DBI::ConnectUsesHash::connect("Cpanel::DBI::SQLite", HASH(0x264aa28)) called at /usr/local/cpanel/Whostmgr/Transfers/Session/DBBackend.pm line 169
[2023-03-27 23:30:51 -0300] E [/usr/local/cpanel/scripts/expunge_expired_transfer_sessions] Whostmgr::Transfers::Session::DBBackend::get_session_connection(Whostmgr::Transfers::Session=HASH(0x25d6fe8), "npbk20230321151311iOA") called at /usr/local/cpanel/Whostmgr/Transfers/Session/DBBackend.pm line 77
[2023-03-27 23:30:51 -0300] E [/usr/local/cpanel/scripts/expunge_expired_transfer_sessions] Whostmgr::Transfers::Session::DBBackend::new("Whostmgr::Transfers::Session", "master_dbh", Cpanel::DBI::SQLite::db=HASH(0x247f9d0), "id", "naveplanetariabacku20230321151311iOA") called at /usr/local/cpanel/Whostmgr/Transfers/Session.pm line 964
[2023-03-27 23:30:51 -0300] E [/usr/local/cpanel/scripts/expunge_expired_transfer_sessions] Whostmgr::Transfers::Session::new("Whostmgr::Transfers::Session", "id", "naveplanetariabacku20230321151311iOA", "master_dbh", Cpanel::DBI::SQLite::db=HASH(0x247f9d0)) called at /usr/local/cpanel/Whostmgr/Transfers/SessionDB.pm line 33
[2023-03-27 23:30:51 -0300] E [/usr/local/cpanel/scripts/expunge_expired_transfer_sessions] Whostmgr::Transfers::SessionDB::get_session(Whostmgr::Transfers::SessionDB=HASH(0x1e294b8), "npbk20230321151311iOA") called at /usr/local/cpanel/Whostmgr/Transfers/SessionDB.pm line 116
[2023-03-27 23:30:51 -0300] E [/usr/local/cpanel/scripts/expunge_expired_transfer_sessions] Whostmgr::Transfers::SessionDB::expunge_expired_sessions(Whostmgr::Transfers::SessionDB=HASH(0x1e294b8)) called at /usr/local/cpanel/scripts/expunge_expired_transfer_sessions line 37
[2023-03-27 23:30:51 -0300] E [/usr/local/cpanel/scripts/expunge_expired_transfer_sessions] scripts::expunge_expired_transfer_sessions::script(scripts::expunge_expired_transfer_sessions=HASH(0x1e0e370)) called at /usr/local/cpanel/scripts/expunge_expired_transfer_sessions line 24
[2023-03-27 23:30:51 -0300] E [/usr/local/cpanel/scripts/expunge_expired_transfer_sessions] scripts::expunge_expired_transfer_sessions::run() called at /usr/local/cpanel/scripts/expunge_expired_transfer_sessions line 16
[2023-03-27 23:30:51 -0300] E [/usr/local/cpanel/scripts/expunge_expired_transfer_sessions] The “/usr/local/cpanel/scripts/expunge_expired_transfer_sessions” command (process 25848) reported error number 255 when it ended.
[2023-03-27 23:30:51 -0300] The Administrator will be notified to review this output when this script completes

 

[quietFinn]

@diogo_plta

https://support.cpanel.net/hc/en-us/articles/4407651638807-cPanel-updates-fail-due-to-corrupt-transfer-sessions-database

 

[cPRex]

Let us know if the details that @quietFinn posted don't fix the issue!

 

[diogo_plta]

Thank you @quietFinn this solution fixed the issue.

when I ran the query

sqlite3 /var/cpanel/transfer_sessions/whmxfer.sqlite "select * from sessions"

did not resulted in "Error: database disk image is malformed" as showed in the post. This query listed two sessions with no error.

but I tryed to rename the database file to be regenerated

mv -v /var/cpanel/transfer_sessions/whmxfer.sqlite{,.bak}

runned /scripts/upcp again and whitout problem : )