[CPANEL-23812] update_db_cache cron job failing

Hello, whm/cpanelupdated during the night to v76.0.4 and now I am getting these cron emails from the system: [QUOTE]Cron /usr/bin/test -x /usr/local/cpanel/scripts/update_db_cache && /usr/local/cpanel/scripts/update_db_cache

Cpanel::Exception::Database::Error/(XID f5zcyk) The system received an error from the "MySQL" database "mysql": 1053 (Server shutdown in progress)
 at /usr/local/cpanel/Cpanel/DBI.pm line 200.
        Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::st=HASH(0x1fa7910), "DBD::mysql::st execute failed: Server shutdown in progress", undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 188
        Cpanel::DBI::_error_handler("DBD::mysql::st execute failed: Server shutdown in progress", Cpanel::DBI::Mysql::st=HASH(0x1fa7910), undef) called at bin/update_db_cache.pl line 336
        Script::Update::DB::Cache::can_get_mysql_usage(HASH(0x1f9fd20), HASH(0xde0168), Cpanel::DB::Map::Collection::Index=HASH(0x1fe48e0)) called at bin/update_db_cache.pl line 63

        Script::Update::DB::Cache::script("Script::Update::DB::Cache") called at bin/update_db_cache.pl line 36

Can anyone shed any light as to why I am getting there? I have tried /usr/local/cpanel/scripts/upcp and forcing upgrade and fixrpmBUt still getting these cron emails. The sites o this vpsare working fine. logs dont shpw anything. A bit stummped as to why all of a sudden after nightly upgrade these emails are now coming through!

cPanelMichael

November 07, 2018 13:47

Hello @baronn, Can you open a

baronn

November 08, 2018 10:22

November 08, 2018 12:36

November 08, 2018 15:05

Hi @baronn, I'm glad to see you were able to get the ticket opened. To update, internal case CPANEL-23812 is open to address an issue where the /usr/local/cpanel/scripts/update_db_cache cron job fails when the MySQL service restart (triggered by the /usr/local/cpanel/bin/mysqluserstore cron job) doesn't finish quickly enough. I'll monitor this case and update this thread with more information as it becomes available. In the meantime, the following steps are available as a temporary workaround: 1. Login via SSH as root. 2. Edit the root crontab using the "crontab -e" command. This will open the contents of the crontab file in the default system text editor. 3. Modify the following line: 30 */2 * * * /usr/local/cpanel/bin/mysqluserstore >/dev/null 2>&1
To: 25 */2 * * * /usr/local/cpanel/bin/mysqluserstore >/dev/null 2>&1
4. Save the file and exit. This will run the conflicting cron job at a different minute. Thank you.

November 13, 2018 19:46

Hello Everyone, To update, this is fixed in cPanel & WHM version here and see which build is published to each release tier by clicking

[CPANEL-23812] update_db_cache cron job failing

Comments

Didn't find what you were looking for?