SOLVED [CPANEL-23812] update_db_cache cron job failing

baronn

Member
Dec 27, 2017
24
6
3
manchester
cPanel Access Level
Root Administrator
Hello,

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

Code:
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!
 

baronn

Member
Dec 27, 2017
24
6
3
manchester
cPanel Access Level
Root Administrator
Hello @baronn,

Can you open a support ticket so we can take a closer look at the affected system? Let me know the ticket number once it's opened and I'll link this thread to it.

Thank you.
Would love too BUT the account/support ticket login is not recognizing my login details and isnt even sending me a password reset reminder! trying to create a new account states that my email address already exists (which it should as I have used it for support in the past) SO stuck in limbo!!

I am getting yourforum replies no problems BUT the password reset isnt working :(

Password Reset
If the email address you entered is associated with a valid ticket system account, you will be emailed a link that will allow you to reset your password.
New Account Creation
An account already exists with this email address. Click here to reset your password.
 
Last edited:

baronn

Member
Dec 27, 2017
24
6
3
manchester
cPanel Access Level
Root Administrator
Hello @baronn,

Can you open a support ticket so we can take a closer look at the affected system? Let me know the ticket number once it's opened and I'll link this thread to it.

Thank you.
finally after numerous pasword reset attempts etc i got the email to reset passowrd! wow what a confusing and arkward process that was.

In any case here is the ticket id: Your Support Request ID is: 10676311
 

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,911
2,233
363
cPanel Access Level
DataCenter Provider
Twitter
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:

Code:
30 */2 * * * /usr/local/cpanel/bin/mysqluserstore >/dev/null 2>&1
To:

Code:
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.
 

cPanelMichael

Technical Support Community Manager
Staff member
Apr 11, 2011
47,911
2,233
363
cPanel Access Level
DataCenter Provider
Twitter
Hello Everyone,

To update, this is fixed in cPanel & WHM version 76.0.7:

Fixed case CPANEL-23812: Adjust time of mysqluserstore cron to avoid conflicts with update_db_cache

You can learn more about our release tiers by clicking here and see which build is published to each release tier by clicking here.

Thank you.