The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

Cron job error with /usr/local/cpanel/scripts/update_db_cache

Discussion in 'General Discussion' started by Adrianne, Apr 21, 2016.

  1. Adrianne

    Adrianne Registered

    Joined:
    Apr 21, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Denver, CO
    cPanel Access Level:
    Root Administrator
    I have a new dedicated server setup with root access and have still been receiving the following email alerts every 12hrs:

    Subject:
    Cron <root@****> /usr/bin/test -x /usr/local/cpanel/scripts/update_db_cache && /usr/local/cpanel/scripts/update_db_cache

    Message:
    Code:
    Cpanel::Exception/(XID g4es8v) The system failed to load and to parse the file “/var/cpanel/databases/dbindex.db.json” because of an error: (XID gpzbmk) The system failed to parse the JSON stream for the caller “(eval)” because of an error: malformed JSON string, neither tag, array, object, number, string or atom, at character offset 2 (before "(end of string)") at /usr/local/cpanel/Cpanel/JSON.pm line 108.
    
    at /usr/local/cpanel/Cpanel/Transaction/File/BaseReader.pm line 59.
        Cpanel::Transaction::File::BaseReader::__ANON__(Cpanel::Exception::JSONParseError=HASH(0x3964d38)) called at /usr/local/cpanel/3rdparty/perl/514/lib64/perl5/cpanel_lib/Try/Tiny.pm line 103
        Try::Tiny::try(CODE(0x3917878), Try::Tiny::Catch=REF(0x39289e0)) called at /usr/local/cpanel/Cpanel/Transaction/File/BaseReader.pm line 60
        Cpanel::Transaction::File::BaseReader::_init_data_with_catch(Cpanel::Transaction::File::JSONReader=HASH(0x3928398), "path", "/var/cpanel/databases/dbindex.db.json") called at /usr/local/cpanel/Cpanel/Transaction/File/BaseReader.pm line 43
        Cpanel::Transaction::File::BaseReader::new("Cpanel::Transaction::File::JSONReader", "path", "/var/cpanel/databases/dbindex.db.json") called at /usr/local/cpanel/Cpanel/DB/Map/Collection/Index.pm line 96
        Cpanel::DB::Map::Collection::Index::_load_dbindex(Cpanel::DB::Map::Collection::Index=HASH(0x3917200)) called at /usr/local/cpanel/Cpanel/DB/Map/Collection/Index.pm line 42
        Cpanel::DB::Map::Collection::Index::new("Cpanel::DB::Map::Collection::Index", HASH(0x38db6b8)) called at bin/update_db_cache.pl line 52
        Script::Update::DB::Cache::script("Script::Update::DB::Cache") called at bin/update_db_cache.pl line 35
    Any insight on how I may be able to fix this error and prevent the cron from failing and stop receiving these messages would be greatly appreciated.

    My Server Info:
    /etc/redhat-release:CloudLinux release 7.2 (Valeri Kubasov)
    /usr/local/cpanel/version:11.54.0.21
    /var/cpanel/envtype:standard
    CPANEL=release
    Server version: Apache/2.4.18 (Unix)
    Server built: Apr 20 2016 19:07:37
    Cpanel::Easy::Apache v3.32.12 rev9999 +cloudlinux
    PHP 5.6.20 (cli) (built: Apr 20 2016 19:10:45)
    Copyright (c) 1997-2016 The PHP Group
    Zend Engine v2.6.0, Copyright (c) 1998-2016 Zend Technologies
    mysql Ver 14.14 Distrib 5.6.29, for Linux (x86_64) using EditLine wrapper
     
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
    Hello :)

    It's possible the "/var/cpanel/databases/dbindex.db.json" file is corrupt. Please let us know if the following commands help to address the issue:

    Code:
    mv /var/cpanel/databases/dbindex.db.json /root/
    /usr/local/cpanel/bin/dbindex 
    Thank you.
     
  3. Adrianne

    Adrianne Registered

    Joined:
    Apr 21, 2016
    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Denver, CO
    cPanel Access Level:
    Root Administrator
    It has been over 24hrs now and I have received no more error alerts for this specific issue. It appears your commands above did indeed fix it. Thank you for your prompt assistance.
     
  4. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    30,678
    Likes Received:
    648
    Trophy Points:
    113
    cPanel Access Level:
    Root Administrator
Loading...

Share This Page