mysql-db-usage.json missing

daveboulter42

Member
Oct 20, 2014
12
0
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
 
Last edited by a moderator:

James-L

Registered
Mar 10, 2016
2
0
1
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
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,908
2,218
463
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.
 

daveboulter42

Member
Oct 20, 2014
12
0
1
cPanel Access Level
Reseller Owner
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.
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.