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.

mysql-db-usage.json missing

Discussion in 'General Discussion' started by daveboulter42, Mar 9, 2016.

  1. daveboulter42

    daveboulter42 Member

    Joined:
    Oct 20, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Reseller Owner
    Hi,

    When cron runs:
    /usr/bin/test -x /usr/local/cpanel/scripts/update_db_cache && /usr/local/cpanel/scripts/update_db_cache

    we get errors like:

    Code:
    Cpanel::Exception::IO::ChownError/(XID rj6pnv) The system failed to set the user ID to “0” and the group ID to “508” on “/var/cpanel/datastore/xxxxxx/mysql-db-usage.json” because of an error: No such file or directory  at /usr/local/cpanel/Cpanel/Exception.pm line 183.
        Cpanel::Exception::new("Cpanel::Exception::IO::ChownError", HASH(0x298f0d8)) called at /usr/local/cpanel/Cpanel/Exception.pm line 75
        Cpanel::Exception::__create("IO::ChownError", HASH(0x298f0d8)) called at /usr/local/cpanel/Cpanel/Autodie.pm line 473
        Cpanel::Autodie::chown(0, 508, "/var/cpanel/datastore/xxxxxx/mysql-db-usage.json") called at /usr/local/cpanel/Cpanel/CacheFile.pm line 232
        Cpanel::CacheFile::_chown_path(__CPANEL_HIDDEN__, __CPANEL_HIDDEN__, __CPANEL_HIDDEN__, __CPANEL_HIDDEN__) called at /usr/local/cpanel/Cpanel/CacheFile.pm line 130
        Cpanel::CacheFile::save("Cpanel::Mysql::DiskUsage", HASH(0x2a355c8), "xxxxxx") called at bin/update_db_cache.pl line 115
        Script::Update::DB::Cache::__ANON__() called at /usr/local/cpanel/3rdparty/perl/514/lib64/perl5/cpanel_lib/Try/Tiny.pm line 80
        eval {...} called at /usr/local/cpanel/3rdparty/perl/514/lib64/perl5/cpanel_lib/Try/Tiny.pm line 71
        Try::Tiny::try(CODE(0x2a3e490), Try::Tiny::Catch=REF(0x2a05980)) called at bin/update_db_cache.pl line 122
        Script::Update::DB::Cache::script("Script::Update::DB::Cache") called at bin/update_db_cache.pl line 35
    
    
     
    #1 daveboulter42, Mar 9, 2016
    Last edited by a moderator: Mar 9, 2016
  2. James-L

    James-L Registered

    Joined:
    Mar 10, 2016
    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    1
    Location:
    Canterbury
    cPanel Access Level:
    Root Administrator
    I also get this error, however I get:
    Code:
    Cpanel::Exception::IO::ChownError/(XID 53ecvg) The system failed to set the user ID to “0† and the group ID to “502† on “/var/cpanel/datastore/*domain*/mysql-db-usage.json† because of an error: No such file or directory
     
  3. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

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

    I've seen this happen on systems with multiple UID 0 users. Could you browse to "WHM >> Service Manager" and disable "Name Service Cache Daemon" to see if the issue persists? You can test this by manually running the following command:

    Code:
    /usr/local/cpanel/scripts/update_db_cache
    Thank you.
     
  4. daveboulter42

    daveboulter42 Member

    Joined:
    Oct 20, 2014
    Messages:
    6
    Likes Received:
    0
    Trophy Points:
    1
    cPanel Access Level:
    Reseller Owner
    Thanks
    Yes when run by hand works fine.
    yes I have two UID 0 users. I wanted a backdoor login just in case. I should implement that better.
     
  5. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

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

Share This Page