Backup error SQLITE_CANTOPEN (unable to open database file)

Guilherme Paixao

Registered
Jul 17, 2018
2
0
1
Brasil
cPanel Access Level
DataCenter Provider
Boa Tarde a Todos,

Estou com um erro na rotina de backup alertando SQLITE_CANTOPEN (unable to open database file).

Analisei o log mas nao sei como resolver podem me ajudar?,

Segue log. Ele repete o mesmo erro para todos os usuários.

[2018-07-16 03:00:01 -0300] info [backup] Setting I/O priority to reduce system load: best-effort: prio 6
[2018-07-16 03:00:01 -0300] info [backup] Pruning metadata for backup at /backup/2018-07-16
warn [backup] There was an error pruning the backup dir '/backup/2018-07-16/accounts' for user '***USER***': Cpanel::Exception::Database::Error/(XID qd8f3y) The system received an error from the “SQLite” database “/backup/.meta/***USER***.db”: SQLITE_CANTOPEN (unable to open database file)
at /usr/local/cpanel/Cpanel/Exception/CORE.pm line 336.
Cpanel::Exception::create("Database::Error", ARRAY(0x3fc9e10)) called at /usr/local/cpanel/Cpanel/DBI.pm line 200
Cpanel::DBI::_create_exception(Cpanel::DBI::SQLite::db=HASH(0x3779678), "DBD::SQLite::db selectall_arrayref failed: unable to open dat"..., undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 188
Cpanel::DBI::_error_handler("DBD::SQLite::db selectall_arrayref failed: unable to open dat"..., Cpanel::DBI::SQLite::db=HASH(0x3779678), undef) called at /usr/local/cpanel/Cpanel/Backup/Metadata.pm line 1789
Cpanel::Backup::Metadata::_prune_backup_dir_for_user("***USER***", "/backup/2018-07-16/accounts") called at /usr/local/cpanel/Cpanel/Backup/Metadata.pm line 1112
Cpanel::Backup::Metadata::__ANON__() called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/Try/Tiny.pm line 99
eval {...} called at /usr/local/cpanel/3rdparty/perl/526/lib64/perl5/cpanel_lib/Try/Tiny.pm line 90
Try::Tiny::try(CODE(0x3fca200), Try::Tiny::Catch=REF(0x3f3e130)) called at /usr/local/cpanel/Cpanel/Backup/Metadata.pm line 1117
Cpanel::Backup::Metadata::prune_backup("/backup/2018-07-16") called at /usr/local/cpanel/bin/backup line 370
bin::backup::run("bin::backup") called at /usr/local/cpanel/bin/backup line 119

[2018-07-16 03:00:01 -0300] info [backup] Creating metadata index for backup at /backup/2018-07-16
Cpanel::Exception::IO::FileOpenError/(XID 7rwfxa) The system could not open the “/backup/2018-07-16/accounts/.master.meta” backup.
at /usr/local/cpanel/Cpanel/Exception/CORE.pm line 336.
Cpanel::Exception::create("IO::FileOpenError", "The system could not open the \x{e2}\x{80}\x{9c}[_1]\x{e2}\x{80}\x{9d} backup.", ARRAY(0x30e6e20)) called at /usr/local/cpanel/Cpanel/Backup/Metadata.pm line 224
Cpanel::Backup::Metadata::create_meta_master("/backup/2018-07-16", 1) called at /usr/local/cpanel/bin/backup line 376
bin::backup::run("bin::backup") called at /usr/local/cpanel/bin/backup line 119
[2018-07-16 03:00:01 -0300] info [backup] Final state is Backup::Failure (0)
 

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,295
1,273
313
Houston
Olá @Guilherme Paixao

Se você for para /backup/.meta/***USER***.db sobre o ssh e mover / renomear esse arquivo, o problema persistirá?

Obrigado!

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

Hello @Guilherme Paixao


If you go to /backup/.meta/***USER***.db over ssh and move/rename that file does the issue persist?

Thanks!
 
  • Like
Reactions: Guilherme Paixao

cPanelLauren

Product Owner
Staff member
Nov 14, 2017
13,295
1,273
313
Houston
Oi @Guilherme Paixao

Estou muito feliz em ouvir isso! Por favor, deixe-nos saber se você tiver mais problemas com isso.

Obrigado!

=======================================================================
Hi @Guilherme Paixao

I'm very glad to hear that! Please let us know if you run into any further issues with this.

Thanks!