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!

MySQL Errors showing up in logs

Discussion in 'Database Discussion' started by ukgaz, Mar 23, 2011.

  1. ukgaz

    ukgaz Member

    Joined:
    Aug 18, 2005
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    151
    Hi,

    Was wondering if anyone has seen these errors before:

    File Location: /usr/local/cpanel/logs/error_log

    DBD::mysql::db do failed: Can't find file: 'servers' (errno: 2) at /usr/local/cpanel/Cpanel/Mysql.pm line 1079.
    DBD::mysql::db do failed: Can't find file: 'servers' (errno: 2) at /usr/local/cpanel/Cpanel/Mysql.pm line 1079.
    [2011-03-23 15:01:06 +0300] warn [cpanel] Cpanel::AdminBin::adminrun(mysql) set error in context mysql
    [2011-03-23 15:01:06 +0300] warn [mysql::initcache] Encountered error in mysql::initcache: Error from mysql wrapper: DBDISKUSED|kkgaz_e107|0

    I'm trying to delete some databases, it confirms delete yet they are still in the list, any suggestions?
     
  2. ukgaz

    ukgaz Member

    Joined:
    Aug 18, 2005
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    151
    Looks like it is related, I done a tail -f on the error log and the error popped up again when running the delete database command.

    DBD::mysql::db do failed: Can't find file: 'servers' (errno: 2) at /usr/local/cpanel/Cpanel/Mysql.pm line 1079.
    DBD::mysql::db do failed: Can't find file: 'servers' (errno: 2) at /usr/local/cpanel/Cpanel/Mysql.pm line 1079.
    DBD::mysql::st execute failed: There is no such grant defined for user 'kkgaz_e107' on host 'localhost' at /usr/local/cpanel/Cpanel/Mysql.pm line 1154.
    DBD::mysql::st execute failed: There is no such grant defined for user 'kkgaz_e107556' on host 'localhost' at /usr/local/cpanel/Cpanel/Mysql.pm line 1154.
    DBD::mysql::db do failed: Can't find file: 'servers' (errno: 2) at /usr/local/cpanel/Cpanel/Mysql.pm line 1079.
    DBD::mysql::db do failed: Can't find file: 'servers' (errno: 2) at /usr/local/cpanel/Cpanel/Mysql.pm line 1079.
    [2011-03-23 15:12:50 +0000] warn [cpanel] Cpanel::AdminBin::adminrun(mysql) set error in context mysql
    [2011-03-23 15:12:50 +0000] warn [mysql::initcache] Encountered error in mysql::initcache: Error from mysql wrapper: DBDISKUSED|kkgaz_e107|0
     
  3. ukgaz

    ukgaz Member

    Joined:
    Aug 18, 2005
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    151
  4. ukgaz

    ukgaz Member

    Joined:
    Aug 18, 2005
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    151
    Nope, didn't work
     
  5. cPanelTristan

    cPanelTristan Quality Assurance Analyst
    Staff Member

    Joined:
    Oct 2, 2010
    Messages:
    7,609
    Likes Received:
    32
    Trophy Points:
    238
    Location:
    somewhere over the rainbow
    cPanel Access Level:
    Root Administrator
    Hello ukgaz,

    It appears you've opened up a ticket (1304525) on our system about this issue today. If you can update us to the results of the ticket on completion.

    Thanks.
     
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...
  6. ukgaz

    ukgaz Member

    Joined:
    Aug 18, 2005
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    151
    Will do, hopefully your guys will find a solution :)
     
  7. ukgaz

    ukgaz Member

    Joined:
    Aug 18, 2005
    Messages:
    21
    Likes Received:
    0
    Trophy Points:
    151
    Ok first we checked the privilege tables we're all ok with

    mysql_fix_privilege_tables --password=[YOUR PASSWORD] --verbose

    Then your guys restored /var/lib/mysql/mysql/servers.MYI and MYD as these we're not there for some strange reason, so in this case people with this issue may be better of raising a ticket with cpanel unless /scripts/mysqlup --force could fix this
     
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