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:
    397
    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 <[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 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:
    47,529
    Likes Received:
    2,181
    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:
    397
    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:
    47,529
    Likes Received:
    2,181
    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:
    397
    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:
    47,529
    Likes Received:
    2,181
    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:
    47,529
    Likes Received:
    2,181
    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. baronn

    SOLVED [CPANEL-23812] update_db_cache cron job failing

    baronn, Nov 7, 2018, in forum: General Discussion
    Replies:
    5
    Views:
    532
    cPanelMichael
    Nov 13, 2018
  2. mauinet

    Apache 500 errors not logging

    mauinet, Jul 11, 2019, in forum: EasyApache
    Replies:
    6
    Views:
    145
    cPanelLauren
    Jul 15, 2019 at 2:43 PM
  3. roliboli

    Timeout errors with php-fpm php script

    roliboli, Jun 18, 2019, in forum: EasyApache
    Replies:
    1
    Views:
    192
    Infopro
    Jun 18, 2019
  4. suphatchai

    Table is marked as crashed and should be repaired errors

    suphatchai, Jun 14, 2019, in forum: Database Discussion
    Replies:
    6
    Views:
    236
    suphatchai
    Jun 14, 2019
  5. delalibera

    RPM errors with update

    delalibera, Jun 1, 2019, in forum: General Discussion
    Replies:
    2
    Views:
    346
    cPanelMichael
    Jun 3, 2019

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