Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

update_db_cache errors after update to cPanel 70

Discussion in 'Database Discussion' started by Bdzzld, May 30, 2018.

Tags:
  1. Bdzzld

    Bdzzld Well-Known Member

    Joined:
    Apr 3, 2004
    Messages:
    391
    Likes Received:
    4
    Trophy Points:
    168
    Hi,

    After the recent update from cPanel 68 to 70, we receive the following error on one of our cPanel servers multiple times a day:

    Cron <root@SERVERNAME> /usr/bin/test -x /usr/local/cpanel/scripts/update_db_cache && /usr/local/cpanel/scripts/update_db_cache :
    Code:
    Cpanel::Exception::Database::Error/(XID qv4dmw) The system received an error from the “MySQL” database “mysql”: 1143 (SELECT command denied to user ''@'localhost' for column 'sid' in table 'webform_submitted_data')
 at /usr/local/cpanel/Cpanel/Exception/CORE.pm line 336.
        Cpanel::Exception::create("Database::Error", ARRAY(0x2fabc78)) called at /usr/local/cpanel/Cpanel/Exception.pm line 61
        Cpanel::Exception::__ANON__(__CPANEL_HIDDEN__, ARRAY(0x2fabc78)) called at /usr/local/cpanel/Cpanel/DBI.pm line 200
        Cpanel::DBI::_create_exception(Cpanel::DBI::Mysql::st=HASH(0x2f8a2d8), "DBD::mysql::st execute failed: SELECT command denied to user "..., undef) called at /usr/local/cpanel/Cpanel/DBI.pm line 188
        Cpanel::DBI::_error_handler("DBD::mysql::st execute failed: SELECT command denied to user "..., Cpanel::DBI::Mysql::st=HASH(0x2f8a2d8), undef) called at bin/update_db_cache.pl line 336
        Script::Update::DB::Cache::can_get_mysql_usage(HASH(0xd8a8b8), HASH(0xe1ab28), Cpanel::DB::Map::Collection::Index=HASH(0x2f744f0)) 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
    Any advise would be appreciated.
    Thanks.
     
    #1 Bdzzld, May 30, 2018
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,384
    Likes Received:
    1,951
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @Bdzzld,

    Are you able to access cPanel for the account associated with the database referenced in that error message? If so, browse to cPanel >> MySQL Databases and remove the referenced MySQL user from that database, and then re-add that user to the database.

    Let me know if that helps.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #2 cPanelMichael, May 30, 2018
  3. Bdzzld

    Bdzzld Well-Known Member

    Joined:
    Apr 3, 2004
    Messages:
    391
    Likes Received:
    4
    Trophy Points:
    168
    @cPanelMichael : There is no MySQL user mentioned in the error message as far as I can tell.
     
    #3 Bdzzld, May 30, 2018
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,384
    Likes Received:
    1,951
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @Bdzzld,

    Could you open a support ticket so we can take a closer look at the affected system and see why that error is occurring? You can post the ticket number here and we will link this thread to the ticket.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #4 cPanelMichael, May 30, 2018
  5. Bdzzld

    Bdzzld Well-Known Member

    Joined:
    Apr 3, 2004
    Messages:
    391
    Likes Received:
    4
    Trophy Points:
    168
    @cPanelMichael: The ticket was opened as requested:

     
    #5 Bdzzld, May 31, 2018
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,384
    Likes Received:
    1,951
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello @Bdzzld,

    Thanks, I'm monitoring the support ticket and will update this thread with the outcome once it's complete.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #6 cPanelMichael, May 31, 2018
  7. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    45,384
    Likes Received:
    1,951
    Trophy Points:
    363
    cPanel Access Level:
    Root Administrator
    Twitter:
    Hello,

    To update, it looks like this was the result of an improperly added security definer on the view associated with one of the database users on the system.

    Thank you.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
    #7 cPanelMichael, Jun 6, 2018
(You must log in or sign up to post here.)
Loading...
Similar Threads - update_db_cache errors update
  1. Nirjonadda

    SOLVED update_db_cache errors during update to cPanel 62

    Nirjonadda, Jan 6, 2017, in forum: General Discussion
    Replies:
    6
    Views:
    1,158
    cPanelMichael
    Jan 20, 2017
  2. baronn

    SOLVED [CPANEL-23812] update_db_cache cron job failing

    baronn, Nov 7, 2018, in forum: General Discussion
    Replies:
    5
    Views:
    209
    cPanelMichael
    Nov 13, 2018
  3. Wabun

    New Thread Use of undefined constant roundcube errors

    Wabun, Dec 9, 2018 at 12:56 AM, in forum: E-mail Discussion
    Replies:
    0
    Views:
    100
    Wabun
    Dec 9, 2018 at 12:56 AM
  4. SJR

    Update RPM Errors

    SJR, Dec 3, 2018, in forum: General Discussion
    Replies:
    2
    Views:
    187
    cPanelLauren
    Dec 5, 2018 at 12:03 PM
  5. Kamil Brand Nova

    In Progress [CPANEL-22678] eximstats_spam_check errors

    Kamil Brand Nova, Nov 28, 2018, in forum: Security
    Replies:
    1
    Views:
    229
    cPanelMichael
    Nov 28, 2018

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice