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.
     
  2. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,895
    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...
  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.
     
  4. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,895
    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...
  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:

     
  6. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,895
    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...
  7. cPanelMichael

    cPanelMichael Technical Support Community Manager
    Staff Member

    Joined:
    Apr 11, 2011
    Messages:
    44,802
    Likes Received:
    1,895
    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...
Loading...

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.
    Dismiss Notice