SOLVED Backup restoration page fatal error or timeout

zlygis

Registered
Jun 2, 2014
4
0
1
cPanel Access Level
Root Administrator
Hi,

When I try to open WHM > Backup Restoration page, the page loads for a minute and then I get "A fatal error or timeout occurred while processing this directive. [show] [close]"

On clicking "show" link:

Code:
(XID wp6ksk) The system received an error from the “SQLite” database “/backup/transports.db”: SQLITE_BUSY (database is locked) at /usr/local/cpanel/Cpanel/DBI.pm line 188.
    Cpanel::DBI::_error_handler("DBD::SQLite::db do failed: database is locked", Cpanel::DBI::SQLite::db=HASH(0x40ef4e8), undef) called at /usr/local/cpanel/Cpanel/SQLite/AutoRebuildSchemaBase.pm line 304
    Cpanel::SQLite::AutoRebuildSchemaBase::_setup_schema("Cpanel::Backup::Transport::DB", Cpanel::DBI::SQLite::db=HASH(0x40ef4e8)) called at /usr/local/cpanel/Cpanel/Backup/Transport/DB.pm line 64
    Cpanel::Backup::Transport::DB::dbconnect("Cpanel::Backup::Transport::DB") called at /usr/local/cpanel/Cpanel/Backup/Transport/History.pm line 58
    Cpanel::Backup::Transport::History::new("Cpanel::Backup::Transport::History") called at /usr/local/cpanel/Whostmgr/API/1/Backup.pm line 572
    Whostmgr::API::1::Backup::backup_set_list_combined() called at whostmgr/bin/whostmgr5.pl line 1263
    main::restoremenu("restoremenu") called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 259
    Whostmgr::Dispatch::_do_call("restoremenu", HASH(0x3ac0e90), HASH(0x3ad20a0)) called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 157
    Whostmgr::Dispatch::dispatch("restoremenu", 17, ARRAY(0x3ad1440)) called at whostmgr/bin/whostmgr5.pl line 280
How to fix this?

Thanbk you.
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,296
1,271
313
Houston
Hello @zlygis

This issue is part of the internal case CPANEL-24505 If the transport database(/backup/transports.db), is corrupted or present but empty, the database is not automatically rebuilt. The current workaround is to move/rename the database entirely by doing the following for example :

I made a directory for the sqlite db to go into:
Code:
mkdir /root/backup_transportdb
Then moved the db to the newly created directory
Code:
mv /backup/transports.db /root/backup_transportdb/transports.db
Then run the backup with the force flag (or wait for it to run again)

Code:
/usr/local/cpanel/bin/backup --force
If you are running an unsupported backup mount type such as CIFS it may be possible that this workaround will not function correctly.

We'll also update this thread when the issue has been resolved or if there are any further updates.
 

zlygis

Registered
Jun 2, 2014
4
0
1
cPanel Access Level
Root Administrator
Suggested solution did not worked. Waited for update. Updated to latest cPamel/WHM. Still get the same error:

Code:
(XID wy4784) The system received an error from the “SQLite” database “/backup/transports.db”: SQLITE_BUSY (database is locked) at /usr/local/cpanel/Cpanel/DBI.pm line 188.
    Cpanel::DBI::_error_handler("DBD::SQLite::db do failed: database is locked", Cpanel::DBI::SQLite::db=HASH(0x32ed630), undef) called at /usr/local/cpanel/Cpanel/SQLite/AutoRebuildSchemaBase.pm line 304
    Cpanel::SQLite::AutoRebuildSchemaBase::_setup_schema("Cpanel::Backup::Transport::DB", Cpanel::DBI::SQLite::db=HASH(0x32ed630)) called at /usr/local/cpanel/Cpanel/Backup/Transport/DB.pm line 64
    Cpanel::Backup::Transport::DB::dbconnect("Cpanel::Backup::Transport::DB") called at /usr/local/cpanel/Cpanel/Backup/Transport/History.pm line 58
    Cpanel::Backup::Transport::History::new("Cpanel::Backup::Transport::History") called at /usr/local/cpanel/Whostmgr/API/1/Backup.pm line 572
    Whostmgr::API::1::Backup::backup_set_list_combined() called at whostmgr/bin/whostmgr5.pl line 1263
    main::restoremenu("restoremenu") called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 259
    Whostmgr::Dispatch::_do_call("restoremenu", HASH(0x2cc0050), HASH(0x2cd1240)) called at /usr/local/cpanel/Whostmgr/Dispatch.pm line 157
    Whostmgr::Dispatch::dispatch("restoremenu", 17, ARRAY(0x2cd05e0)) called at whostmgr/bin/whostmgr5.pl line 280
BTW What do you mean "unsupported backup mount type such as CIFS"? We used CIFS as a backup point for more then 4 years and it was working flawlesly.
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,296
1,271
313
Houston
BTW What do you mean "unsupported backup mount type such as CIFS"? We used CIFS as a backup point for more then 4 years and it was working flawlesly.

CIFS has never been supported, whether or not it worked without issue. This is clearly noted in our documentation here:


  • We strongly recommend that you do not perform backups to remote filesystems (for example, NFS, CIFS, smbfs, or other types of network drive systems). While you can back up directly to a remote filesystem, cPanel & WHM does not support this configuration. We strongly recommend that you work with a qualified system administrator to manage this custom backup path and avoid potential risks.
Unfortunately if you are running CIFS there is no supported workaround at this time. You might be able to rectify the issue by ensuring that the CIFS mount is configured according to the guidelines here: How to Resolve CIFS-mounted Backup Drive Permissions Errors - cPanel Knowledge Base - cPanel Documentation but this is something you'd need to work with your system administrator on and we do not guarantee this will resolve the issue.
 
Last edited: