Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

Backup error SQLITE_CANTOPEN (unable to open database file)

Discussion in 'Discussões em Português' started by Guilherme Paixao, Jul 17, 2018.

  1. Guilherme Paixao

    Guilherme Paixao Registered

    Joined:
    Jul 17, 2018
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    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)
     
  2. cPanelLauren

    cPanelLauren Forums Analyst II
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    3,871
    Likes Received:
    280
    Trophy Points:
    193
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    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!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    Guilherme Paixao likes this.
  3. Guilherme Paixao

    Guilherme Paixao Registered

    Joined:
    Jul 17, 2018
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Brasil
    cPanel Access Level:
    DataCenter Provider
  4. cPanelLauren

    cPanelLauren Forums Analyst II
    Staff Member

    Joined:
    Nov 14, 2017
    Messages:
    3,871
    Likes Received:
    280
    Trophy Points:
    193
    Location:
    Houston
    cPanel Access Level:
    DataCenter Provider
    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!
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
Loading...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice